Bug #393

SQL-Errors on upgrade 2.1.3 to 2.2.2

Added by Xavier Caillaud over 1 year ago. Updated over 1 year ago.

Status:New Start date:09/28/2010
Priority:Urgent Due date:
Assignee:Benoit Mortier % Done:

0%
Category:-
Target version:2.2.3
For junior contributor:No

Description

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 NOT NULL AUTO_INCREMENT ,
`process_number` VARCHAR COLLATE utf8_unicode_ci DEFAULT NULL,
`on_device` INT NOT NULL DEFAULT \'0\',
`device_type` INT NOT NULL DEFAULT \'0\',
`date` datetime NOT NULL DEFAULT \'0000-00-00 00:00:00\' ,
`agent_type` VARCHAR 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

History

#1
Updated by Benoit Mortier over 1 year ago

  • Assignee set to Benoit Mortier
  • Target version set to 2.2.3

#2
Updated by Benoit Mortier over 1 year ago

to reproduce

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

Also available in: Atom PDF