FI [0.84+3.3] [GLPI 0.84.7] Upgrade stuck

[zmylna]

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?

[ddurieux]

Wait a little

[zmylna]

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

[ddurieux]

See if you have errors in glpi/files/_log/sql-errors.log

[zmylna]

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

[ddurieux]

Can you paste here the structure of the table glpi_plugin_fusinvdeploy_files

Code:

SHOW CREATE TABLE glpi_plugin_fusinvdeploy_files;

[zmylna]

+--------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 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 |
+--------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

[ddurieux]

Try with this fix: http://forge.fusioninventory.org/project...update.php

[zmylna]

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?

[ddurieux]

not use http://server/glpi/install/update.php, but try to update in glpi menu (Setup > plugins)

[zmylna]

ahh, ok
Problem solved - thank you very much