Forum GLPI-Project

danhgt

Member

Registered: 2022-11-23

Posts: 7

Error check_schema_integrity update 10.0.5 to 10.0.14

How can I fix these tables? What commands i need to execute??

php bin/console database:check_schema_integrity
O esquema da tabela difere da tabela "glpi_knowbaseitems".
--- Esquema de banco de dados esperado
+++ Esquema atual do banco de dados
@@ @@
   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`)
)
O esquema da tabela difere da tabela "glpi_users".
--- Esquema de banco de dados esperado
+++ Esquema atual do banco de dados
@@ @@
   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`),

Last edited by danhgt (2024-04-15 14:30:01)