Error in group editing form - Table glpi_plugin_statecheck_targetstates not found

[ratado]

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

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]

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]

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 _TwigTemplate_c634573e04b8bd49056f695c95266ec4->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.

[ratado]

The issue persists in a new GLPI instance.

sql-errors-statecheck.log

[jlilio]

This issue still persist in GLPI v11.0.4, fyi.

Here's the error log in php-errors.log for your reference:

glpi.CRITICAL: *** Uncaught PHP Exception Twig\Error\RuntimeError: "An exception has been thrown during the rendering of a template ("MySQL query error: Unknown column 'glpi_plugin_statecheck_rules.groups_id' in 'WHERE' (1054) in SQL query "SELECT COUNT(*) AS cpt FROM glpi_plugin_statecheck_rules WHERE (((glpi_plugin_statecheck_rules.groups_id = '1'))) AND NOT (entities_id IN ('0', '12', '11', '2'))".") in "components/form/header_content.html.twig" at line 150." at header_content.html.twig line 150

[ericferon]

Hi, jlilio.
It seems that your issue is different.
Can you create a new issue, insert the full backtrace and explain how to repeat the problem ?
Thank you,