jackburton79/room

GLPI 10.0.7 : Warning message + reservations planning not visible

Opened this issue · 24 comments

FlorianV54 commented

Hello,

Following our recent upgrade from GLPI 10.0.6 to 10.0.7, we have since noticed 2 side effects :

  • A Warning message on pages (eg inside a group page or a task template page).

image

  • In the configuration of a room itself. Under the Reservation menu, there is no/no longer the reservation calendar displayed

image

Thank you in advance for your feedback on these 2 technical points.

Best regards,

jackburton79 commented

I will look into it, but unfortunately I don't have time to do it right now.

FlorianV54 commented

Good morning,

Have you had time to check the 2 technical points that we told you a few days ago ?
Because we will soon (early May) put our GLPI platform into production.

Thank you in advance for your feedback.

Best regards,

jackburton79 commented

Could you attach here the output of these commands, launched from inside mysql client ?

use glpi ;
show create table glpi_plugin_room_rooms ;
show create table glpi_plugin_room_rooms_computers ;

Thanks

FlorianV54 commented

Good Afternoon

Attached below, the result of both requested
glpi.txt

Best Regards,

jackburton79 commented

Thanks. It differs a bit from my test installation.
Does glpi shows you some warning about signed / unsigned ints ?
I remember following the recommendations of glpi and launched the convert / fix scripts.

FlorianV54 commented

Thanks for your feedback.
We're not sure to fully understand your question.
What other check(s) would you need specifically (like SQL commands or others) ?

FlorianV54 commented

To give you a new feedback and try to answer your last question,
we have no other warning (about signed / unsigned ints) than the one we indicated at the opening of this issue (see warning in 1st screenshot upper)

Tell us how we can help you more (because we will put our GLPI platform into production next week)

Best Regards,

jackburton79 commented
FlorianV54 commented

A new installation. Directly with Glpi10.
And the issue specially arrived when we have update v10.0.6 to the last 10.0.7

  • 👍1
jackburton79 commented

I'm setting up a fresh installation of glpi 10 to test this problem.
Are you using the glpi-10 branch, right ?

FlorianV54 commented

glpi10 yes (with the latest version v10.0.7)

jackburton79 commented

I just tried with a new installation of glpi 10.0.0.7, installed the plugin from the glpi-10 branch, and couldn't reproduce the warning.
Of course the calendar isn't visible, but I can't see the warning you're seeing.
Could you trying disinstalling the plugin and reinstalling (warning, you'll lose all the room data) ?

FlorianV54 commented

Thanks for your feedback.

just one question, why "Of course the calendar isn't visible" ?

Last friday, we have already tried to uninstall and reinstall the plugin on our GLPI pre-production ( all the room data have been cleared). Without result. Same warning message after reinstall

FYI our issue specially arrived when we have update GLPI v10.0.6 to the last 10.0.7
Maybe try to repoduce with the same test on your isde. Installing GLPI 10.0.6 and migrate to 10.0.7.

jackburton79 commented

Thanks for your feedback.

just one question, why "Of course the calendar isn't visible" ?

I meant: yes, I'm aware the calendar isn't visible, I can definitely reproduce that bug.
I think it depends on some setting in GLPI 10 where I have to select the full calendar library in the plugin, but I can't find how to do that.

Last friday, we have already tried to uninstall and reinstall the plugin on our GLPI pre-production ( all the room data have been cleared). Without result. Same warning message after reinstall

FYI our issue specially arrived when we have update GLPI v10.0.6 to the last 10.0.7 Maybe try to repoduce with the same test on your isde. Installing GLPI 10.0.6 and migrate to 10.0.7.

I started with GLPI 10.0.0.5 and migrated to 10.0.0.7.

If I understood correctly, you get the warning when you go in the "groups" menu ?

FlorianV54 commented

I meant: yes, I'm aware the calendar isn't visible, I can definitely reproduce that bug.
I think it depends on some setting in GLPI 10 where I have to select the full calendar library in the plugin, but I can't find how to do that.

Well understood on this point. We hope this will be fixable

If I understood correctly, you get the warning when you go in the "groups" menu ?

In groups yes. But also in other places. Example in templates (tasks, solution...)

FlorianV54 commented

This new feedback today, because we have done new research to understand the reason of this warning message (in groups or templates).
And we noticed that the warning message only appears when the visibility to a sub-entity is activated.

Ex. below for the same group.

Sub-entities checked/activated, warning message displayed.
image

Sub-entities, not checked/activated, no warning message
image

FYI below, the entirety of the warning message (if it can help you)

PHP Warning: Invalid relations declared between "glpi_users" and "glpi_plugin_room_rooms" table. Target field "tech_num" is not a foreign key field. in /var/www/glpi/src/DbUtils.php on line 2144 PHP Warning: Invalid relations declared between "glpi_plugin_room_rooms" and "glpi_plugin_room_rooms_computers" table. Target field "rooms_id" is not a foreign key field. in /var/www/glpi/src/DbUtils.php on line 2144 PHP Warning: Invalid relations declared between "glpi_plugin_room_roomtypes" and "glpi_plugin_room_rooms" table. Target field "type" is not a foreign key field. in /var/www/glpi/src/DbUtils.php on line 2144 PHP Warning: Invalid relations declared between "glpi_plugin_room_roomaccessconds" and "glpi_plugin_room_rooms" table. Target field "access" is not a foreign key field. in /var/www/glpi/src/DbUtils.php on line 2144 PHP Warning: Invalid relations declared between "glpi_plugin_room_dropdown1s" and "glpi_plugin_room_rooms" table. Target field "dropdown1" is not a foreign key field. in /var/www/glpi/src/DbUtils.php on line 2144 PHP Warning: Invalid relations declared between "glpi_plugin_room_dropdown1s" and "glpi_plugin_room_rooms" table. Target field "dropdown2" is not a foreign key field. in /var/www/glpi/src/DbUtils.php on line 2144

jackburton79 commented
  • 👍1
FlorianV54 commented

Good morning

This new message today in order to know if you have found any solution this last few days (and our last message), to fix the issues ?

Thank you in advance for your feedback.

Regards,

  • 👍1
FlorianV54 commented

Good morning,

Following your last message two months ago (May 12) were you able to find a solution or a fix ?

Thank you in advance for your feedback.
Regards,

jackburton79 commented

Hi,
About the missing reservation: I tried to dig into the problem, but I think I'm missing something so I asked help on the GLPI forum.
About the other problem: which version of PHP are you using ?

FlorianV54 commented

Morning,
currently we are in PHP 8.2 (since last Thursday) and before in 7.4

FlorianV54 commented

Good morning

This new message today in order to know if you have found any solution since our last message ?

Thank you in advance for your feedback.

Regards,

jackburton79 commented

Hi,
unfortunately my company doesn't use this plugin anymore, so I don't think I could look into these problems

FlorianV54 commented

Arff Ok ! too bad !

However, as you said last July, were you able to get some help on the GLPI forum ?

If not, do you have any leads to share with us ?
So that we can continue to investigate the 2 problems that have been present since 10.0.7 GLPI version.
(i.e. warning message when the visibility to a sub-entity is activated // and reservation calendar no longer displayed).

Thank you in advance for your feedback.

Regards,