Error in group editing form - group_id column not found

[ratado]

When access a group form, the following error has shown (debug mode enabled):

Unknown column 'glpi_plugin_statecheck_rules.groups_id' in 'where clause' in query "SELECT COUNT(*) AS cpt FROM glpi_plugin_statecheck_rules, glpi_entities WHERE (((glpi_plugin_statecheck_rules.groups_id = '679'))) AND glpi_plugin_statecheck_rules.entities_id = glpi_entities.id AND NOT (glpi_entities.entities_id IN ('0', '111'))"

In fact, the column groups_id does not exist in table glpi_plugin_statecheck_rules. The same column does not exist in file empty-1.0.2.sql.

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,
I cannot repeat your problem.
What do you check on this "Group" form ? What is your statecheck rule configuration for this form ?
K.r,

[ratado]

Hi,

I use statecheck with Archisw Plugin. Archisw plugin created some rules, maybe it is related with the rule indicated above?

I got the text bellow from SQL 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: SELECT COUNT(*) AS cpt FROM glpi_plugin_statecheck_rules, glpi_entities WHERE (((glpi_plugin_statecheck_rules.groups_id = '678'))) AND glpi_plugin_statecheck_rules.entities_id = glpi_entities.id AND NOT (glpi_entities.entities_id IN ('0', '111'))
Error: Unknown column 'glpi_plugin_statecheck_rules.groups_id' in 'where clause'
Backtrace :
src/DBmysqlIterator.php:112 DBmysql->doQuery()
src/DBmysql.php:1109 DBmysqlIterator->execute()
src/DbUtils.php:524 DBmysql->request()
inc/db.function.php:192 DbUtils->countElementsInTable()
src/CommonDBTM.php:2646 countElementsInTable()
.../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()

I tried to uninstall and reinstall statecheck plugin but the error persists. I'll test uninstalling the archisw plugin too.

[ericferon]

Hi,
Which are the results of your reinstallations ?
Is your problem solved and can I close the issue ?
K.r,

[ratado]

Hi,

The issue persists in a new GLPI instance, as shown in the attached image:

I've also attached the sql-errors.log file.

Although this issue doesn't affect the system's usability. You can choose to investigate and resolve the issue or simply close it.

sql-errors-statecheck.log

[ericferon]

Hi,
Thank you for the information.
Can you send a screen copy of the statecheck rule that you defined for this "group" form (StatecheckRule, Criteria and Actions) ?
For me, the root cause is not the rule "Apps structure field groups".
K.r,

[beatstream69]

In our installation (GLPI 10.0.19) this error appears after checking "Child entities" in the group form and saving the group.
After that "Child entities" checkbox became unavailable due to that error.
No rules defined in Setup->Dropdowns->Statecheck->Tables or Administration->Statecheck Rules.
When plugin is disabled, error disappears.

[Giudy]

same in 11.0.5.
uninstalled and reinstalled
we get
MySQL query error: Unknown column 'glpi_plugin_statecheck_rules.groups_id' in 'where clause' (1054) in SQL query "SELECT COUNT(*) AS cpt FROM glpi_plugin_statecheck_rules WHERE (((glpi_plugin_statecheck_rules.groups_id = '1'))) AND NOT (entities_idIN ('0', '0'))".

The plugin is not configured, no rules
previously it was installed togetere with archisw