GLPI 11: Error in Administration->Statecheck Rules->View Rule (#40) "An unexpected error occurred"

[AlthausOV]

https://ovobs01.oventrop.de/plugins/statecheck/front/rule.form.php?id=40
at register "Actions"

glpi.CRITICAL: *** Uncaught PHP Exception Exception: "Executing direct queries is not allowed!" at DBmysql.php line 343
Backtrace :
./src/DBmysql.php:343
...etplace/statecheck/inc/ruleaction.class.php:311 DBmysql->query()
./marketplace/statecheck/inc/rule.class.php:726 PluginStatecheckRuleAction->getStatecheckRuleActions()
./marketplace/statecheck/inc/rule.class.php:2910 PluginStatecheckRule->getStatecheckRuleWithCriteriasAndActions()
./src/CommonGLPI.php:694 PluginStatecheckRule::displayTabContentForItem()
./ajax/common.tabs.php:108 CommonGLPI::displayStandardTab()
...Glpi/Controller/LegacyFileLoadController.php:64 require()
./vendor/symfony/http-kernel/HttpKernel.php:181 Glpi\Controller\LegacyFileLoadController->__invoke()
./vendor/symfony/http-kernel/HttpKernel.php:76 Symfony\Component\HttpKernel\HttpKernel->handleRaw()
./vendor/symfony/http-kernel/Kernel.php:197 Symfony\Component\HttpKernel\HttpKernel->handle()
./public/index.php:70 Symfony\Component\HttpKernel\Kernel->handle()

[AlthausOV]

Hi!
The problem is, that direct SQLs are no more allowed with GLPI 11.

Solution may be to replace all $DB->query(..) with $DB->doQuery(...) in statecheck/inc/*.php

At least the GUI errors are gone with that modification.

[AlthausOV]

sed -i "s/query(/doQuery(/g" *.php

is your friend if this "solution" is correct.