Forum GLPI-Project

doesntMatter

Member

Registered: 2016-07-06

Posts: 108

Database Problem

Hello,

while upgrading glpi from 10.0.1 to 10.0.3 I got the information that there are Problems with the Database:

glpi@glpi:/var/www/glpi$ sudo php bin/console glpi:database:check_schema_integrity

Das Tabellenschema unterscheidet sich für die Tabelle "glpi_budgets".
--- Expected database schema
+++ Current database schema
@@ @@
   KEY `budgettypes_id` (`budgettypes_id`),
   KEY `date_creation` (`date_creation`),
   KEY `date_mod` (`date_mod`),
-  KEY `end_date` (`end_date`),
   KEY `entities_id` (`entities_id`),
   KEY `is_deleted` (`is_deleted`),
   KEY `is_recursive` (`is_recursive`),
Das Tabellenschema unterscheidet sich für die Tabelle "glpi_knowbaseitems".
--- Expected database schema
+++ Current database schema
@@ @@
   FULLTEXT KEY `answer` (`answer`),
   FULLTEXT KEY `fulltext` (`name`,`answer`),
   FULLTEXT KEY `name` (`name`),
-  KEY `begin_date` (`begin_date`),
   KEY `date_creation` (`date_creation`),
   KEY `date_mod` (`date_mod`),
-  KEY `end_date` (`end_date`),
   KEY `is_faq` (`is_faq`),
   KEY `users_id` (`users_id`)
)
Das Tabellenschema unterscheidet sich für die Tabelle "glpi_users".
--- Expected database schema
+++ Current database schema
@@ @@
   UNIQUE KEY `unicityloginauth` (`name`,`authtype`,`auths_id`),
   KEY `authitem` (`authtype`,`auths_id`),
   KEY `auths_id` (`auths_id`),
-  KEY `begin_date` (`begin_date`),
   KEY `date_creation` (`date_creation`),
   KEY `date_mod` (`date_mod`),
   KEY `default_requesttypes_id` (`default_requesttypes_id`),
-  KEY `end_date` (`end_date`),
   KEY `entities_id` (`entities_id`),
   KEY `firstname` (`firstname`),
   KEY `groups_id` (`groups_id`),
glpi@glpi:/var/www/glpi$

I think the best is to change the database strukture that it fit's to the expections of glpi. Unfortenately I'm not that big database crack - so - what should I have to do?

cconard96

Moderator

Registered: 2018-07-31

Posts: 2,813

Website

Re: Database Problem

Hello, from the output of that command, it looks like the only thing missing are some index keys which shouldn't affect the functionality of GLPI. They are only really used to optimize some queries.

If you want to add them the syntax for MySQL is like:
ALTER TABLE `glpi_budgets` ADD INDEX `end_date` (`end_date`);

---

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.

doesntMatter

Member

Registered: 2016-07-06

Posts: 108

Re: Database Problem

Hello, from the output of that command, it looks like the only thing missing are some index keys which shouldn't affect the functionality of GLPI. They are only really used to optimize some queries.

If you want to add them the syntax for MySQL is like:
ALTER TABLE `glpi_budgets` ADD INDEX `end_date` (`end_date`);

Great, Thank you!