Forum GLPI-Project

LukeZ

Member

Registered: 2011-11-17

Posts: 58

Table schema differs for table "glpi_queuednotifications".

After the update from GLPI 10.0.7 to GLPI 10.0.8 I got the message: Table schema differs for table "glpi_queuednotifications".
What should I do manually to correct this problem?

php bin/console database:check_schema_integrity
Table schema differs for table "glpi_queuednotifications".
--- Expected database schema
+++ Current database schema
@@ @@
   `create_time` datetime,
   `documents` text,
   `entities_id` int NOT NULL DEFAULT 0,
-  `event` varchar(255),
   `headers` text,
   `is_deleted` tinyint NOT NULL DEFAULT 0,
   `items_id` int NOT NULL DEFAULT 0,

php bin/console database:update
+-------------------------+-----------+-----------+
|                                  | Current   |                |
+-------------------------+-----------+-----------+
| Database host             | localhost |               |
| Database name           | glpi         |               |
| Database user             | glpi         |               |
| GLPI version               | 10.0.8     | 10.0.8     |
| GLPI database version | 10.0.8     | 10.0.8     |
+-------------------------+-----------+-----------+
No migration needed.

Last edited by LukeZ (2023-07-07 12:28:29)

mchuche

Member

Registered: 2017-02-27

Posts: 39

Re: Table schema differs for table "glpi_queuednotifications".

i got the same problem after the same update

https://forum.glpi-project.org/viewtopic.php?id=287508

Last edited by mchuche (2023-07-07 15:24:58)

LukeZ

Member

Registered: 2011-11-17

Posts: 58

Re: Table schema differs for table "glpi_queuednotifications".

Using HeidiSQL I simply added to the table glpi_queuednotifications the column "event" (type VARCHAR with 255 characters, utf8 encoding, same as the other similar columns).

cconard96

Moderator

Registered: 2018-07-31

Posts: 2,813

Website

Re: Table schema differs for table "glpi_queuednotifications".

This issue was already reported and fixed on GitHub.
https://github.com/glpi-project/glpi/issues/15133

---

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.