Error in the right panel of tickets

[LucianaCabrera]

Code of Conduct

• I agree to follow this project's Code of Conduct

Is there an existing issue for this?

• I have searched the existing issues

Version

10.0.16

Bug description

Error in the right panel of tickets,
Whenever I move to another entity, the right ticket panel disappears and I get the following error:
Twig Error (Twig\Error\RuntimeError): "An exception was thrown during rendering of a template ('Empty inputs are not allowed')." in template "/var/www/glpi/templates/components/itilobject/fields_panel.html.twig" on line 216

Relevant log output

[``](url)

I have cleared the rm-rf template cache inside the files/

I have run the command bin/console glpi:cache:clear but there were no changes

[2024-10-17 18:58:54] glpiphplog.CRITICAL: *** Twig Error (Twig\Error\RuntimeError): "An exception has been thrown during the rendering of a template ("Empty IN are not allowed")." in template "/var/www/html/glpi/templates/components/itilobject/fields_panel.html.twig" at line 209
Backtrace :
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()
.../twig/twig/src/Extension/CoreExtension.php:1347 Twig\TemplateWrapper->render()
...tes/2e/2e1acab12523aa17a00f919c92637dc6.php:152 twig_include()
vendor/twig/twig/src/Template.php:394 __TwigTemplate_b00fc822dd5619998d19e5ea023413b4->doDisplay()
vendor/twig/twig/src/Template.php:367 Twig\Template->displayWithErrorHandling()
vendor/twig/twig/src/TemplateWrapper.php:45 Twig\Template->display()
src/Application/View/TemplateRenderer.php:184 Twig\TemplateWrapper->display()
src/Ticket.php:4433 Glpi\Application\View\TemplateRenderer->display()
src/CommonGLPI.php:680 Ticket->showForm()
ajax/common.tabs.php:120 CommonGLPI::displayStandardTab()
public/index.php:82 require()

root@PC-Luciana:/var/www/html/glpi/files/_log#

[LucianaCabrera]

I have a database where this error that was mentioned some time ago is replicated in different versions, I cannot pass it through GitHub since it is a client database, could you contact me please?

[stonebuzz]

Hi @LucianaCabrera

To address this, you can try resetting the entity caches by running the following SQL query:

UPDATE glpi_entities SET ancestors_cache = null, sons_cache = null;

This query clears potential cache issues that might be affecting entity-related data display.

Best regards

[LucianaCabrera]

Perfect, it works, thanks ^^!

[stonebuzz]

@cedric-anne

We need to add this SQL query when we run php bon/console cache:clear to be sure that MySQL "cache" is unset !

[trasher]

@cedric-anne

We need to add this SQL query when we run php bon/console cache:clear to be sure that MySQL "cache" is unset !

If we do that, we must handle all tables that uses a database cache, there are several other cases that would be affected.

[cedric-anne]

@cedric-anne

We need to add this SQL query when we run php bon/console cache:clear to be sure that MySQL "cache" is unset !

Honestly, I think that cache in database should not exist. Also, I guess there is a bug behind this issue. If something is generating invalid data, or if something is not updating these fields correctly, then it should be fixed.

Clearing these values could indeed help, but, in a production environment, people should never have to clear the cache by themselves.