Forum GLPI-Project

christovamps

Member

Registered: 2016-06-09

Posts: 10

Error upgrade GLPI 9.5.7 to 10.0.0.7

Hi.

I currently use GLPI in version 9.4.6, I updated it to version 9.5.7 and then to 9.5.13. When updating to version 10 I got the following error:

# bin/console db:update
......
SQL Error "1305": PROCEDURE glpi9_4.inserir_entities_hierarchy does not exist in query "UPDATE `glpi_entities` SET `entities_id` = '0' WHERE `id` = '0'"

In DBmysql.php line 1461:
  - Erro na consulta ao banco de dados: UPDATE `glpi_entities` SET `entities_id` = '0' WHERE `id` = '0' - Erro é PROCEDURE glpi9_4.inserir_entities_hierarchy does not exist

If I upgrade directly to 10, I have the same problem. I need help on how to solve this problem.

Thanks in advance.

cconard96

Moderator

Registered: 2018-07-31

Posts: 2,813

Website

Re: Error upgrade GLPI 9.5.7 to 10.0.0.7

Do you have a trigger specified for the glpi_entities table in your database that is referring to a stored procedure that doesn't exist?

GLPI itself doesn't use any triggers or stored procedures in any way and I don't think it did in the past either, so this was a manual change or a plugin (I know of none that do this either).

---

GLPI Collaborator and Plugin Developer.
My non-English comments are automated translations. Sorry for any confusion that causes.
Mes commentaires non anglais sont des traductions automatiques. Désolé pour toute confusion qui cause.
Mis comentarios que no están en inglés son traducciones automáticas. Perdón por cualquier confusión que cause.