You are not logged in.
Pages: 1
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
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
Pages: 1