Forum GLPI-Project

Vicken

Member

Registered: 2024-03-04

Posts: 22

Table schema differs

Hi all,

Recently did a long awaited update to our GLPI system from 9.4.3 to the latest version (now running 10.0.11). In the meanwhile we also transitioned from MySQL to MariaDB and from IIS 7.0 to IIS 10. So yeah, it was quite a ride. Most of the issues that rose up, 'I've managed to iron away, but I'm a bit lost on this one.

The table glpi_events seems to have a column PRIMARY KEY (`id`) but is not seen as valid by db:check_schema_integrity. Does any of you have an idea on how to proceed? I've pasted the cmd output below.

Table schema differs for table "glpi_events".
--- Expected database schema
+++ Current database schema
@@ @@
   `message` text,
   `service` varchar(255),
   `type` varchar(255),
-  PRIMARY KEY (`id`),
-  KEY `date` (`date`),
-  KEY `item` (`type`,`items_id`),
-  KEY `level` (`level`)
+  PRIMARY KEY (`id`)
)

Thanks a lot!

Last edited by Vicken (2024-03-04 12:27:31)

cconard96

Moderator

Registered: 2018-07-31

Posts: 2,809

Website

Re: Table schema differs

At some point, new indexes were added for that table. However, that part of the relevant version upgrade somehow failed to add them.
Based on the legend, the indexes with a '-' are in the expected schema, but not the current one. The primary key is present in the current and expected schema, so it is OK.
The missing indexes date, item (composite index on type and items_id columns) and level will need added manually.

---

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.

Vicken

Member

Registered: 2024-03-04

Posts: 22

Re: Table schema differs

Thanks a lot, had a look at the keys and your solution seems to be the right one. Thank you!