Forum GLPI-Project

yumibad86

Member

Registered: 2020-10-01

Posts: 16

SQL Error : Table 'glpi.glpi_notimportedemails' doesn't exist

I'm trying to update glpi from version 9.5.4 to version 10.0.15, but it's giving the following error.

"SQL Error "1932": Table 'glpi.glpi_notimportedemails' doesn't exist in engine in query "ALTER TABLE `glpi_notimportedemails` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci""

Does anyone know how I can fix it?

cconard96

Moderator

Registered: 2018-07-31

Posts: 2,809

Website

Re: SQL Error : Table 'glpi.glpi_notimportedemails' doesn't exist

Does this table exist in the database?

If not, a very old update in GLPI (sometime before 0.85) didn't complete properly and that table was never created.

The SQL to create the table as of 10.0.15:
CREATE TABLE `glpi_notimportedemails` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `from` varchar(255) NOT NULL,
  `to` varchar(255) NOT NULL,
  `mailcollectors_id` int unsigned NOT NULL DEFAULT '0',
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `subject` text,
  `messageid` varchar(255) NOT NULL,
  `reason` int NOT NULL DEFAULT '0',
  `users_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `users_id` (`users_id`),
  KEY `mailcollectors_id` (`mailcollectors_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

---

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.

yumibad86

Member

Registered: 2020-10-01

Posts: 16

Re: SQL Error : Table 'glpi.glpi_notimportedemails' doesn't exist

It worked.
Thanks