search

fusioninventory / fusioninventory-for-glpi

FusionInventory plugin for GLPI
http://www.FusionInventory.org/
GNU Affero General Public License v3.0
361 stars 148 forks source link

SQL-Errors on upgrade 2.1.3 to 2.2.2 #146

Open ddurieux opened 8 years ago

ddurieux commented 8 years ago

Author Name: Xavier Caillaud (@tsmr) Original Redmine Issue: 393, http://forge.fusioninventory.org/issues/393 Original Date: 2010-09-28 Original Assignee: Benoit Mortier

28-09-2010 11:06 *\ MySQL query error :

SQL: DROP TABLE glpi_plugin_tracker_unknown_mac Error: Unknown table 'glpi_plugin_tracker_unknown_mac' Backtrace : /var/www/glpi72/plugins/fusioninventory/inc/plugin_fusioninventory.functions_setup.php:96 DBmysql->query() /var/www/glpi72/plugins/fusioninventory/hook.php:1212 plugin_fusioninventory_update() /var/www/glpi72/inc/plugin.class.php:372 plugin_fusioninventory_install() /var/www/glpi72/front/setup.plugins.php:51 Plugin->install() /var/www/glpi72/front/setup.plugins.php

28-09-2010 11:06 *\ MySQL query error :

SQL:

CREATE TABLE glpi_plugin_fusioninventory_agents_errors ( ID INT( 11 ) NOT NULL AUTO_INCREMENT , process_number VARCHAR( 255 ) COLLATE utf8_unicode_ci DEFAULT NULL, on_device INT( 11 ) NOT NULL DEFAULT \'0\', device_type INT( 11 ) NOT NULL DEFAULT \'0\', date datetime NOT NULL DEFAULT \'0000-00-00 00:00:00\' , agent_type VARCHAR( 255 ) COLLATE utf8_unicode_ci DEFAULT NULL , error_message text collate utf8_unicode_ci, PRIMARY KEY (ID), KEY process_number (process_number,agent_type), KEY date (date) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci Error: Specified key was too long; max key length is 1000 bytes Backtrace : /var/www/glpi72/plugins/fusioninventory/inc/plugin_fusioninventory.functions_setup.php:96 DBmysql->query() /var/www/glpi72/plugins/fusioninventory/hook.php:1212 plugin_fusioninventory_update() /var/www/glpi72/inc/plugin.class.php:372 plugin_fusioninventory_install() /var/www/glpi72/front/setup.plugins.php:51 Plugin->install() /var/www/glpi72/front/setup.plugins.php

28-09-2010 11:06 *\ MySQL query error :

SQL: ALTER TABLE glpi072_temp.glpi_plugin_fusioninventory_snmp_history ADD INDEX Field ( Field , old_value ), ADD INDEX Field_2 ( Field , new_value ), ADD INDEX ( Field ) Error: Table 'glpi072_temp.glpi_plugin_fusioninventory_snmp_history' doesn't exist Backtrace : /var/www/glpi72/plugins/fusioninventory/inc/plugin_fusioninventory.functions_setup.php:96 DBmysql->query() /var/www/glpi72/plugins/fusioninventory/hook.php:1212 plugin_fusioninventory_update() /var/www/glpi72/inc/plugin.class.php:372 plugin_fusioninventory_install() /var/www/glpi72/front/setup.plugins.php:51 Plugin->install() /var/www/glpi72/front/setup.plugins.php

ddurieux commented 8 years ago

Original Redmine Comment Author Name: Benoit Mortier (Benoit Mortier) Original Date: 2011-01-18T23:05:22Z

to reproduce

install tracker suppress tracker directory copy fusioninventory directory looks at the update going bad :)