search

ericferon / glpi-statecheck

GLPI plugin for checking form fields, based on rules
GNU General Public License v2.0
4 stars 4 forks source link

Error in group editing form - Table glpi_plugin_statecheck_targetstates not found #29

Open ratado opened 3 months ago

ratado commented 3 months ago

Similar to issue #28, the following error has shown when a group is edited:

image

_SQL Error "1146": Table 'glpi.glpi_plugin_statecheck_targetstates' doesn't exist in query "SHOW COLUMNS FROM glpi_plugin_statecheck_targetstates"_

Table glpi.glpi_plugin_statecheck_targetstates is not included in empty-1.0.2.sql file (the most updated sql file). Maybe is it missing?

To simulate this error, enable the Debug mode and access a group form of an existent group: https://my.glpi/front/group.form.php?id=1

ericferon commented 3 months ago

Hi, Same answer as issue #28 : I cannot repeat your problem. Can you add the error messages from sql-errors.log and/or php-errors.log related to your statecheck problems ? K.r,

ratado commented 3 months ago

Here is the sql-errors.log:

_[2024-08-22 10:20:13] glpisqllog.ERROR: DBmysql::doQuery() in /var/www/html/glpi/src/DBmysql.php line 403 *** MySQL query error: SQL: SHOW COLUMNS FROM glpi_plugin_statecheck_targetstates Error: Table 'glpi.glpi_plugin_statecheck_targetstates' doesn't exist Backtrace : src/DBmysql.php:959 DBmysql->doQuery() src/CommonDBTM.php:617 DBmysql->listFields() src/CommonDBTM.php:3168 CommonDBTM->getEmpty() src/CommonDBTM.php:2617 CommonDBTM->isEntityAssign() .../twig/twig/src/Extension/CoreExtension.php:1635 CommonDBTM->canUnrecurs() ...tes/5f/5fc311bf420eddbc2b4126d0bedce0c0.php:360 twig_get_attribute() vendor/twig/twig/src/Template.php:394 __TwigTemplatec634573e04b8bd49056f695c95266ec4->doDisplay() vendor/twig/twig/src/Template.php:367 Twig\Template->displayWithErrorHandling() vendor/twig/twig/src/Template.php:379 Twig\Template->display() vendor/twig/twig/src/TemplateWrapper.php:38 Twig\Template->render() src/Application/View/TemplateRenderer.php:163 Twig\TemplateWrapper->render() src/CommonGLPI.php:1110 Glpi\Application\View\TemplateRenderer->render() src/CommonGLPI.php:1228 CommonGLPI->showNavigationHeader() src/CommonDBTM.php:6566 CommonGLPI->display() front/group.form.php:122 CommonDBTM::displayFullPageForItem() public/index.php:82 require()

There is no error in php-errors.log. To reproduce the problem:

  1. The statecheck and archisw must be installed
  2. Create or edit a group in Administration -> Groups menu
  3. Or access the link http://your_glpi_instance/front/group.form.php?id=1

I'll try to install a new GLPI instance to check if the problem persists. If no, then maybe there is a problem in the rules created by some reason.