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 2018-12-21 09:52:53

dongyu.chen
Member
Registered: 2018-12-21
Posts: 1

Error during the database upgrade

Hi,
Sorry for my poor English skills. I tried to update GLPI from 9.1.6 to 9.3.3, everything goes well except MariaDB database upgrade. I got some error message during this upgrade. I post the log below. Is there anyone know what should I do next? I use scripts/cliupdate.php to upgrade.

Database version seems correct (10.3.11) - Perfect!
Current GLPI version         : 9.1.6                                                               
New GLPI version             : 9.3.3                                                               
Current GLPI database version: 9.1.6                                                               
New GLPI database version    : 9.3.2                                                               
Default GLPI Language        : en_GB                                                               

========================================== Update to 9.2 ===========================================
Change of the database layout - glpi_infocoms (0 seconds)                                  Change of the database layout - glpi_softwarelicensetypes (0 seconds)                      Add of - Knowbase item link to tickets to database (0 seconds)                             Add of - Knowbase item revisions to database (0 seconds)                                   Change of the database layout - glpi_knowbaseitemtranslations (0 seconds)                  Add of - Knowbase item comments to database (0 seconds)                                    Change of the database layout - glpi_taskcategories (0 seconds)                            Change of the database layout - glpi_documents_items (0 seconds)                           Change of the database layout - glpi_computermodels (0 seconds)                            Change of the database layout - glpi_printermodels (0 seconds)                             Change of the database layout - glpi_networkequipmentmodels (0 seconds)                    Change of the database layout - glpi_phonemodels (0 seconds)                               Change of the database layout - glpi_peripheralmodels (0 seconds)                          Change of the database layout - glpi_monitormodels (0 seconds)                             Change of the database layout - glpi_items_devicecases (0 seconds)                         Change of the database layout - glpi_items_devicecontrols (0 seconds)                      Change of the database layout - glpi_items_devicedrives (0 seconds)                        Change of the database layout - glpi_items_devicegraphiccards (0 seconds)                  Change of the database layout - glpi_items_deviceharddrives (0 seconds)                    Change of the database layout - glpi_items_devicememories (0 seconds)                      Change of the database layout - glpi_items_devicemotherboards (0 seconds)                  Change of the database layout - glpi_items_devicenetworkcards (0 seconds)                  Change of the database layout - glpi_items_devicepcis (0 seconds)                          Change of the database layout - glpi_items_devicepowersupplies (0 seconds)                 Change of the database layout - glpi_items_deviceprocessors (0 seconds)                    Change of the database layout - glpi_items_devicesoundcards (0 seconds)                    Change of the database layout - glpi_devicecases (0 seconds)                               Change of the database layout - glpi_devicecontrols (0 seconds)                            Change of the database layout - glpi_devicedrives (0 seconds)                              Change of the database layout - glpi_devicegraphiccards (0 seconds)                        Change of the database layout - glpi_deviceharddrives (0 seconds)                          Change of the database layout - glpi_devicememories (0 seconds)                            Change of the database layout - glpi_devicemotherboards (0 seconds)                        Change of the database layout - glpi_devicenetworkcards (0 seconds)                        Change of the database layout - glpi_devicepcis (0 seconds)                                Change of the database layout - glpi_devicepowersupplies (0 seconds)                       Change of the database layout - glpi_deviceprocessors (0 seconds)                          Change of the database layout - glpi_devicesoundcards (0 seconds)                          Change of the database layout - glpi_softwarelicenses (0 seconds)                          Change of the database layout - glpi_tickettasks (0 seconds)                               Change of the database layout - glpi_problemtasks (0 seconds)                              Change of the database layout - glpi_changetasks (0 seconds)                               Change of the database layout - glpi_tasktemplates (0 seconds)                             Change of the database layout - glpi_slalevels (0 seconds)                                 Change of the database layout - glpi_tickets (0 seconds)                                   Change of the database layout - glpi_tickets (0 seconds)                                   Change of the database layout - glpi_tickets (0 seconds)                                   Change of the database layout - glpi_tickets (0 seconds)                                   Change of the database layout - glpi_tickets (0 seconds)                                   Change of the database layout - glpi_tickets (0 seconds)                                   Change of the database layout - glpi_tickets (0 seconds)                                   Change of the database layout - glpi_tickets (0 seconds)                                   Change of the database layout - glpi_tickets (0 seconds)                                   Change of the database layout - glpi_changes (0 seconds)                                   Change of the database layout - glpi_problems (1 second)                                   Change of the database layout - glpi_savedsearches (1 second)                              Change of the database layout - glpi_notifications (1 second)                              Change of the database layout - glpi_queuednotifications (1 second)                        Data migration - glpi_displaypreferences (1 second)                                        ** Api users tokens has been reset, if you use REST/XMLRPC api with personal token for authentication, please reset your user's token.
Change of the database layout - glpi_states (1 second)                                     Change of the database layout - glpi_slalevels_tickets (1 second)                          Change of the database layout - glpi_businesscriticities (1 second)                        Change of the database layout - glpi_documentcategories (1 second)                         Change of the database layout - glpi_olalevels_tickets (1 second)                          Change of the database layout - glpi_states (1 second)                                     Change of the database layout - glpi_tickets_tickets (1 second)                            Change of the database layout - glpi_tickettemplatehiddenfields (1 second)                 Change of the database layout - glpi_tickettemplatemandatoryfields (1 second)              Change of the database layout - glpi_softwarelicenses (1 second)                           Change of the database layout - glpi_infocoms (1 second)                                   Change of the database layout - glpi_monitors (1 second)                                   Change of the database layout - glpi_softwarelicensetypes (1 second)                       Change of the database layout - glpi_knowbaseitemtranslations (1 second)                   Change of the database layout - glpi_taskcategories (1 second)                             Change of the database layout - glpi_documents_items (1 second)                            Change of the database layout - glpi_computermodels (1 second)                             Change of the database layout - glpi_printermodels (1 second)                              Change of the database layout - glpi_networkequipmentmodels (1 second)                     Change of the database layout - glpi_phonemodels (1 second)                                Change of the database layout - glpi_peripheralmodels (1 second)                           Change of the database layout - glpi_monitormodels (1 second)                              Change of the database layout - glpi_items_devicecases (1 second)                          Change of the database layout - glpi_items_devicecontrols (1 second)                       Change of the database layout - glpi_items_devicedrives (1 second)                         Change of the database layout - glpi_items_devicegraphiccards (1 second)                   Change of the database layout - glpi_items_deviceharddrives (1 second)                     Change of the database layout - glpi_items_devicememories (1 second)                       Change of the database layout - glpi_items_devicemotherboards (1 second)                   Change of the database layout - glpi_items_devicenetworkcards (1 second)                   Change of the database layout - glpi_items_devicepcis (1 second)                           Change of the database layout - glpi_items_devicepowersupplies (1 second)                  Change of the database layout - glpi_items_deviceprocessors (1 second)                     Change of the database layout - glpi_items_devicesoundcards (1 second)                     Change of the database layout - glpi_devicecases (1 second)                                Change of the database layout - glpi_devicecontrols (1 second)                             Change of the database layout - glpi_devicedrives (1 second)                               Change of the database layout - glpi_devicegraphiccards (1 second)                         Change of the database layout - glpi_deviceharddrives (1 second)                           Change of the database layout - glpi_devicememories (1 second)                             Change of the database layout - glpi_devicemotherboards (1 second)                         Change of the database layout - glpi_devicenetworkcards (1 second)                         Change of the database layout - glpi_devicepcis (1 second)                                 Change of the database layout - glpi_devicepowersupplies (1 second)                        Change of the database layout - glpi_deviceprocessors (1 second)                           Change of the database layout - glpi_devicesoundcards (1 second)                           Change of the database layout - glpi_tickettasks (1 second)                                Change of the database layout - glpi_problemtasks (1 second)                               Change of the database layout - glpi_changetasks (1 second)                                Change of the database layout - glpi_slas (1 second)                                       Change of the database layout - glpi_slalevels (1 second)                                  Change of the database layout - glpi_tickets (1 second)                                    Change of the database layout - glpi_changes (1 second)                                    Change of the database layout - glpi_problems (1 second)                                   Change of the database layout - glpi_savedsearches (1 second)                              Change of the database layout - glpi_queuednotifications (1 second)                        Change of the database layout - glpi_savedsearches_users (1 second)                        Change of the database layout - glpi_logs (1 second)                                       Change of the database layout - glpi_users (1 second)                                      Change of the database layout - glpi_computers (1 second)                                  Change of the database layout - glpi_items_operatingsystems (1 second)                     Change of the database layout - glpi_entities (1 second)                                   Change of the database layout - glpi_phones (1 second)                                     Change of the database layout - glpi_networkequipments (1 second)                          Change of the database layout - glpi_projects (1 second)                                   Change of the database layout - glpi_projecttasks (1 second)                               Change of the database layout - glpi_ticketfollowups (1 second)                            Change of the database layout - glpi_authldaps (1 second)                                  Change of the database layout - glpi_networkportfiberchannels (1 second)                   Change of the database layout - glpi_slms (1 second)                                       Change of the database layout - glpi_slalevels_tickets (1 second)                          Change of the database layout - glpi_businesscriticities (1 second)                        Change of the database layout - glpi_documentcategories (1 second)                         Change of the database layout - glpi_olalevels_tickets (1 second)                          Change of the database layout - glpi_states (1 second)                                     Change of the database layout - glpi_tickets_tickets (1 second)                            Change of the database layout - glpi_tickettemplatehiddenfields (1 second)                 Change of the database layout - glpi_tickettemplatemandatoryfields (1 second)              Change of the database layout - glpi_tickettemplatepredefinedfields (1 second)             Change of the database layout - glpi_softwarelicenses (1 second)                           Change of the database layout - glpi_tasktemplates (1 second)                              Change of the database layout - glpi_ticketvalidations (1 second)                          Configuration values added for login_remember_time, login_remember_default, use_notifications, notifications_mailing, notifications_ajax, notifications_ajax_check_interval, notifications_ajax_sound, notifications_ajax_icon_url, dbversion, smtp_max_retries, smtp_sender, froTask completed. (1 second)                                                                         
========================================= Update to 9.2.1 ==========================================
Change of the database layout - glpi_certificates (2 seconds)                              Change of the database layout - glpi_items_operatingsystems (2 seconds)                    Change of the database layout - glpi_tickets (2 seconds)                                   Change of the database layout - glpi_items_devicesimcards (2 seconds)                      Task completed. (2 seconds)                                                                         
========================================= Update to 9.2.2 ==========================================
Configuration values added for smtp_retry_time. (2 seconds)                                Task completed. (2 seconds)                                                                         
========================================= Update to 9.2.2 ==========================================
Task completed. (2 seconds)                                                                         
========================================= Update to 9.2.3 ==========================================
Change of the database layout - glpi_devicepcis (2 seconds)                                Task completed. (2 seconds)                                                                         
========================================== Update to 9.3 ===========================================
DBmysql::query() in /var/www/html/glpi/inc/dbmysql.class.php line 177
  *** MySQL query error:
  SQL: CREATE TABLE `glpi_itilsolutions` (
         `id` int(11) NOT NULL AUTO_INCREMENT,
         `itemtype` varchar(100) COLLATE utf8_unicode_ci 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,
         `content` longtext COLLATE utf8_unicode_ci,
         `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,
         `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,
         `status` int(11) NOT NULL DEFAULT '1',
         `ticketfollowups_id` int(11) DEFAULT NULL  COMMENT 'Followup reference on reject or approve a ticket solution',
         PRIMARY KEY (`id`),
         KEY `itemtype` (`itemtype`),
         KEY `item_id` (`items_id`),
         KEY `item` (`itemtype`,`items_id`),
         KEY `solutiontypes_id` (`solutiontypes_id`),
         KEY `users_id` (`users_id`),
         KEY `users_id_editor` (`users_id_editor`),
         KEY `users_id_approval` (`users_id_approval`),
         KEY `status` (`status`),
         KEY `ticketfollowups_id` (`ticketfollowups_id`)
         ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
  Error: Table '`glpi`.`glpi_itilsolutions`' already exists
  Backtrace :
  inc/dbmysql.class.php:206                         
  install/update_92_93.php:80                        DBmysql->queryOrDie()
  inc/update.class.php:424                           update92to93()
  scripts/cliupdate.php:160                          Update->doUpdates()
PHP Fatal error:  Uncaught exception 'RuntimeException' with message '9.3 add table glpi_itilsolutions - Error during the database query: CREATE TABLE `glpi_itilsolutions` (
         `id` int(11) NOT NULL AUTO_INCREMENT,
         `itemtype` varchar(100) COLLATE utf8_unicode_ci 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,
         `content` longtext COLLATE utf8_unicode_ci,
         `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,
         `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,
         `status` int(11) NOT NULL DEFAULT '1',
         `ticketfollowups_id` int(11) DEFAULT NULL  COMMENT 'Fol in /var/www/html/glpi/inc/dbmysql.class.php on line 216

Fatal error: Uncaught exception 'RuntimeException' with message '9.3 add table glpi_itilsolutions - Error during the database query: CREATE TABLE `glpi_itilsolutions` (
         `id` int(11) NOT NULL AUTO_INCREMENT,
         `itemtype` varchar(100) COLLATE utf8_unicode_ci 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,
         `content` longtext COLLATE utf8_unicode_ci,
         `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,
         `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,
         `status` int(11) NOT NULL DEFAULT '1',
         `ticketfollowups_id` int(11) DEFAULT NULL  COMMENT 'Fol in /var/www/html/glpi/inc/dbmysql.class.php on line 216

Offline

#2 2019-01-03 16:50:50

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

Re: Error during the database upgrade

Look at your database if glpi_itilsolutions exists.
If OK try again the migration (you can do ite several time)


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

Board footer

Powered by FluxBB