• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
FI [0.84+3.3] [GLPI 0.84.7] Upgrade stuck
#1
Hi. On one of my servers i stuck on upgrade procedure.
If i click upgrade setup->plugins->fi->Upgrade, upgrade proces stuck on "Change of the database layout - glpi_plugin_fusioninventory_deploygroups_dynamicdatas (8 seconds)"

What can I do in this situation?
#2
Wait a little
Co-leader, official developper
DCS official PARTNER: dcs.glpi@dcsit-group.com
#3
Hi ddurieux
Do you know what is causing the problem?
GLPI forces me to upgrade plugin and disabling it. I can't use fusioninventory now.
Any clue ?
Thank you in advance
#4
See if you have errors in glpi/files/_log/sql-errors.log
Co-leader, official developper
DCS official PARTNER: dcs.glpi@dcsit-group.com
#5
Thanx for your reply. This is error log:
*** MySQL query error:
***
SQL: SELECT files.`id`, files.`name`,
files.`filesize`, files.`mimetype`,
files.`sha512`, files.`shortsha512`,
files.`create_date`,
pkgs.`entities_id`, pkgs.`is_recursive`
FROM glpi_plugin_fusinvdeploy_files as files
LEFT JOIN glpi_plugin_fusioninventory_deployorders as orders
ON orders.`id` = files.`plugin_fusinvdeploy_orders_id`
LEFT JOIN glpi_plugin_fusioninventory_deploypackages as pkgs
ON orders.`plugin_fusioninventory_deploypackages_id` = pkgs.`id`
WHERE
files.`shortsha512` != \"\"
Error: Unknown column 'files.filesize' in 'field list'
Backtrace :
/usr/local/glpi/plugins/fusioninventory/install/update.php :8647 DBmysql->query()
/usr/local/glpi/plugins/fusioninventory/install/update.php :5032 migrateTablesFromFusinvDeploy()
/usr/local/glpi/plugins/fusioninventory/hook.php :825 pluginFusioninventoryUpdate()
/usr/local/glpi/inc/plugin.class.php :615 plugin_fusioninventory_install()
/usr/local/glpi/front/plugin.form.php :45 Plugin->install()
/usr/local/glpi/front/plugin.form.php
#6
Can you paste here the structure of the table glpi_plugin_fusinvdeploy_files

Code:
SHOW CREATE TABLE glpi_plugin_fusinvdeploy_files;
Co-leader, official developper
DCS official PARTNER: dcs.glpi@dcsit-group.com
#7
+--------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+--------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| glpi_plugin_fusinvdeploy_files | CREATE TABLE `glpi_plugin_fusinvdeploy_files` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`entities_id` int(11) NOT NULL DEFAULT '0',
`is_recursive` tinyint(1) NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`version` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`date_mod` datetime DEFAULT NULL,
`filename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`filepath` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`sha1sum` char(40) COLLATE utf8_unicode_ci DEFAULT NULL,
`operatingsystems_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |
+--------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
#8
Try with this fix: http://forge.fusioninventory.org/project...update.php
Co-leader, official developper
DCS official PARTNER: dcs.glpi@dcsit-group.com
#9
Hi ddurieux.
I put update.php to glpi/install folder. After that i logged into glpi and typed in the address bar http://server/glpi/install/update.php. Nothing happens, just blank site.
Upgrade still not working.
Maybe I did something wrong?
#10
not use http://server/glpi/install/update.php, but try to update in glpi menu (Setup > plugins)
Co-leader, official developper
DCS official PARTNER: dcs.glpi@dcsit-group.com
#11
ahh, ok Smile
Problem solved - thank you very much


Forum Jump:


Users browsing this thread: 1 Guest(s)