You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2019-12-12 12:28:16

renzo
Member
Registered: 2008-10-16
Posts: 43

Problème après upgrade 9.4.4

Bonjour,

Je viens de faire l'upgrade de GLPI 9.4.4 et je me vois dans l'impossibilité d'ajouter de follow-ups dans les tickets

J'obtiens cette erreur
/....
PHP Notice: Undefined index: items_id in /var/www/glpi/inc/itilfollowup.class.php at line 884
PHP Notice: Undefined index: status in /var/www/glpi/inc/ticket.class.php at line 6800
PHP Notice: Undefined index: status in /var/www/glpi/inc/ticket.class.php at line 6809
PHP Notice: Undefined index: status in /var/www/glpi/inc/ticket.class.php at line 6809
PHP Notice: Undefined index: status in /var/www/glpi/inc/ticket.class.php at line 6809
PHP Notice: Undefined index: status in /var/www/glpi/inc/ticket.class.php at line 6809
PHP Notice: Undefined index: status in /var/www/glpi/inc/ticket.class.php at line 6809
PHP Notice: Undefined index: status in /var/www/glpi/inc/ticket.class.php at line 6809
.../




La fenêtre d’édition apparaît bien, mais mon follow-up n'est pas sauvegardé.

Lors de la mise à jour j'avais ce message dans le setup

/...
New rights has been added for personalization, you should review ACLs after update
.../

quelq'un aurait eu le même problème

Merci de votre aide

Offline

#2 2019-12-12 12:50:09

renzo
Member
Registered: 2008-10-16
Posts: 43

Re: Problème après upgrade 9.4.4

une info complementaire j'ai trouvé ceci dans les logs Php

/var/www/glpi/files/_log/php-errors.log


[2019-12-12 11:48:03] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in /var/www/glpi/inc/toolbox.class.php line 658
  *** PHP Notice(8): Undefined index: status
  Backtrace :
  inc/ticket.class.php:6809
  inc/itilfollowup.class.php:884                     Ticket::getSplittedSubmitButtonHtml()
  inc/itilfollowup.class.php:815                     ITILFollowup->showFormButtons()
  ajax/timeline.php:118                              ITILFollowup->showForm()
  {"user":"105@optimus","mem_usage":"0.000\", 1.79Mio)"}
[2019-12-12 11:48:03] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in /var/www/glpi/inc/toolbox.class.php line 658
  *** PHP Notice(8): Undefined index: status
  Backtrace :
  inc/ticket.class.php:6809
  inc/itilfollowup.class.php:884                     Ticket::getSplittedSubmitButtonHtml()
  inc/itilfollowup.class.php:815                     ITILFollowup->showFormButtons()
  ajax/timeline.php:118                              ITILFollowup->showForm()
  {"user":"105@optimus","mem_usage":"0.000\", 1.79Mio)"}
[2019-12-12 11:48:03] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in /var/www/glpi/inc/toolbox.class.php line 658
  *** PHP Notice(8): Undefined index: status
  Backtrace :
  inc/ticket.class.php:6809
  inc/itilfollowup.class.php:884                     Ticket::getSplittedSubmitButtonHtml()
  inc/itilfollowup.class.php:815                     ITILFollowup->showFormButtons()
  ajax/timeline.php:118                              ITILFollowup->showForm()
  {"user":"105@optimus","mem_usage":"0.000\", 1.79Mio)"}
[2019-12-12 11:48:10] glpiphplog.NOTICE: glpi_autoload() in /var/www/glpi/inc/autoload.function.php line 278
TicketFollowup has been replaced by ITILFollowup.  {"user":"105@optimus","mem_usage":"0.003\", 2.63Mio)"}


Je ne suis pas trop développeur mais à l'aise pour modifier le code PHP, mais faut savoir quoi.

Merci d'avance

Offline

#3 2020-01-06 13:10:15

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,273

Re: Problème après upgrade 9.4.4

Les PHP notice ne sont pas bloquant mais juste informationnels.

Lorsque vous validez l'ajout du suivi, vous choisissez quelle valeur dans le bouton ?


CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

Offline

#4 2020-01-06 13:20:49

renzo
Member
Registered: 2008-10-16
Posts: 43

Re: Problème après upgrade 9.4.4

Bonjour,

Merci de la réponse.

En fait j'ai juste un bouton "add" lorsque je valide le follow-up. Puis l'option "not private" "private" ou "direct", "mail", "telephone" etc  c'est pareil  le suivi n'est pas ajouté dans aucun cas.

J'ai l'impression que c'est un form "ITILFollowup" qui ne fonctionne pas.

Merci d'avance

Offline

#5 2020-01-06 13:54:28

renzo
Member
Registered: 2008-10-16
Posts: 43

Re: Problème après upgrade 9.4.4

Autre info :
ajoutant un Suivi de valeur: New, Processing, assigned, pending, solved ou Closed c'est pareil aucun suivi apparait dans l'interface web, il est pas enregistré.
En revanche une alerte mail "Suvi" est envoyé mais elle vide : avec le message

Number of followups : 0


Number of tasks : 0

L'ajout de task fonctionne.

Merci de votre aide

Offline

#6 2020-01-06 15:15:27

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,273

Re: Problème après upgrade 9.4.4

Je n'arrive pas à reproduire en 9.4.5.
Dans cette version il y a eu des modification sur le bouton d'un ticket mais uniquement pour les tickets verrouillés.

Quelle était votre version avant la 9.4.4 ?

Vous avez des messages en mode Debug (paramétrage dans vos préférences) ?


CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

Offline

#7 2020-01-07 10:23:57

renzo
Member
Registered: 2008-10-16
Posts: 43

Re: Problème après upgrade 9.4.4

Bonjour,
je viens de relancer la mise à jour à 9.4.5 depuis la 9.3.0
Et après l’instillation de tous les modules necessaires j'obtiens:

********************

Upgrade
Database connection successful

Database version seems correct (10.1.41) - Perfect!Database version seems correct (10.1.41) - Perfect!
Update to 9.3.1

Task completed. (1 second)
Update to 9.3.2

Task completed. (2 seconds)
Update to 9.4.0

Change of the database layout - glpi_itilfollowups (23 seconds)

Change of the database layout - glpi_itilfollowups (23 seconds)

New rights has been added for personalization, you should review ACLs after update
9.4.0 multiple alter in glpi_itilfollowups - Error during the database query: ALTER TABLE `glpi_itilfollowups` CHANGE `tickets_id` `items_id` int(11) NOT NULL DEFAULT '0' , ADD INDEX `itemtype` (`itemtype`) , DROP INDEX `tickets_id` , ADD INDEX `item_id` (`items_id`) , ADD INDEX `item` (`itemtype`, `items_id`) , ADD `sourceitems_id` int(11) NOT NULL DEFAULT '0' , ADD INDEX `sourceitems_id` (`sourceitems_id`) , ADD `sourceof_items_id` int(11) NOT NULL DEFAULT '0' , ADD INDEX `sourceof_items_id` (`sourceof_items_id`) - Error is Table 'glpi/#sql-ib1175-798752373' already exists
****

à cette étape n'avance plus on dirait qu'il y a plus d'activité dans l'installation jusqu'à rafraîchir la page et apparaît la page de log in.

Merci d'avance

Offline

#8 2020-01-07 11:38:44

renzo
Member
Registered: 2008-10-16
Posts: 43

Re: Problème après upgrade 9.4.4

j'ai stopé Apache et Mysql et relancé le setup Glpi


Toujours bloqué au niveau de :  Error is Table './glpi/#sql2-33e0-28' already exists

***

Upgrade
Database connection successful

Database version seems correct (10.1.41) - Perfect!Database version seems correct (10.1.41) - Perfect!
Update to 9.3.1

Task completed. (1 second)
Update to 9.3.2

Task completed. (1 second)
Update to 9.4.0

Task completed. (17 seconds)
Update to 9.4.1

Task completed. (19 seconds)
Update to 9.4.2

Task completed. (19 seconds)
Update to 9.4.3

Task completed. (20 seconds)
Update to 9.4.5

Change of the database layout - glpi_dropdowntranslations (33 seconds)
9.4.5 multiple alter in glpi_dropdowntranslations - Error during the database query: ALTER TABLE `glpi_dropdowntranslations` CHANGE `language` `language` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL - Error is Table './glpi/#sql2-33e0-28' already exists

****
Avez vous une idée

Offline

#9 2020-01-07 12:37:58

renzo
Member
Registered: 2008-10-16
Posts: 43

Re: Problème après upgrade 9.4.4

un peu plus d'information:

lorsque je veux ajouter un suivi voici ce qui se passe :

*********

ajax/timeline.php:118                              ITILFollowup->showForm()
  {"user":"105@optimus","mem_usage":"0.000\", 1.80Mio)"}
[2020-01-07 11:34:21] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in /var/www/glpi/inc/toolbox.class.php line 658
  *** PHP Notice(8): Undefined index: status
  Backtrace :
  inc/ticket.class.php:6807
  inc/itilfollowup.class.php:884                     Ticket::getSplittedSubmitButtonHtml()
  inc/itilfollowup.class.php:815                     ITILFollowup->showFormButtons()
  ajax/timeline.php:118                              ITILFollowup->showForm()
  {"user":"105@optimus","mem_usage":"0.000\", 1.80Mio)"}
[2020-01-07 11:34:49] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in /var/www/glpi/inc/toolbox.class.php line 658
  *** PHP Notice(8): Undefined index: items_id
  Backtrace :
  inc/itilfollowup.class.php:884
  inc/itilfollowup.class.php:815                     ITILFollowup->showFormButtons()
  ajax/timeline.php:118                              ITILFollowup->showForm()
  {"user":"105@optimus"}
[2020-01-07 11:34:49] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in /var/www/glpi/inc/toolbox.class.php line 658
  *** PHP Notice(8): Undefined index: status
  Backtrace :
  inc/ticket.class.php:6798
  inc/itilfollowup.class.php:884                     Ticket::getSplittedSubmitButtonHtml()
  inc/itilfollowup.class.php:815                     ITILFollowup->showFormButtons()
  ajax/timeline.php:118                              ITILFollowup->showForm()
  {"user":"105@optimus","mem_usage":"0.000\", 1.80Mio)"}
[2020-01-07 11:34:49] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in /var/www/glpi/inc/toolbox.class.php line 658
  *** PHP Notice(8): Undefined index: status
  Backtrace :
  inc/ticket.class.php:6807
  inc/itilfollowup.class.php:884                     Ticket::getSplittedSubmitButtonHtml()
  inc/itilfollowup.class.php:815                     ITILFollowup->showFormButtons()
  ajax/timeline.php:118                              ITILFollowup->showForm()
  {"user":"105@optimus","mem_usage":"0.022\", 1.80Mio)"}
[2020-01-07 11:34:49] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in /var/www/glpi/inc/toolbox.class.php line 658
  *** PHP Notice(8): Undefined index: status
  Backtrace :
  inc/ticket.class.php:6807
  inc/itilfollowup.class.php:884                     Ticket::getSplittedSubmitButtonHtml()
  inc/itilfollowup.class.php:815                     ITILFollowup->showFormButtons()
  ajax/timeline.php:118                              ITILFollowup->showForm()
  {"user":"105@optimus","mem_usage":"0.000\", 1.80Mio)"}
[2020-01-07 11:34:49] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in /var/www/glpi/inc/toolbox.class.php line 658
  *** PHP Notice(8): Undefined index: status
  Backtrace :
  inc/ticket.class.php:6807
  inc/itilfollowup.class.php:884                     Ticket::getSplittedSubmitButtonHtml()
  inc/itilfollowup.class.php:815                     ITILFollowup->showFormButtons()
  ajax/timeline.php:118                              ITILFollowup->showForm()
  {"user":"105@optimus","mem_usage":"0.000\", 1.80Mio)"}
[2020-01-07 11:34:49] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in /var/www/glpi/inc/toolbox.class.php line 658
  *** PHP Notice(8): Undefined index: status
  Backtrace :
  inc/ticket.class.php:6807
  inc/itilfollowup.class.php:884                     Ticket::getSplittedSubmitButtonHtml()
  inc/itilfollowup.class.php:815                     ITILFollowup->showFormButtons()
  ajax/timeline.php:118                              ITILFollowup->showForm()
  {"user":"105@optimus","mem_usage":"0.000\", 1.80Mio)"}
[2020-01-07 11:34:49] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in /var/www/glpi/inc/toolbox.class.php line 658
  *** PHP Notice(8): Undefined index: status
  Backtrace :
  inc/ticket.class.php:6807
  inc/itilfollowup.class.php:884                     Ticket::getSplittedSubmitButtonHtml()
  inc/itilfollowup.class.php:815                     ITILFollowup->showFormButtons()
  ajax/timeline.php:118                              ITILFollowup->showForm()
  {"user":"105@optimus","mem_usage":"0.000\", 1.80Mio)"}
[2020-01-07 11:34:49] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in /var/www/glpi/inc/toolbox.class.php line 658
  *** PHP Notice(8): Undefined index: status
  Backtrace :
  inc/ticket.class.php:6807
  inc/itilfollowup.class.php:884                     Ticket::getSplittedSubmitButtonHtml()
  inc/itilfollowup.class.php:815                     ITILFollowup->showFormButtons()
  ajax/timeline.php:118                              ITILFollowup->showForm()
  {"user":"105@optimus","mem_usage":"0.000\", 1.80Mio)"}

***
en suite il n'y pas de "suivi" enregistré

Merci

Offline

#10 2020-01-07 13:11:51

mab3
Member
Registered: 2014-09-22
Posts: 193

Re: Problème après upgrade 9.4.4

Bonjour,
Dans l'environnement source, n'y aurait-il pas une table qui ne devrait pas y être (résidu d'une précédente migration.... ) ?
Depuis le répertoire par défaut de glpi dans l'environnment cible, que donne :

php bin/console glpi:database:check

Contexte : GLPI 9.4.3/FusionInventory 9.4+1.1 / Agent FI 2.5.1

Offline

#11 2020-01-07 13:27:56

renzo
Member
Registered: 2008-10-16
Posts: 43

Re: Problème après upgrade 9.4.4

Le voici
*******************

Table schema differs for table "glpi_authldaps".
--- Original
+++ New
@@ @@
create table `glpi_authldaps` (
+  `date_creation` datetime default null
@@ @@
   `location_field` varchar(255) default null
-  `responsible_field` varchar(255) default null
   `pagesize` int(11) not null default '0'
   `ldap_maxlimit` int(11) not null default '0'
   `can_support_pagesize` tinyint(1) not null default '0'
   `picture_field` varchar(255) default null
-  `date_creation` datetime default null
   `inventory_domain` varchar(255) default null
   primary key (`id`)

Table schema differs for table "glpi_blacklistedmailcontents".
--- Original
+++ New
@@ @@
create table `glpi_blacklistedmailcontents` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `content` text
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_blacklists".
--- Original
+++ New
@@ @@
create table `glpi_blacklists` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `type` int(11) not null default '0'
   `name` varchar(255) default null
   `value` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_budgets".
--- Original
+++ New
@@ @@
create table `glpi_budgets` (
+  `budgettypes_id` int(11) not null default '0'
+  `locations_id` int(11) not null default '0'
@@ @@
   `date_creation` datetime default null
-  `locations_id` int(11) not null default '0'
-  `budgettypes_id` int(11) not null default '0'
   primary key (`id`)

Table schema differs for table "glpi_calendars".

--- Original
+++ New
@@ @@
create table `glpi_calendars` (
+  `date_creation` datetime default null
@@ @@
   `cache_duration` text
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_cartridgeitems".
--- Original
+++ New
@@ @@
create table `glpi_cartridgeitems` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `alarm_threshold` int(11) not null default '10'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_cartridgeitemtypes".
--- Original
+++ New
@@ @@
create table `glpi_cartridgeitemtypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_cartridges".
--- Original
+++ New
@@ @@
create table `glpi_cartridges` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `pages` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_changes".
--- Original
+++ New
@@ @@
create table `glpi_changes` (
+  `date_creation` datetime default null
@@ @@
   `solve_delay_stat` int(11) not null default '0'
-  `date_creation` datetime default null
   primary key (`id`)
Table schema differs for table "glpi_changetasks".
--- Original
+++ New
@@ @@
create table `glpi_changetasks` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `actiontime` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   `tasktemplates_id` int(11) not null default '0'
   `timeline_position` tinyint(1) not null default '0'
   `is_private` tinyint(1) not null default '0'
   primary key (`id`)

Table schema differs for table "glpi_items_disks".
--- Original
+++ New
@@ @@
create table `glpi_items_disks` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `is_dynamic` tinyint(1) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_computermodels".
--- Original
+++ New
@@ @@
create table `glpi_computermodels` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `picture_rear` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_computers".
--- Original
+++ New
@@ @@
create table `glpi_computers` (
+  `is_recursive` tinyint(1) not null default '0'
+  `date_creation` datetime default null
@@ @@
   `uuid` varchar(255) default null
-  `date_creation` datetime default null
-  `is_recursive` tinyint(1) not null default '0'
   primary key (`id`)

Table schema differs for table "glpi_computers_softwareversions".
--- Original
+++ New
@@ @@
create table `glpi_computers_softwareversions` (
+  `date_install` date default null
@@ @@
   `is_dynamic` tinyint(1) not null default '0'
-  `date_install` date default null
   primary key (`id`)
   unique key `unicity` (`computers_id`,`softwareversions_id`)

Table schema differs for table "glpi_computertypes".
--- Original
+++ New
@@ @@
create table `glpi_computertypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_computervirtualmachines".
--- Original
+++ New
@@ @@
create table `glpi_computervirtualmachines` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_consumableitems".
--- Original
+++ New
@@ @@
create table `glpi_consumableitems` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `alarm_threshold` int(11) not null default '10'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   `otherserial` varchar(255) default null
   primary key (`id`)

Table schema differs for table "glpi_consumableitemtypes".
--- Original
+++ New
@@ @@
create table `glpi_consumableitemtypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
Table schema differs for table "glpi_consumables".
--- Original
+++ New
@@ @@
create table `glpi_consumables` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `items_id` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_contacts".
--- Original
+++ New
@@ @@
create table `glpi_contacts` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `country` varchar(255) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_contacttypes".
--- Original
+++ New
@@ @@
create table `glpi_contacttypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_contracts".
--- Original
+++ New
@@ @@
create table `glpi_contracts` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `is_template` tinyint(1) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_contracttypes".
--- Original
+++ New
@@ @@
create table `glpi_contracttypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
Table schema differs for table "glpi_crontasks".
--- Original
+++ New
@@ @@
create table `glpi_crontasks` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `unicity` (`itemtype`,`name`)

Table schema differs for table "glpi_devicecases".
--- Original
+++ New
@@ @@
create table `glpi_devicecases` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `devicecasemodels_id` int(11) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_devicecasetypes".
--- Original
+++ New
@@ @@
create table `glpi_devicecasetypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_devicecontrols".
--- Original
+++ New
@@ @@
create table `glpi_devicecontrols` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `devicecontrolmodels_id` int(11) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_devicedrives".
--- Original
+++ New
@@ @@
create table `glpi_devicedrives` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `devicedrivemodels_id` int(11) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_devicegraphiccards".
--- Original
+++ New
@@ @@
create table `glpi_devicegraphiccards` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `chipset` varchar(255) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_deviceharddrives".
--- Original
+++ New
@@ @@
create table `glpi_deviceharddrives` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `deviceharddrivemodels_id` int(11) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_devicememories".
--- Original
+++ New
@@ @@
create table `glpi_devicememories` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `devicememorymodels_id` int(11) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_devicememorytypes".
--- Original
+++ New
@@ @@
create table `glpi_devicememorytypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_devicemotherboards".
--- Original
+++ New
@@ @@
create table `glpi_devicemotherboards` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `devicemotherboardmodels_id` int(11) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_devicenetworkcards".
--- Original
+++ New
@@ @@
create table `glpi_devicenetworkcards` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `devicenetworkcardmodels_id` int(11) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_devicepcis".
--- Original
+++ New
@@ @@
create table `glpi_devicepcis` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `devicepcimodels_id` int(11) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_devicepowersupplies".
--- Original
+++ New
@@ @@
create table `glpi_devicepowersupplies` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `devicepowersupplymodels_id` int(11) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_deviceprocessors".
--- Original
+++ New
@@ @@
create table `glpi_deviceprocessors` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `deviceprocessormodels_id` int(11) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
primary key (`id`)

Table schema differs for table "glpi_devicesoundcards".
--- Original
+++ New
@@ @@
create table `glpi_devicesoundcards` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `devicesoundcardmodels_id` int(11) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_documentcategories".
--- Original
+++ New
@@ @@
create table `glpi_documentcategories` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `sons_cache` longtext
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `unicity` (`documentcategories_id`,`name`)

Table schema differs for table "glpi_documents".
--- Original
+++ New
@@ @@
create table `glpi_documents` (
+  `date_creation` datetime default null
@@ @@
   `tag` varchar(255) default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_documenttypes".
--- Original
+++ New
@@ @@
create table `glpi_documenttypes` (
+  `date_creation` datetime default null
@@ @@
   `comment` text
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `unicity` (`ext`)

Table schema differs for table "glpi_domains".
--- Original
+++ New
@@ @@
create table `glpi_domains` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
`entities_id` int(11) not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_entities".
--- Original
+++ New
@@ @@
create table `glpi_entities` (
+  `autofill_decommission_date` varchar(255) not null default '-2'
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `inquest_duration` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
-  `autofill_decommission_date` varchar(255) not null default '-2'
   primary key (`id`)
   unique key `unicity` (`entities_id`,`name`)

Table schema differs for table "glpi_fieldblacklists".
--- Original
+++ New
@@ @@
create table `glpi_fieldblacklists` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_fieldunicities".
--- Original
+++ New
@@ @@
create table `glpi_fieldunicities` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_filesystems".
--- Original
+++ New
@@ @@
create table `glpi_filesystems` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
primary key (`id`)

Table schema differs for table "glpi_fqdns".
--- Original
+++ New
@@ @@
create table `glpi_fqdns` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_groups".
--- Original
+++ New
@@ @@
create table `glpi_groups` (
+  `date_creation` datetime default null
@@ @@
   `is_manager` tinyint(1) not null default '1'
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_holidays".
--- Original
+++ New
@@ @@
create table `glpi_holidays` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `is_perpetual` tinyint(1) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_infocoms".
--- Original
+++ New
@@ @@
create table `glpi_infocoms` (
+  `decommission_date` datetime default null
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `warranty_date` date default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
-  `decommission_date` datetime default null
   `businesscriticities_id` int(11) not null default '0'
   primary key (`id`)
   unique key `unicity` (`itemtype`,`items_id`)

Table schema differs for table "glpi_interfacetypes".
--- Original
+++ New
@@ @@
create table `glpi_interfacetypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_ipnetworks".
--- Original
+++ New
@@ @@
create table `glpi_ipnetworks` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_itilcategories".
--- Original
+++ New
@@ @@
create table `glpi_itilcategories` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `is_change` tinyint(1) not null default '1'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_knowbaseitemcategories".
--- Original
+++ New
@@ @@
create table `glpi_knowbaseitemcategories` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `ancestors_cache` longtext
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `unicity` (`entities_id`,`knowbaseitemcategories_id`,`name`)

Table schema differs for table "glpi_links".
--- Original
+++ New
@@ @@
create table `glpi_links` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `open_window` tinyint(1) not null default '1'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
Table schema differs for table "glpi_locations".
--- Original
+++ New
@@ @@
create table `glpi_locations` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `altitude` varchar(255) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `unicity` (`entities_id`,`locations_id`,`name`)

Table schema differs for table "glpi_mailcollectors".
--- Original
+++ New
@@ @@
create table `glpi_mailcollectors` (
+  `date_creation` datetime default null
@@ @@
   `use_mail_date` tinyint(1) not null default '0'
-  `date_creation` datetime default null
   `requester_field` int(11) not null default '0'
   primary key (`id`)

Table schema differs for table "glpi_manufacturers".
--- Original
+++ New
@@ @@
create table `glpi_manufacturers` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_monitormodels".
--- Original
+++ New
@@ @@
create table `glpi_monitormodels` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `picture_rear` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_monitors".
--- Original
+++ New
@@ @@
create table `glpi_monitors` (
+  `is_recursive` tinyint(1) not null default '0'
+  `date_creation` datetime default null
@@ @@
`is_dynamic` tinyint(1) not null default '0'
-  `date_creation` datetime default null
-  `is_recursive` tinyint(1) not null default '0'
   primary key (`id`)

Table schema differs for table "glpi_monitortypes".
--- Original
+++ New
@@ @@
create table `glpi_monitortypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_netpoints".
--- Original
+++ New
@@ @@
create table `glpi_netpoints` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `entities_id` int(11) not null default '0'
   `locations_id` int(11) not null default '0'
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_networkequipmentmodels".
--- Original
+++ New
@@ @@
create table `glpi_networkequipmentmodels` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `picture_rear` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_networkequipments".
--- Original
+++ New
@@ @@
create table `glpi_networkequipments` (
+  `date_creation` datetime default null
@@ @@
   `is_dynamic` tinyint(1) not null default '0'
-  `date_creation` datetime default null
   primary key (`id`)
Table schema differs for table "glpi_networkequipmenttypes".
--- Original
+++ New
@@ @@
create table `glpi_networkequipmenttypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_networknames".
--- Original
+++ New
@@ @@
create table `glpi_networknames` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `is_dynamic` tinyint(1) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_networkportaggregates".
--- Original
+++ New
@@ @@
create table `glpi_networkportaggregates` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `networkports_id` int(11) not null default '0'
   `networkports_id_list` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `networkports_id` (`networkports_id`)

Table schema differs for table "glpi_networkportaliases".
--- Original
+++ New
@@ @@
create table `glpi_networkportaliases` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `networkports_id` int(11) not null default '0'
   `networkports_id_alias` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `networkports_id` (`networkports_id`)

Table schema differs for table "glpi_networkportdialups".
--- Original
+++ New
@@ @@
create table `glpi_networkportdialups` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `networkports_id` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `networkports_id` (`networkports_id`)

Table schema differs for table "glpi_networkportethernets".
--- Original
+++ New
@@ @@
create table `glpi_networkportethernets` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `speed` int(11) not null default '10'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `networkports_id` (`networkports_id`)

Table schema differs for table "glpi_networkportfiberchannels".
--- Original
+++ New
@@ @@
create table `glpi_networkportfiberchannels` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `speed` int(11) not null default '10'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `networkports_id` (`networkports_id`)

Table schema differs for table "glpi_networkportlocals".
--- Original
+++ New
@@ @@
create table `glpi_networkportlocals` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `networkports_id` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `networkports_id` (`networkports_id`)

Table schema differs for table "glpi_networkports".
--- Original
+++ New
@@ @@
create table `glpi_networkports` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
`is_dynamic` tinyint(1) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_networkportwifis".
--- Original
+++ New
@@ @@
create table `glpi_networkportwifis` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `mode` varchar(20) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `networkports_id` (`networkports_id`)

Table schema differs for table "glpi_networks".
--- Original
+++ New
@@ @@
create table `glpi_networks` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_notifications".
--- Original
+++ New
@@ @@
create table `glpi_notifications` (
+  `date_creation` datetime default null
@@ @@
   `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_notificationtemplates".
--- Original
+++ New
@@ @@
create table `glpi_notificationtemplates` (
+  `date_creation` datetime default null
@@ @@
   `css` text
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_operatingsystems".
--- Original
+++ New
@@ @@
create table `glpi_operatingsystems` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_operatingsystemservicepacks".
--- Original
+++ New
@@ @@
create table `glpi_operatingsystemservicepacks` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_operatingsystemversions".
--- Original
+++ New
@@ @@
create table `glpi_operatingsystemversions` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_peripheralmodels".
--- Original
+++ New
@@ @@
create table `glpi_peripheralmodels` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `picture_rear` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_peripherals".
--- Original
+++ New
@@ @@
create table `glpi_peripherals` (
+  `is_recursive` tinyint(1) not null default '0'
+  `date_creation` datetime default null
@@ @@
   `is_dynamic` tinyint(1) not null default '0'
-  `date_creation` datetime default null
-  `is_recursive` tinyint(1) not null default '0'
   primary key (`id`)
Table schema differs for table "glpi_peripheraltypes".
--- Original
+++ New
@@ @@
create table `glpi_peripheraltypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_phonemodels".
--- Original
+++ New
@@ @@
create table `glpi_phonemodels` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
   `product_number` varchar(255) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_phonepowersupplies".
--- Original
+++ New
@@ @@
create table `glpi_phonepowersupplies` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_phones".
--- Original
+++ New
@@ @@
create table `glpi_phones` (
+  `is_recursive` tinyint(1) not null default '0'
+  `date_creation` datetime default null
@@ @@
   `is_dynamic` tinyint(1) not null default '0'
-  `date_creation` datetime default null
-  `is_recursive` tinyint(1) not null default '0'
   primary key (`id`)

Table schema differs for table "glpi_phonetypes".
--- Original
+++ New
@@ @@
create table `glpi_phonetypes` (

+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_printermodels".
--- Original
+++ New
@@ @@
create table `glpi_printermodels` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
   `product_number` varchar(255) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_printers".
--- Original
+++ New
@@ @@
create table `glpi_printers` (
+  `date_creation` datetime default null
@@ @@
   `is_dynamic` tinyint(1) not null default '0'
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_printertypes".
--- Original
+++ New
@@ @@
create table `glpi_printertypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_problems".
--- Original
+++ New
@@ @@
create table `glpi_problems` (
+  `date_creation` datetime default null
@@ @@
   `solve_delay_stat` int(11) not null default '0'
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_problemtasks".

--- Original
+++ New
@@ @@
create table `glpi_problemtasks` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `state` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   `tasktemplates_id` int(11) not null default '0'
   `timeline_position` tinyint(1) not null default '0'
   `is_private` tinyint(1) not null default '0'
   primary key (`id`)

Table schema differs for table "glpi_profiles".
--- Original
+++ New
@@ @@
create table `glpi_profiles` (
+  `date_creation` datetime default null
@@ @@
   `change_status` text
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_projects".
--- Original
+++ New
@@ @@
create table `glpi_projects` (
+  `date_creation` datetime default null
@@ @@
   `is_deleted` tinyint(1) not null default '0'
-  `date_creation` datetime default null
   `projecttemplates_id` int(11) not null default '0'
   `is_template` tinyint(1) not null default '0'
   `template_name` varchar(255) default null
   primary key (`id`)

Table schema differs for table "glpi_projectstates".
--- Original
+++ New
@@ @@
create table `glpi_projectstates` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
   `color` varchar(255) default null
   `is_finished` tinyint(1) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_projecttasktypes".
--- Original
+++ New
@@ @@
create table `glpi_projecttasktypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_projecttypes".
--- Original
+++ New
@@ @@
create table `glpi_projecttypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_reminders".
--- Original
+++ New
@@ @@
create table `glpi_reminders` (
+  `date_creation` datetime default null
@@ @@
   `end_view_date` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_requesttypes".
--- Original
+++ New
@@ @@
create table `glpi_requesttypes` (
+  `is_itilfollowup` tinyint(1) not null default '1'
+  `comment` text
+  `date_mod` datetime default null
+  `date_creation` datetime default null
+  `is_ticketheader` tinyint(1) not null default '1'
+  `is_active` tinyint(1) not null default '1'
@@ @@
   `is_mailfollowup_default` tinyint(1) not null default '0'
-  `is_active` tinyint(1) not null default '1'
-  `is_ticketheader` tinyint(1) not null default '1'
-  `is_itilfollowup` tinyint(1) not null default '1'
-  `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_rssfeeds".
--- Original
+++ New
@@ @@
create table `glpi_rssfeeds` (
+  `date_creation` datetime default null
@@ @@
   `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_rulecriterias".
--- Original
+++ New
@@ @@
create table `glpi_rulecriterias` (
   `id` int(11) not null auto_increment
   `rules_id` int(11) not null default '0'
   `criteria` varchar(255) default null
   `condition` int(11) not null default '0'
-  `pattern` text default null
+  `pattern` text
   primary key (`id`)

Table schema differs for table "glpi_rulerightparameters".
--- Original
+++ New
@@ @@
create table `glpi_rulerightparameters` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `value` varchar(255) default null
   `comment` text not null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_rules".
--- Original
+++ New
@@ @@
create table `glpi_rules` (
+  `date_creation` datetime default null
@@ @@
   `condition` int(11) not null default '0'
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_slms".
--- Original
+++ New
@@ @@
create table `glpi_slms` (
+  `date_creation` datetime default null
@@ @@
   `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_softwarelicenses".
--- Original
+++ New
@@ @@
create table `glpi_softwarelicenses` (
create table `glpi_softwarelicenses` (
+  `contact_num` varchar(255) default null
+  `contact` varchar(255) default null
+  `manufacturers_id` int(11) not null default '0'
+  `states_id` int(11) not null default '0'
+  `is_helpdesk_visible` tinyint(1) not null default '0'
+  `groups_id` int(11) not null default '0'
+  `groups_id_tech` int(11) not null default '0'
+  `users_id` int(11) not null default '0'
+  `users_id_tech` int(11) not null default '0'
+  `locations_id` int(11) not null default '0'
+  `date_creation` datetime default null
@@ @@
   `is_valid` tinyint(1) not null default '1'
-  `date_creation` datetime default null
-  `is_deleted` tinyint(1) not null default '0'
-  `locations_id` int(11) not null default '0'
-  `users_id_tech` int(11) not null default '0'
-  `users_id` int(11) not null default '0'
-  `groups_id_tech` int(11) not null default '0'
-  `groups_id` int(11) not null default '0'
-  `is_helpdesk_visible` tinyint(1) not null default '0'
   `is_template` tinyint(1) not null default '0'
   `template_name` varchar(255) default null
-  `states_id` int(11) not null default '0'
-  `manufacturers_id` int(11) not null default '0'
-  `contact` varchar(255) default null
-  `contact_num` varchar(255) default null
+  `is_deleted` tinyint(1) not null default '0'
   primary key (`id`)

Table schema differs for table "glpi_softwarelicensetypes".
--- Original
+++ New
@@ @@
create table `glpi_softwarelicensetypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   `softwarelicensetypes_id` int(11) not null default '0'
   `level` int(11) not null default '0'
   `ancestors_cache` longtext
   `sons_cache` longtext
   `entities_id` int(11) not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `completename` text
   primary key (`id`)

Table schema differs for table "glpi_softwares".
--- Original
+++ New
@@ @@
create table `glpi_softwares` (
+  `date_creation` datetime default null
@@ @@
   `is_valid` tinyint(1) not null default '1'
-  `date_creation` datetime default null
   primary key (`id`)
Table schema differs for table "glpi_softwareversions".
--- Original
+++ New
@@ @@
create table `glpi_softwareversions` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `operatingsystems_id` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_solutiontemplates".
--- Original
+++ New
@@ @@
create table `glpi_solutiontemplates` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_solutiontypes".
--- Original
+++ New
@@ @@
create table `glpi_solutiontypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
   `entities_id` int(11) not null default '0'
   `is_recursive` tinyint(1) not null default '1'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_itilsolutions".
--- Original
+++ New
@@ @@
create table `glpi_itilsolutions` (
   `id` int(11) not null auto_increment
   `itemtype` varchar(100) not null
   `items_id` int(11) not null default '0'
   `solutiontypes_id` int(11) not null default '0'
-  `solutiontype_name` varchar(255) null default null
+  `solutiontype_name` varchar(255) default null
   `content` longtext
   `date_creation` datetime default null
   `date_mod` datetime default null
   `date_approval` datetime default null
   `users_id` int(11) not null default '0'
-  `user_name` varchar(255) null default null
+  `user_name` varchar(255) default null
   `users_id_editor` int(11) not null default '0'
`users_id_approval` int(11) not null default '0'
-  `user_name_approval` varchar(255) null default null
+  `user_name_approval` varchar(255) default null
   `status` int(11) not null default '1'
-  `itilfollowups_id` int(11) default null
+  `itilfollowups_id` int(11) default null
   primary key (`id`)

Table schema differs for table "glpi_ssovariables".
--- Original
+++ New
@@ @@
create table `glpi_ssovariables` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text not null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_states".
--- Original
+++ New
@@ @@
create table `glpi_states` (
+  `is_visible_softwarelicense` tinyint(1) not null default '1'
+  `is_visible_line` tinyint(1) not null default '1'
@@ @@
   `is_visible_softwareversion` tinyint(1) not null default '1'
-  `is_visible_softwarelicense` tinyint(1) not null default '1'
-  `is_visible_line` tinyint(1) not null default '1'
   `is_visible_certificate` tinyint(1) not null default '1'
   `is_visible_rack` tinyint(1) not null default '1'
   `is_visible_enclosure` tinyint(1) not null default '1'
   `is_visible_pdu` tinyint(1) not null default '1'
   `date_mod` datetime default null
   `date_creation` datetime default null
   primary key (`id`)
   unique key `unicity` (`states_id`,`name`)

Table schema differs for table "glpi_suppliers".
--- Original
+++ New
@@ @@
create table `glpi_suppliers` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `email` varchar(255) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_suppliertypes".
--- Original
+++ New
@@ @@
create table `glpi_suppliertypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_taskcategories".
--- Original
+++ New
@@ @@
create table `glpi_taskcategories` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `is_helpdeskvisible` tinyint(1) not null default '1'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   `knowbaseitemcategories_id` int(11) not null default '0'
   primary key (`id`)

Table schema differs for table "glpi_tasktemplates".
--- Original
+++ New
@@ @@
create table `glpi_tasktemplates` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   `state` int(11) not null default '0'
   `is_private` tinyint(1) not null default '0'
   `users_id_tech` int(11) not null default '0'
   `groups_id_tech` int(11) not null default '0'
   primary key (`id`)

Table schema differs for table "glpi_tickets".
--- Original
+++ New
@@ @@
create table `glpi_tickets` (
+  `date_creation` datetime default null
@@ @@
   `validation_percent` int(11) not null default '0'
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_tickettasks".
--- Original
+++ New
@@ @@
create table `glpi_tickettasks` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `groups_id_tech` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   `tasktemplates_id` int(11) not null default '0'
   `timeline_position` tinyint(1) not null default '0'
   primary key (`id`)

Table schema differs for table "glpi_usercategories".
--- Original
+++ New
@@ @@
create table `glpi_usercategories` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_users".
--- Original
+++ New
@@ @@
create table `glpi_users` (
+  `highcontrast_css` tinyint(1) default '0'
+  `plannings` text
+  `date_creation` datetime default null
+  `lock_directunlock_notification` tinyint(1) default null
+  `lock_autolock_mode` tinyint(1) default null
@@ @@
   `set_default_requester` tinyint(1) default null
-  `lock_autolock_mode` tinyint(1) default null
-  `lock_directunlock_notification` tinyint(1) default null
-  `date_creation` datetime default null
-  `highcontrast_css` tinyint(1) default '0'
-  `plannings` text
   `sync_field` varchar(255) default null
   `groups_id` int(11) not null default '0'
   `users_id_supervisor` int(11) not null default '0'
   primary key (`id`)
   unique key `unicityloginauth` (`name`,`authtype`,`auths_id`)

Table schema differs for table "glpi_usertitles".
--- Original
+++ New
@@ @@
create table `glpi_usertitles` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_virtualmachinestates".
--- Original
+++ New
@@ @@
create table `glpi_virtualmachinestates` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) not null default ''
   `comment` text not null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_virtualmachinesystems".
--- Original
+++ New
@@ @@
create table `glpi_virtualmachinesystems` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) not null default ''
   `comment` text not null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_virtualmachinetypes".
--- Original
+++ New
@@ @@
create table `glpi_virtualmachinetypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) not null default ''
   `comment` text not null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_vlans".
--- Original
+++ New
@@ @@
create table `glpi_vlans` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `tag` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_wifinetworks".
--- Original
+++ New
@@ @@
create table `glpi_wifinetworks` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
primary key (`id`)

Table schema differs for table "glpi_racks".
--- Original
+++ New
@@ @@
   `room_orientation` int(11) not null default '0'
-  `position` varchar(50)
+  `position` varchar(50) default null
   `bgcolor` varchar(7) default null
   `max_power` int(11) not null default '0'
   `mesured_power` int(11) not null default '0'
   `max_weight` int(11) not null default '0'
   `date_mod` datetime default null
   `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_items_racks".
--- Original
+++ New
@@ @@
   `position` int(11) not null
-  `orientation` tinyint(1)
+  `orientation` tinyint(1) default null
   `bgcolor` varchar(7) default null
   `hpos` tinyint(1) not null default '0'
   `is_reserved` tinyint(1) not null default '0'
   primary key (`id`)
   unique key `item` (`itemtype`,`items_id`,`is_reserved`)

Table schema differs for table "glpi_enclosures".
--- Original
+++ New
@@ @@
   `is_deleted` tinyint(1) not null default '0'
-  `orientation` tinyint(1)
+  `orientation` tinyint(1) default null
   `power_supplies` tinyint(1) not null default '0'
   `states_id` int(11) not null default '0'
   `comment` text
   `manufacturers_id` int(11) not null default '0'
   `date_mod` datetime default null
   `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table "glpi_itilfollowups".
--- Original
+++ New
@@ @@
create table `glpi_itilfollowups` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `itemtype` varchar(100) not null
-  `items_id` int(11) not null default '0'
+  `tickets_id` int(11) not null default '0'
@@ @@
   `requesttypes_id` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
'
   `sourceof_items_id` int(11) not null default '0'
   primary key (`id`)

Offline

#12 2020-01-07 15:06:40

mab3
Member
Registered: 2014-09-22
Posts: 193

Re: Problème après upgrade 9.4.4

Donc la migration n'est pas du tout faite, d'où les plantages cités.
Serait-il possible de faire la même commande dans l'environnement source ?


Contexte : GLPI 9.4.3/FusionInventory 9.4+1.1 / Agent FI 2.5.1

Offline

#13 2020-01-07 15:47:55

renzo
Member
Registered: 2008-10-16
Posts: 43

Re: Problème après upgrade 9.4.4

Bonjour,

vous voulez dire dans la version 9.3.0?
la commande n'existe pas.

ma version est sur php5 et lors de l'upgrade certains modules n'ont plus de support en php5 j'ai donc purge php5 et installé php7.3 avec tous les modules pour pouvoir installer les modules manquant pour l'installation GLPI

j'ai executé donc
" php checkdb.php glpi:database:check "

**********
Table schema differs for table glpi_authldaps
--- Original
+++ New
@@ @@
create table `glpi_authldaps` (
+  `date_creation` datetime default null
@@ @@
   `picture_field` varchar(255) default null
-  `date_creation` datetime default null
   `inventory_domain` varchar(255) default null
   primary key (`id`)

Table schema differs for table glpi_blacklistedmailcontents
--- Original
+++ New
@@ @@
create table `glpi_blacklistedmailcontents` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `content` text
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_blacklists
--- Original
+++ New
@@ @@
create table `glpi_blacklists` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `type` int(11) not null default '0'
   `name` varchar(255) default null
   `value` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_budgets
--- Original
+++ New
@@ @@
create table `glpi_budgets` (
+  `budgettypes_id` int(11) not null default '0'
+  `locations_id` int(11) not null default '0'
@@ @@
   `date_creation` datetime default null
-  `locations_id` int(11) not null default '0'
-  `budgettypes_id` int(11) not null default '0'
   primary key (`id`)

Table schema differs for table glpi_calendars
--- Original
+++ New
@@ @@
create table `glpi_calendars` (
+  `date_creation` datetime default null
@@ @@
   `cache_duration` text
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_cartridgeitems
--- Original
+++ New
@@ @@
create table `glpi_cartridgeitems` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `alarm_threshold` int(11) not null default '10'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_cartridgeitemtypes
--- Original
+++ New
@@ @@
create table `glpi_cartridgeitemtypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_cartridges
--- Original
+++ New
@@ @@
create table `glpi_cartridges` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `pages` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_changes
--- Original
+++ New
@@ @@
create table `glpi_changes` (
+  `date_creation` datetime default null
@@ @@
   `solve_delay_stat` int(11) not null default '0'
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_changetasks
--- Original
+++ New
@@ @@
create table `glpi_changetasks` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `actiontime` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   `tasktemplates_id` int(11) not null default '0'
   primary key (`id`)

Table schema differs for table glpi_items_disks
--- Original
+++ New
@@ @@
create table `glpi_items_disks` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `is_dynamic` tinyint(1) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_computermodels
--- Original
+++ New
@@ @@
create table `glpi_computermodels` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `picture_rear` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_computers
--- Original
+++ New
@@ @@
create table `glpi_computers` (
+  `is_recursive` tinyint(1) not null default '0'
+  `date_creation` datetime default null
@@ @@
   `uuid` varchar(255) default null
-  `date_creation` datetime default null
-  `is_recursive` tinyint(1) not null default '0'
   primary key (`id`)

Table schema differs for table glpi_computers_softwareversions
--- Original
+++ New
@@ @@
create table `glpi_computers_softwareversions` (
+  `date_install` date default null
@@ @@
   `is_dynamic` tinyint(1) not null default '0'
-  `date_install` date default null

primary key (`id`)
   unique key `unicity` (`computers_id`,`softwareversions_id`)

Table schema differs for table glpi_computertypes
--- Original
+++ New
@@ @@
create table `glpi_computertypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_computervirtualmachines
--- Original
+++ New
@@ @@
create table `glpi_computervirtualmachines` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_consumableitems
--- Original
+++ New
@@ @@
create table `glpi_consumableitems` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `alarm_threshold` int(11) not null default '10'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_consumableitemtypes
--- Original
+++ New
@@ @@
create table `glpi_consumableitemtypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_consumables
--- Original
+++ New
@@ @@
create table `glpi_consumables` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `items_id` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_contacts
--- Original
+++ New
@@ @@
create table `glpi_contacts` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `country` varchar(255) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_contacttypes
--- Original
+++ New
@@ @@
create table `glpi_contacttypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_contracts
--- Original
+++ New
@@ @@
create table `glpi_contracts` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `is_template` tinyint(1) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_contracttypes
--- Original
+++ New
@@ @@
create table `glpi_contracttypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
`comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_crontasks
--- Original
+++ New
@@ @@
create table `glpi_crontasks` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `unicity` (`itemtype`,`name`)

Table schema differs for table glpi_devicecases
--- Original
+++ New
@@ @@
create table `glpi_devicecases` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `devicecasemodels_id` int(11) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_devicecasetypes
--- Original
+++ New
@@ @@
create table `glpi_devicecasetypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_devicecontrols
--- Original
+++ New
@@ @@
create table `glpi_devicecontrols` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `devicecontrolmodels_id` int(11) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_devicedrives
--- Original
+++ New
@@ @@
create table `glpi_devicedrives` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `devicedrivemodels_id` int(11) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_devicegraphiccards
--- Original
+++ New
@@ @@
create table `glpi_devicegraphiccards` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `chipset` varchar(255) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_deviceharddrives
--- Original
+++ New
@@ @@
create table `glpi_deviceharddrives` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `deviceharddrivemodels_id` int(11) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_devicememories
--- Original
+++ New
@@ @@
create table `glpi_devicememories` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `devicememorymodels_id` int(11) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_devicememorytypes
--- Original
+++ New
@@ @@
create table `glpi_devicememorytypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
`comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_devicemotherboards
--- Original
+++ New
@@ @@
create table `glpi_devicemotherboards` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `devicemotherboardmodels_id` int(11) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_devicenetworkcards
--- Original
+++ New
@@ @@
create table `glpi_devicenetworkcards` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `devicenetworkcardmodels_id` int(11) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_devicepcis
--- Original
+++ New
@@ @@
create table `glpi_devicepcis` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `devicepcimodels_id` int(11) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_devicepowersupplies
--- Original
+++ New
@@ @@
create table `glpi_devicepowersupplies` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `devicepowersupplymodels_id` int(11) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_deviceprocessors
--- Original
+++ New
@@ @@
create table `glpi_deviceprocessors` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `deviceprocessormodels_id` int(11) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_devicesoundcards
--- Original
+++ New
@@ @@
create table `glpi_devicesoundcards` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `devicesoundcardmodels_id` int(11) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_documentcategories
--- Original
+++ New
@@ @@
create table `glpi_documentcategories` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `sons_cache` longtext
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `unicity` (`documentcategories_id`,`name`)

Table schema differs for table glpi_documents
--- Original
+++ New
@@ @@
create table `glpi_documents` (
+  `date_creation` datetime default null
@@ @@
   `tag` varchar(255) default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_documenttypes
--- Original
+++ New
@@ @@
create table `glpi_documenttypes` (
+  `date_creation` datetime default null
@@ @@
   `comment` text
-  `date_creation` datetime default null
   primary key (`id`)
unique key `unicity` (`ext`)

Table schema differs for table glpi_domains
--- Original
+++ New
@@ @@
create table `glpi_domains` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `entities_id` int(11) not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_entities
--- Original
+++ New
@@ @@
create table `glpi_entities` (
+  `autofill_decommission_date` varchar(255) not null default '-2'
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `inquest_duration` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
-  `autofill_decommission_date` varchar(255) not null default '-2'
   primary key (`id`)
   unique key `unicity` (`entities_id`,`name`)

Table schema differs for table glpi_fieldblacklists
--- Original
+++ New
@@ @@
create table `glpi_fieldblacklists` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_fieldunicities
--- Original
+++ New
@@ @@
create table `glpi_fieldunicities` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_filesystems
--- Original
+++ New
@@ @@
create table `glpi_filesystems` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_fqdns
--- Original
+++ New
@@ @@
create table `glpi_fqdns` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_groups
--- Original
+++ New
@@ @@
create table `glpi_groups` (
+  `date_creation` datetime default null
@@ @@
   `is_manager` tinyint(1) not null default '1'
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_holidays
--- Original
+++ New
@@ @@
create table `glpi_holidays` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `is_perpetual` tinyint(1) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_infocoms
--- Original
+++ New
@@ @@
create table `glpi_infocoms` (
+  `decommission_date` datetime default null
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `warranty_date` date default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
-  `decommission_date` datetime default null
   `businesscriticities_id` int(11) not null default '0'
   primary key (`id`)
   unique key `unicity` (`itemtype`,`items_id`)

Table schema differs for table glpi_interfacetypes
--- Original
+++ New
@@ @@
create table `glpi_interfacetypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_ipnetworks
--- Original
+++ New
@@ @@
create table `glpi_ipnetworks` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_itilcategories
--- Original
+++ New
@@ @@
create table `glpi_itilcategories` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `is_change` tinyint(1) not null default '1'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_knowbaseitemcategories
--- Original
+++ New
@@ @@
create table `glpi_knowbaseitemcategories` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `ancestors_cache` longtext
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `unicity` (`entities_id`,`knowbaseitemcategories_id`,`name`)

Table schema differs for table glpi_links
--- Original
+++ New
@@ @@
create table `glpi_links` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `open_window` tinyint(1) not null default '1'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_locations
--- Original
+++ New
@@ @@
create table `glpi_locations` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `altitude` varchar(255) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `unicity` (`entities_id`,`locations_id`,`name`)

Table schema differs for table glpi_mailcollectors
--- Original
+++ New
@@ @@
create table `glpi_mailcollectors` (
+  `date_creation` datetime default null
@@ @@
   `use_mail_date` tinyint(1) not null default '0'
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_manufacturers
--- Original
+++ New
@@ @@
create table `glpi_manufacturers` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_monitormodels
--- Original
+++ New
@@ @@
create table `glpi_monitormodels` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `picture_rear` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_monitors
--- Original
+++ New
@@ @@
create table `glpi_monitors` (
+  `is_recursive` tinyint(1) not null default '0'
+  `date_creation` datetime default null
@@ @@
   `is_dynamic` tinyint(1) not null default '0'
-  `date_creation` datetime default null
-  `is_recursive` tinyint(1) not null default '0'
   primary key (`id`)

Table schema differs for table glpi_monitortypes
--- Original
+++ New
@@ @@
create table `glpi_monitortypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_netpoints
--- Original
+++ New
@@ @@
create table `glpi_netpoints` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `entities_id` int(11) not null default '0'
   `locations_id` int(11) not null default '0'
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_networkequipmentmodels
--- Original
+++ New
@@ @@
create table `glpi_networkequipmentmodels` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `picture_rear` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_networkequipments
--- Original
+++ New
@@ @@
create table `glpi_networkequipments` (
+  `date_creation` datetime default null
@@ @@
   `is_dynamic` tinyint(1) not null default '0'
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_networkequipmenttypes
--- Original
+++ New
@@ @@
create table `glpi_networkequipmenttypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_networknames
--- Original
+++ New
@@ @@
create table `glpi_networknames` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `is_dynamic` tinyint(1) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_networkportaggregates
--- Original
+++ New
@@ @@
create table `glpi_networkportaggregates` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `networkports_id` int(11) not null default '0'
   `networkports_id_list` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `networkports_id` (`networkports_id`)

Table schema differs for table glpi_networkportaliases
--- Original
+++ New
@@ @@
create table `glpi_networkportaliases` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `networkports_id` int(11) not null default '0'
   `networkports_id_alias` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `networkports_id` (`networkports_id`)

Table schema differs for table glpi_networkportdialups
--- Original
+++ New
@@ @@
create table `glpi_networkportdialups` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `networkports_id` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `networkports_id` (`networkports_id`)

Table schema differs for table glpi_networkportethernets
--- Original
+++ New
@@ @@
create table `glpi_networkportethernets` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `speed` int(11) not null default '10'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `networkports_id` (`networkports_id`)

Table schema differs for table glpi_networkportfiberchannels
--- Original
+++ New
@@ @@
create table `glpi_networkportfiberchannels` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `speed` int(11) not null default '10'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `networkports_id` (`networkports_id`)

Table schema differs for table glpi_networkportlocals
--- Original
+++ New
@@ @@
create table `glpi_networkportlocals` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `networkports_id` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `networkports_id` (`networkports_id`)
Table schema differs for table glpi_networkports
--- Original
+++ New
@@ @@
create table `glpi_networkports` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `is_dynamic` tinyint(1) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_networkportwifis
--- Original
+++ New
@@ @@
create table `glpi_networkportwifis` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `mode` varchar(20) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
   unique key `networkports_id` (`networkports_id`)

Table schema differs for table glpi_networks
--- Original
+++ New
@@ @@
create table `glpi_networks` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_notifications
--- Original
+++ New
@@ @@
create table `glpi_notifications` (
+  `date_creation` datetime default null
@@ @@
   `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_notificationtemplates
--- Original
+++ New
@@ @@
create table `glpi_notificationtemplates` (
+  `date_creation` datetime default null
@@ @@
   `css` text
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_operatingsystems
--- Original
+++ New
@@ @@
create table `glpi_operatingsystems` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_operatingsystemservicepacks
--- Original
+++ New
@@ @@
create table `glpi_operatingsystemservicepacks` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_operatingsystemversions
--- Original
+++ New
@@ @@
create table `glpi_operatingsystemversions` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_peripheralmodels
--- Original
+++ New
@@ @@
create table `glpi_peripheralmodels` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `picture_rear` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_peripherals
--- Original
+++ New
@@ @@
create table `glpi_peripherals` (
+  `is_recursive` tinyint(1) not null default '0'
+  `date_creation` datetime default null
@@ @@
   `is_dynamic` tinyint(1) not null default '0'
-  `date_creation` datetime default null
-  `is_recursive` tinyint(1) not null default '0'
   primary key (`id`)

Table schema differs for table glpi_peripheraltypes
--- Original
+++ New
@@ @@
create table `glpi_peripheraltypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_phonemodels
--- Original
+++ New
@@ @@
create table `glpi_phonemodels` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
   `product_number` varchar(255) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_phonepowersupplies
--- Original
+++ New
@@ @@
create table `glpi_phonepowersupplies` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_phones
--- Original
+++ New
@@ @@
create table `glpi_phones` (
+  `is_recursive` tinyint(1) not null default '0'
+  `date_creation` datetime default null
@@ @@
   `is_dynamic` tinyint(1) not null default '0'
-  `date_creation` datetime default null
-  `is_recursive` tinyint(1) not null default '0'
   primary key (`id`)

Table schema differs for table glpi_phonetypes
--- Original
+++ New
@@ @@
create table `glpi_phonetypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_printermodels
--- Original
+++ New
@@ @@
create table `glpi_printermodels` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
   `product_number` varchar(255) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_printers
--- Original
+++ New
@@ @@
create table `glpi_printers` (
+  `date_creation` datetime default null
@@ @@
   `is_dynamic` tinyint(1) not null default '0'
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_printertypes
--- Original
+++ New
@@ @@
create table `glpi_printertypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)
Table schema differs for table glpi_problems
--- Original
+++ New
@@ @@
create table `glpi_problems` (
+  `date_creation` datetime default null
@@ @@
   `solve_delay_stat` int(11) not null default '0'
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_problemtasks
--- Original
+++ New
@@ @@
create table `glpi_problemtasks` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `state` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   `tasktemplates_id` int(11) not null default '0'
   primary key (`id`)

Table schema differs for table glpi_profiles
--- Original
+++ New
@@ @@
create table `glpi_profiles` (
+  `date_creation` datetime default null
@@ @@
   `change_status` text
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_projects
--- Original
+++ New
@@ @@
create table `glpi_projects` (
+  `date_creation` datetime default null
@@ @@
   `is_deleted` tinyint(1) not null default '0'
-  `date_creation` datetime default null
   `projecttemplates_id` int(11) not null default '0'
   `is_template` tinyint(1) not null default '0'
   `template_name` varchar(255) default null
   primary key (`id`)

Table schema differs for table glpi_projectstates
--- Original
+++ New
@@ @@
create table `glpi_projectstates` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
   `color` varchar(255) default null
`is_finished` tinyint(1) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_projecttasktypes
--- Original
+++ New
@@ @@
create table `glpi_projecttasktypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_projecttypes
--- Original
+++ New
@@ @@
create table `glpi_projecttypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_reminders
--- Original
+++ New
@@ @@
create table `glpi_reminders` (
+  `date_creation` datetime default null
@@ @@
   `end_view_date` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_requesttypes
--- Original
+++ New
@@ @@
create table `glpi_requesttypes` (
+  `is_ticketfollowup` tinyint(1) not null default '1'
+  `comment` text
+  `date_mod` datetime default null
+  `date_creation` datetime default null
+  `is_ticketheader` tinyint(1) not null default '1'
+  `is_active` tinyint(1) not null default '1'
@@ @@
   `is_mailfollowup_default` tinyint(1) not null default '0'
-  `is_active` tinyint(1) not null default '1'
-  `is_ticketheader` tinyint(1) not null default '1'
-  `is_ticketfollowup` tinyint(1) not null default '1'
-  `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_rssfeeds
--- Original
+++ New
@@ @@
create table `glpi_rssfeeds` (
+  `date_creation` datetime default null
@@ @@
   `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_rulerightparameters
--- Original
+++ New
@@ @@
create table `glpi_rulerightparameters` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `value` varchar(255) default null
   `comment` text not null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_rules
--- Original
+++ New
@@ @@
create table `glpi_rules` (
+  `date_creation` datetime default null
@@ @@
   `condition` int(11) not null default '0'
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_slms
--- Original
+++ New
@@ @@
create table `glpi_slms` (
+  `date_creation` datetime default null
@@ @@
   `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_softwarelicenses
--- Original
+++ New
@@ @@
create table `glpi_softwarelicenses` (
+  `contact_num` varchar(255) default null
+  `contact` varchar(255) default null
+  `manufacturers_id` int(11) not null default '0'
+  `states_id` int(11) not null default '0'
+  `is_helpdesk_visible` tinyint(1) not null default '0'
+  `groups_id` int(11) not null default '0'
+  `groups_id_tech` int(11) not null default '0'
+  `users_id` int(11) not null default '0'
+  `users_id_tech` int(11) not null default '0'
+  `locations_id` int(11) not null default '0'
+  `date_creation` datetime default null
@@ @@
   `is_valid` tinyint(1) not null default '1'
-  `date_creation` datetime default null
-  `is_deleted` tinyint(1) not null default '0'
-  `locations_id` int(11) not null default '0'
-  `users_id_tech` int(11) not null default '0'
-  `users_id` int(11) not null default '0'
-  `groups_id_tech` int(11) not null default '0'
-  `groups_id` int(11) not null default '0'
-  `is_helpdesk_visible` tinyint(1) not null default '0'
   `is_template` tinyint(1) not null default '0'
   `template_name` varchar(255) default null
-  `states_id` int(11) not null default '0'
-  `manufacturers_id` int(11) not null default '0'
-  `contact` varchar(255) default null
-  `contact_num` varchar(255) default null
+  `is_deleted` tinyint(1) not null default '0'
   primary key (`id`)

Table schema differs for table glpi_softwarelicensetypes
--- Original
+++ New
@@ @@
create table `glpi_softwarelicensetypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   `softwarelicensetypes_id` int(11) not null default '0'
   `level` int(11) not null default '0'
   `ancestors_cache` longtext
   `sons_cache` longtext
   `entities_id` int(11) not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `completename` text
   primary key (`id`)

Table schema differs for table glpi_softwares
--- Original
+++ New
@@ @@
create table `glpi_softwares` (
+  `date_creation` datetime default null
@@ @@
   `is_valid` tinyint(1) not null default '1'
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_softwareversions
--- Original
+++ New
@@ @@
create table `glpi_softwareversions` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `operatingsystems_id` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_solutiontemplates
--- Original
+++ New
@@ @@
create table `glpi_solutiontemplates` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_solutiontypes
--- Original
+++ New
@@ @@
create table `glpi_solutiontypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
   `entities_id` int(11) not null default '0'
   `is_recursive` tinyint(1) not null default '1'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_itilsolutions
--- Original
+++ New
@@ @@
create table `glpi_itilsolutions` (
   `id` int(11) not null auto_increment
   `itemtype` varchar(100) not null
   `items_id` int(11) not null default '0'
   `solutiontypes_id` int(11) not null default '0'
-  `solutiontype_name` varchar(255) null default null
+  `solutiontype_name` varchar(255) default null
   `content` longtext
   `date_creation` datetime default null
   `date_mod` datetime default null
   `date_approval` datetime default null
   `users_id` int(11) not null default '0'
-  `user_name` varchar(255) null default null
+  `user_name` varchar(255) default null
`users_id_editor` int(11) not null default '0'
   `users_id_approval` int(11) not null default '0'
-  `user_name_approval` varchar(255) null default null
+  `user_name_approval` varchar(255) default null
   `status` int(11) not null default '1'
-  `ticketfollowups_id` int(11) default null
+  `ticketfollowups_id` int(11) default null
   primary key (`id`)

Table schema differs for table glpi_ssovariables
--- Original
+++ New
@@ @@
create table `glpi_ssovariables` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text not null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_states
--- Original
+++ New
@@ @@
create table `glpi_states` (
+  `is_visible_softwarelicense` tinyint(1) not null default '1'
+  `is_visible_line` tinyint(1) not null default '1'
@@ @@
   `is_visible_softwareversion` tinyint(1) not null default '1'
-  `is_visible_softwarelicense` tinyint(1) not null default '1'
-  `is_visible_line` tinyint(1) not null default '1'
   `is_visible_certificate` tinyint(1) not null default '1'
   `is_visible_rack` tinyint(1) not null default '1'
   `date_mod` datetime default null
   `date_creation` datetime default null
   primary key (`id`)
   unique key `unicity` (`states_id`,`name`)

Table schema differs for table glpi_suppliers
--- Original
+++ New
@@ @@
create table `glpi_suppliers` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `email` varchar(255) default null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_suppliertypes
--- Original
+++ New
@@ @@
create table `glpi_suppliertypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
`id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_taskcategories
--- Original
+++ New
@@ @@
create table `glpi_taskcategories` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `is_helpdeskvisible` tinyint(1) not null default '1'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   `knowbaseitemcategories_id` int(11) not null default '0'
   primary key (`id`)

Table schema differs for table glpi_tasktemplates
--- Original
+++ New
@@ @@
create table `glpi_tasktemplates` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   `state` int(11) not null default '0'
   `is_private` tinyint(1) not null default '0'
   `users_id_tech` int(11) not null default '0'
   `groups_id_tech` int(11) not null default '0'
   primary key (`id`)

Table schema differs for table glpi_ticketfollowups
--- Original
+++ New
@@ @@
create table `glpi_ticketfollowups` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `requesttypes_id` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   `timeline_position` tinyint(1) not null default '0'
   primary key (`id`)

Table schema differs for table glpi_tickets
--- Original
+++ New
@@ @@
create table `glpi_tickets` (
+  `date_creation` datetime default null
@@ @@
`validation_percent` int(11) not null default '0'
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_tickettasks
--- Original
+++ New
@@ @@
create table `glpi_tickettasks` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `groups_id_tech` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   `tasktemplates_id` int(11) not null default '0'
   `timeline_position` tinyint(1) not null default '0'
   primary key (`id`)

Table schema differs for table glpi_usercategories
--- Original
+++ New
@@ @@
create table `glpi_usercategories` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_users
--- Original
+++ New
@@ @@
create table `glpi_users` (
+  `highcontrast_css` tinyint(1) default '0'
+  `plannings` text
+  `date_creation` datetime default null
+  `lock_directunlock_notification` tinyint(1) default null
+  `lock_autolock_mode` tinyint(1) default null
@@ @@
   `set_default_requester` tinyint(1) default null
-  `lock_autolock_mode` tinyint(1) default null
-  `lock_directunlock_notification` tinyint(1) default null
-  `date_creation` datetime default null
-  `highcontrast_css` tinyint(1) default '0'
-  `plannings` text
   `sync_field` varchar(255) default null
   primary key (`id`)
   unique key `unicityloginauth` (`name`,`authtype`,`auths_id`)

Table schema differs for table glpi_usertitles
--- Original
+++ New
@@ @@
create table `glpi_usertitles` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
`id` int(11) not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_virtualmachinestates
--- Original
+++ New
@@ @@
create table `glpi_virtualmachinestates` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) not null default ''
   `comment` text not null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_virtualmachinesystems
--- Original
+++ New
@@ @@
create table `glpi_virtualmachinesystems` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) not null default ''
   `comment` text not null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_virtualmachinetypes
--- Original
+++ New
@@ @@
create table `glpi_virtualmachinetypes` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
   `id` int(11) not null auto_increment
   `name` varchar(255) not null default ''
   `comment` text not null
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_vlans
--- Original
+++ New
@@ @@
create table `glpi_vlans` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `tag` int(11) not null default '0'
-  `date_mod` datetime default null
-  `date_creation` datetime default null
primary key (`id`)

Table schema differs for table glpi_wifinetworks
--- Original
+++ New
@@ @@
create table `glpi_wifinetworks` (
+  `date_creation` datetime default null
+  `date_mod` datetime default null
@@ @@
   `comment` text
-  `date_mod` datetime default null
-  `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_racks
--- Original
+++ New
@@ @@
   `room_orientation` int(11) not null default '0'
-  `position` varchar(50)
+  `position` varchar(50) default null
   `bgcolor` varchar(7) default null
   `max_power` int(11) not null default '0'
   `mesured_power` int(11) not null default '0'
   `max_weight` int(11) not null default '0'
   `date_mod` datetime default null
   `date_creation` datetime default null
   primary key (`id`)

Table schema differs for table glpi_items_racks
--- Original
+++ New
@@ @@
   `position` int(11) not null
-  `orientation` tinyint(1)
+  `orientation` tinyint(1) default null
   `bgcolor` varchar(7) default null
   `hpos` tinyint(1) not null default '0'
   `is_reserved` tinyint(1) not null default '0'
   primary key (`id`)
   unique key `item` (`itemtype`,`items_id`,`is_reserved`)

Table schema differs for table glpi_enclosures
--- Original
+++ New
@@ @@
   `is_deleted` tinyint(1) not null default '0'
-  `orientation` tinyint(1)
+  `orientation` tinyint(1) default null
   `power_supplies` tinyint(1) not null default '0'
   `states_id` int(11) not null default '0'
   `comment` text
   `manufacturers_id` int(11) not null default '0'
   `date_mod` datetime default null
   `date_creation` datetime default null
   primary key (`id`)

*****
ceci je l'ai recuperé dans snapshot glpi 9.3.0 ou les follow-ups fonctionne normalment et tout fonctionne.

Cordialement et merci de votre temps

Offline

#14 2020-01-07 16:32:59

renzo
Member
Registered: 2008-10-16
Posts: 43

Re: Problème après upgrade 9.4.4

Re bonjour;

J'ai reussi a installer la version 9.4.5 et les follow-up fonctionnant en faisant

J'ai purge toutes les versions de PHP et resté avec PHP7.3 et tous les modules

En suite dans une console j'ai fait:

************************
php bin/console db:update
+-----------------------+-----------+--------+
|                       | Current   | Target |
+-----------------------+-----------+--------+
| Database host         | localhost |        |
| Database name         | glpi      |        |
| Database user         | root      |        |
| GLPI version          | 9.3.0     | 9.4.5  |
| GLPI database version | 9.3       | 9.4.5  |
+-----------------------+-----------+--------+
Do you want to continue ? [Yes/no]y
========================================= Update to 9.3.1 ==========================================
========================================= Update to 9.3.2 ==========================================
========================================= Update to 9.4.0 ==========================================
========================================= Update to 9.4.1 ==========================================
========================================= Update to 9.4.2 ==========================================
========================================= Update to 9.4.3 ==========================================
========================================= Update to 9.4.5 ==========================================
Migration done.

******

Mais maintenant les plugins ne fonctionnent pas.

Lorsque je veux accéder je ne vois aucun plugin a installer alors que je n'ai quelques un desactivé et activan le debug j'obtiens :

**********
PHP Warning: A non-numeric value encountered in /var/www/glpi/inc/session.class.php at line 967

Fatal error: Uncaught Error: Call to undefined function _e() in /var/www/glpi/plugins/additionalalerts/setup.php:81 Stack trace: #0 /var/www/glpi/inc/plugin.class.php(2053): plugin_additionalalerts_check_prerequisites() #1 /var/www/glpi/inc/search.class.php(6313): Plugin::getSpecificValueToDisplay('id', Array, Array) #2 /var/www/glpi/inc/search.class.php(1441): Search::giveItem('Plugin', 'Plugin_8', Array) #3 /var/www/glpi/inc/search.class.php(98): Search::constructData(Array) #4 /var/www/glpi/inc/search.class.php(80): Search::showList('Plugin', Array) #5 /var/www/glpi/front/plugin.php(52): Search::show('Plugin') #6 {main} thrown in /var/www/glpi/plugins/additionalalerts/setup.php on line 81
---
Merci

Offline

#15 2020-01-07 17:18:21

renzo
Member
Registered: 2008-10-16
Posts: 43

Re: Problème après upgrade 9.4.4

L'erreur des plugins étaient dus aux incompatibilités avec la 9.4.5 je vais attendre la sortie de nouvelles versions

Merci encore de votre temps
Cordialement

Offline

#16 2020-01-09 11:06:14

mab3
Member
Registered: 2014-09-22
Posts: 193

Re: Problème après upgrade 9.4.4

Bonjour,

Merci de ce retour


Contexte : GLPI 9.4.3/FusionInventory 9.4+1.1 / Agent FI 2.5.1

Offline

Board footer

Powered by FluxBB