Versuch A: 0.9.9-1 frisch installiert > Datenimport der 0.9.8-3-Daten ===================================================================== Fehler beim Update: isys_exception_database : Query error: 'SELECT isys_catg_logb_list__isys_obj__id FROM isys_catg_logb_list JOIN isys_logbook ON isys_catg_logb_list__isys_logbook__id = '25997'': Unknown column 'isys_catg_logb_list__isys_obj__id' in 'field list' isys_exception_database : Query error: 'RENAME TABLE `isys_catg_ip_list_2_isys_netp_port` TO `isys_catg_ip_list_2_isys_catg_port_list`': Table 'isys_catg_ip_list_2_isys_catg_port_list' already exists Neuer Updateversuch: isys_exception_database : Query error: 'ALTER TABLE `isys_catg_ip_list_2_isys_netp_port` CHANGE `isys_catg_ip_list_2_isys_netp_port__isys_catg_ip_list__id` `isys_catg_ip_list_2_isys_catg_port_list__isys_catg_ip_list__id` INT( 10 ) UNSIGNED NOT NULL , CHANGE `isys_catg_ip_list_2_isys_netp_port__isys_netp_port__id` `isys_catg_ip_list_2_isys_catg_port_list__isys_catg_port_list__id` INT( 10 ) UNSIGNED NOT NULL': Unknown column 'isys_catg_ip_list_2_isys_netp_port__isys_catg_ip_list__id' in 'isys_catg_ip_list_2_isys_netp_port' >> isys_catg_ip_list_2_isys_netp_port__isys_catg_ip_list__id manuell angelegt Neuer Updateversuch: >> isys_catg_ip_list_2_isys_netp_port__isys_netp_port__id manuell angelegt Neuer Updateversuch: isys_exception_database : Query error: 'ALTER TABLE `isys_catg_ip_list_2_isys_netp_port` CHANGE `isys_catg_ip_list_2_isys_netp_port__isys_catg_ip_list__id` `isys_catg_ip_list_2_isys_catg_port_list__isys_catg_ip_list__id` INT( 10 ) UNSIGNED NOT NULL , CHANGE `isys_catg_ip_list_2_isys_netp_port__isys_netp_port__id` `isys_catg_ip_list_2_isys_catg_port_list__isys_catg_port_list__id` INT( 10 ) UNSIGNED NOT NULL': Duplicate column name 'isys_catg_ip_list_2_isys_catg_port_list__isys_catg_ip_list__id' >> isys_catg_ip_list_2_isys_catg_port_list__isys_catg_ip_list__id manuell gelöscht >> isys_catg_ip_list_2_isys_catg_port_list__isys_catg_port_list__id manuell gelöscht Neuer Updateversuch: isys_exception_database : Query error: 'RENAME TABLE `isys_catg_ip_list_2_isys_netp_port` TO `isys_catg_ip_list_2_isys_catg_port_list`': Table 'isys_catg_ip_list_2_isys_catg_port_list' already exists Beim Laden der Hauptseite: isys_exception_database : Query error: 'SELECT isys_catg_logb_list__isys_obj__id FROM isys_catg_logb_list JOIN isys_logbook ON isys_catg_logb_list__isys_logbook__id = '25997'': Unknown column 'isys_catg_logb_list__isys_obj__id' in 'field list' >> isys_catg_logb_list__isys_obj__id manuell hinzugefügt Reload -> Seite wird angezeigt >> Objekte auswählen: isys_exception_database : Query error: 'SELECT *,t_prim.isys_obj__id AS object_id, t_prim.isys_obj__title AS object_title, t_prim.isys_obj__sysid AS object_sysid, t_prim.isys_obj__created AS created, t_prim.isys_obj__created_by AS created_by, t_prim.isys_obj__updated AS updated, t_prim.isys_obj__updated_by AS updated_by, isys_catg_global_category__title AS object_category, '' AS object_location FROM isys_obj AS t_prim LEFT JOIN isys_catg_global_list ON isys_catg_global_list__isys_obj__id = isys_obj__id LEFT JOIN isys_catg_global_category ON isys_catg_global_list__isys_catg_global_category__id = isys_catg_global_category__id WHERE TRUE AND isys_obj__isys_obj_type__id='10' AND t_prim.isys_obj__status='2'': Unknown column 'isys_catg_global_list__isys_obj__id' in 'on clause' isys_exception_database : Query error: 'SELECT *,t_prim.isys_obj__id AS object_id, t_prim.isys_obj__title AS object_title, t_prim.isys_obj__sysid AS object_sysid, t_prim.isys_obj__created AS created, t_prim.isys_obj__created_by AS created_by, t_prim.isys_obj__updated AS updated, t_prim.isys_obj__updated_by AS updated_by, isys_catg_global_category__title AS object_category, '' AS object_location FROM isys_obj AS t_prim LEFT JOIN isys_catg_global_list ON isys_catg_global_list__isys_obj__id = isys_obj__id LEFT JOIN isys_catg_global_category ON isys_catg_global_list__isys_catg_global_category__id = isys_catg_global_category__id WHERE TRUE AND isys_obj__isys_obj_type__id='3' AND t_prim.isys_obj__status='2'': Unknown column 'isys_catg_global_list__isys_obj__id' in 'on clause' Neuer Updateversuch: isys_exception_database : Query error: 'ALTER TABLE `isys_catg_ip_list_2_isys_netp_port` CHANGE `isys_catg_ip_list_2_isys_netp_port__isys_catg_ip_list__id` `isys_catg_ip_list_2_isys_catg_port_list__isys_catg_ip_list__id` INT( 10 ) UNSIGNED NOT NULL , CHANGE `isys_catg_ip_list_2_isys_netp_port__isys_netp_port__id` `isys_catg_ip_list_2_isys_catg_port_list__isys_catg_port_list__id` INT( 10 ) UNSIGNED NOT NULL': Unknown column 'isys_catg_ip_list_2_isys_netp_port__isys_catg_ip_list__id' in 'isys_catg_ip_list_2_isys_netp_port' Versuch B: 0.9.8-3 Umgebung und schrittweise Update =================================================== > Update auf 0.9.9 < Updateversuch: isys_exception_database : Query error: 'RENAME TABLE `isys_catd_drive_list` TO `isys_catg_drive_list`': Table 'isys_catg_drive_list' already exists Backtrace: #0 _get_backtrace() called at [C:\xampp\htdocs\ABC\idoit_0983\src\classes\exceptions\isys_exception_database.class.php:24] #1 isys_exception_database->__construct(Query error: 'RENAME TABLE `isys_catd_drive_list` TO `isys_catg_drive_list`': Table 'isys_catg_drive_list' already exists, Array ([server] => 5.1.30-community,[host] => localhost via TCP/IP,[client] => 5.1.30,[proto] => 10)) called at [C:\xampp\htdocs\ABC\idoit_0983\src\classes\components\isys_component_database.class.php:182] #2 isys_component_database->query(RENAME TABLE `isys_catd_drive_list` TO `isys_catg_drive_list`) called at [C:\xampp\htdocs\ABC\idoit_0983\src\classes\components\isys_component_dao.class.php:253] #3 isys_component_dao->update(RENAME TABLE `isys_catd_drive_list` TO `isys_catg_drive_list`) called at [C:\xampp\htdocs\ABC\idoit_0983\updates\classes\isys_update.class.php:1003] #4 isys_update->update_database(C:/xampp/htdocs/ABC/idoit_0983/updates/versions/v0.9.9/update_data.xml, isys_component_database Object ([] => idoit0983_data,[] => Resource id #112,[] => isys_component_database_transaction_manager Object ([] => isys_component_database Object ( *RECURSION*,[] => 1),[] => idoit,[] => XXX,[] => localhost,[] => 3306), 1) called at [C:\xampp\htdocs\ABC\idoit_0983\updates\classes\isys_update.class.php:245] #5 isys_update->update(idoit0983_system, Array ([9] => idoit0983_data)) called at [C:\xampp\htdocs\ABC\idoit_0983\updates\update.inc.php:451] #6 include_once(C:\xampp\htdocs\ABC\idoit_0983\updates\update.inc.php) called at [C:\xampp\htdocs\ABC\idoit_0983\index.php:278] (Extended Information: array ( 'server' => '5.1.30-community', 'host' => 'localhost via TCP/IP', 'client' => '5.1.30', 'proto' => 10, )) Beim neuladen der Hauptseite: The version of your i-doit database does not match the version of your program code. Please update your databases to i-doit 0.9.8-3 using the updater or revert/update your i-doit source code to version 0.9.9. >> i-doIT system 0.9.9 >> i-doIT data 0.9.8-3 >> isys_catg_drive_list' manuell gelöscht Neuer Updateversuch: isys_exception_database : Query error: 'RENAME TABLE `isys_catd_sanpool_list` TO `isys_catg_sanpool_list`': Table 'isys_catg_sanpool_list' already exists Backtrace: #0 _get_backtrace() called at [C:\xampp\htdocs\ABC\idoit_0983\src\classes\exceptions\isys_exception_database.class.php:24] #1 isys_exception_database->__construct(Query error: 'RENAME TABLE `isys_catd_sanpool_list` TO `isys_catg_sanpool_list`': Table 'isys_catg_sanpool_list' already exists, Array ([server] => 5.1.30-community,[host] => localhost via TCP/IP,[client] => 5.1.30,[proto] => 10)) called at [C:\xampp\htdocs\ABC\idoit_0983\src\classes\components\isys_component_database.class.php:182] #2 isys_component_database->query(RENAME TABLE `isys_catd_sanpool_list` TO `isys_catg_sanpool_list`) called at [C:\xampp\htdocs\ABC\idoit_0983\src\classes\components\isys_component_dao.class.php:253] #3 isys_component_dao->update(RENAME TABLE `isys_catd_sanpool_list` TO `isys_catg_sanpool_list`) called at [C:\xampp\htdocs\ABC\idoit_0983\updates\classes\isys_update.class.php:1003] #4 isys_update->update_database(C:/xampp/htdocs/ABC/idoit_0983/updates/versions/v0.9.9/update_data.xml, isys_component_database Object ([] => idoit0983_data,[] => Resource id #112,[] => isys_component_database_transaction_manager Object ([] => isys_component_database Object ( *RECURSION*,[] => 1),[] => idoit,[] => XXX,[] => localhost,[] => 3306), 1) called at [C:\xampp\htdocs\ABC\idoit_0983\updates\classes\isys_update.class.php:245] #5 isys_update->update(idoit0983_system, Array ([9] => idoit0983_data)) called at [C:\xampp\htdocs\ABC\idoit_0983\updates\update.inc.php:451] #6 include_once(C:\xampp\htdocs\ABC\idoit_0983\updates\update.inc.php) called at [C:\xampp\htdocs\ABC\idoit_0983\index.php:278] (Extended Information: array ( 'server' => '5.1.30-community', 'host' => 'localhost via TCP/IP', 'client' => '5.1.30', 'proto' => 10, )) >> isys_catg_sanpool_list mnauell gelöscht Neuer Updateversuch: isys_exception_database : Query error: 'RENAME TABLE `isys_catp_ip_list` TO `isys_catg_ip_list`': Table 'isys_catg_ip_list' already exists Backtrace: #0 _get_backtrace() called at [C:\xampp\htdocs\ABC\idoit_0983\src\classes\exceptions\isys_exception_database.class.php:24] #1 isys_exception_database->__construct(Query error: 'RENAME TABLE `isys_catp_ip_list` TO `isys_catg_ip_list`': Table 'isys_catg_ip_list' already exists, Array ([server] => 5.1.30-community,[host] => localhost via TCP/IP,[client] => 5.1.30,[proto] => 10)) called at [C:\xampp\htdocs\ABC\idoit_0983\src\classes\components\isys_component_database.class.php:182] #2 isys_component_database->query(RENAME TABLE `isys_catp_ip_list` TO `isys_catg_ip_list`) called at [C:\xampp\htdocs\ABC\idoit_0983\src\classes\components\isys_component_dao.class.php:253] #3 isys_component_dao->update(RENAME TABLE `isys_catp_ip_list` TO `isys_catg_ip_list`) called at [C:\xampp\htdocs\ABC\idoit_0983\updates\classes\isys_update.class.php:1003] #4 isys_update->update_database(C:/xampp/htdocs/ABC/idoit_0983/updates/versions/v0.9.9/update_data.xml, isys_component_database Object ([] => idoit0983_data,[] => Resource id #112,[] => isys_component_database_transaction_manager Object ([] => isys_component_database Object ( *RECURSION*,[] => 1),[] => idoit,[] => XXX,[] => localhost,[] => 3306), 1) called at [C:\xampp\htdocs\ABC\idoit_0983\updates\classes\isys_update.class.php:245] #5 isys_update->update(idoit0983_system, Array ([9] => idoit0983_data)) called at [C:\xampp\htdocs\ABC\idoit_0983\updates\update.inc.php:451] #6 include_once(C:\xampp\htdocs\ABC\idoit_0983\updates\update.inc.php) called at [C:\xampp\htdocs\ABC\idoit_0983\index.php:278] (Extended Information: array ( 'server' => '5.1.30-community', 'host' => 'localhost via TCP/IP', 'client' => '5.1.30', 'proto' => 10, )) >> isys_catg_ip_list manuell gelöscht Neuer Updateversuch: isys_exception_database : Query error: 'CREATE TABLE `isys_catg_ip_list_2_isys_netp_ifacel` ( `isys_catg_ip_list_2_isys_netp_ifacel__isys_catg_ip_list__id` int(10) unsigned NOT NULL, `isys_catg_ip_list_2_isys_netp_ifacel__isys_netp_ifacel__id` int(10) unsigned NOT NULL, KEY `isys_catg_ip_list_2_isys_netp_ifacel__isys_catg_ip_list__id` (`isys_catg_ip_list_2_isys_netp_ifacel__isys_catg_ip_list__id`), KEY `isys_catg_ip_list_2_isys_netp_ifacel__isys_netp_ifacel__id` (`isys_catg_ip_list_2_isys_netp_ifacel__isys_netp_ifacel__id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1': Table 'isys_catg_ip_list_2_isys_netp_ifacel' already exists Backtrace: #0 _get_backtrace() called at [C:\xampp\htdocs\ABC\idoit_0983\src\classes\exceptions\isys_exception_database.class.php:24] #1 isys_exception_database->__construct(Query error: 'CREATE TABLE `isys_catg_ip_list_2_isys_netp_ifacel` ( `isys_catg_ip_list_2_isys_netp_ifacel__isys_catg_ip_list__id` int(10) unsigned NOT NULL, `isys_catg_ip_list_2_isys_netp_ifacel__isys_netp_ifacel__id` int(10) unsigned NOT NULL, KEY `isys_catg_ip_list_2_isys_netp_ifacel__isys_catg_ip_list__id` (`isys_catg_ip_list_2_isys_netp_ifacel__isys_catg_ip_list__id`), KEY `isys_catg_ip_list_2_isys_netp_ifacel__isys_netp_ifacel__id` (`isys_catg_ip_list_2_isys_netp_ifacel__isys_netp_ifacel__id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1': Table 'isys_catg_ip_list_2_isys_netp_ifacel' already exists, Array ([server] => 5.1.30-community,[host] => localhost via TCP/IP,[client] => 5.1.30,[proto] => 10)) called at [C:\xampp\htdocs\ABC\idoit_0983\src\classes\components\isys_component_database.class.php:182] #2 isys_component_database->query(CREATE TABLE `isys_catg_ip_list_2_isys_netp_ifacel` ( `isys_catg_ip_list_2_isys_netp_ifacel__isys_catg_ip_list__id` int(10) unsigned NOT NULL, `isys_catg_ip_list_2_isys_netp_ifacel__isys_netp_ifacel__id` int(10) unsigned NOT NULL, KEY `isys_catg_ip_list_2_isys_netp_ifacel__isys_catg_ip_list__id` (`isys_catg_ip_list_2_isys_netp_ifacel__isys_catg_ip_list__id`), KEY `isys_catg_ip_list_2_isys_netp_ifacel__isys_netp_ifacel__id` (`isys_catg_ip_list_2_isys_netp_ifacel__isys_netp_ifacel__id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1) called at [C:\xampp\htdocs\ABC\idoit_0983\src\classes\components\isys_component_dao.class.php:253] #3 isys_component_dao->update(CREATE TABLE `isys_catg_ip_list_2_isys_netp_ifacel` ( `isys_catg_ip_list_2_isys_netp_ifacel__isys_catg_ip_list__id` int(10) unsigned NOT NULL, `isys_catg_ip_list_2_isys_netp_ifacel__isys_netp_ifacel__id` int(10) unsigned NOT NULL, KEY `isys_catg_ip_list_2_isys_netp_ifacel__isys_catg_ip_list__id` (`isys_catg_ip_list_2_isys_netp_ifacel__isys_catg_ip_list__id`), KEY `isys_catg_ip_list_2_isys_netp_ifacel__isys_netp_ifacel__id` (`isys_catg_ip_list_2_isys_netp_ifacel__isys_netp_ifacel__id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1) called at [C:\xampp\htdocs\ABC\idoit_0983\updates\classes\isys_update.class.php:1003] #4 isys_update->update_database(C:/xampp/htdocs/ABC/idoit_0983/updates/versions/v0.9.9/update_data.xml, isys_component_database Object ([] => idoit0983_data,[] => Resource id #112,[] => isys_component_database_transaction_manager Object ([] => isys_component_database Object ( *RECURSION*,[] => 1),[] => idoit,[] => XXX,[] => localhost,[] => 3306), 1) called at [C:\xampp\htdocs\ABC\idoit_0983\updates\classes\isys_update.class.php:245] #5 isys_update->update(idoit0983_system, Array ([9] => idoit0983_data)) called at [C:\xampp\htdocs\ABC\idoit_0983\updates\update.inc.php:451] #6 include_once(C:\xampp\htdocs\ABC\idoit_0983\updates\update.inc.php) called at [C:\xampp\htdocs\ABC\idoit_0983\index.php:278] (Extended Information: array ( 'server' => '5.1.30-community', 'host' => 'localhost via TCP/IP', 'client' => '5.1.30', 'proto' => 10, )) >> isys_catg_ip_list_2_isys_netp_ifacel' manuell gelöscht Neuer Updateversuch: isys_exception_database : Query error: 'RENAME TABLE `isys_catd_version_list` TO `isys_catg_version_list`': Table 'isys_catg_version_list' already exists Backtrace: #0 _get_backtrace() called at [C:\xampp\htdocs\ABC\idoit_0983\src\classes\exceptions\isys_exception_database.class.php:24] #1 isys_exception_database->__construct(Query error: 'RENAME TABLE `isys_catd_version_list` TO `isys_catg_version_list`': Table 'isys_catg_version_list' already exists, Array ([server] => 5.1.30-community,[host] => localhost via TCP/IP,[client] => 5.1.30,[proto] => 10)) called at [C:\xampp\htdocs\ABC\idoit_0983\src\classes\components\isys_component_database.class.php:182] #2 isys_component_database->query(RENAME TABLE `isys_catd_version_list` TO `isys_catg_version_list`) called at [C:\xampp\htdocs\ABC\idoit_0983\src\classes\components\isys_component_dao.class.php:253] #3 isys_component_dao->update(RENAME TABLE `isys_catd_version_list` TO `isys_catg_version_list`) called at [C:\xampp\htdocs\ABC\idoit_0983\updates\classes\isys_update.class.php:1003] #4 isys_update->update_database(C:/xampp/htdocs/ABC/idoit_0983/updates/versions/v0.9.9/update_data.xml, isys_component_database Object ([] => idoit0983_data,[] => Resource id #112,[] => isys_component_database_transaction_manager Object ([] => isys_component_database Object ( *RECURSION*,[] => 1),[] => idoit,[] => XXX,[] => localhost,[] => 3306), 1) called at [C:\xampp\htdocs\ABC\idoit_0983\updates\classes\isys_update.class.php:245] #5 isys_update->update(idoit0983_system, Array ([9] => idoit0983_data)) called at [C:\xampp\htdocs\ABC\idoit_0983\updates\update.inc.php:451] #6 include_once(C:\xampp\htdocs\ABC\idoit_0983\updates\update.inc.php) called at [C:\xampp\htdocs\ABC\idoit_0983\index.php:278] (Extended Information: array ( 'server' => '5.1.30-community', 'host' => 'localhost via TCP/IP', 'client' => '5.1.30', 'proto' => 10, )) >> isys_catg_version_list manuell gelöscht Neuer Updateversuch: >> update erfolgreich durchgelaufen!!! DB-Migration (Dauer: 2-3 MinABCn) isys_exception_database : Query error: 'UPDATE isys_cats_lic_group SET isys_cats_lic_group__isys_obj__id = (SELECT isys_cats_lic_list__isys_obj__id FROM isys_cats_lic_list WHERE isys_cats_lic_list__id = isys_cats_lic_group__isys_cats_lic_list__id LIMIT 1);': Column 'isys_cats_lic_group__isys_obj__id' cannot be null >> isys_cats_lic_group__isys_obj__id manuell Null-Werte zulassen Neuer Updateversuch: isys_exception_database : Query error: 'SELECT * FROM isys_cats_group_list INNER JOIN isys_cats_distributor ON isys_cats_group_list__isys_cats_distributor__id = isys_cats_distributor__id': Unknown column 'isys_cats_group_list__isys_cats_distributor__id' in 'on clause' >> isys_cats_group_list__isys_cats_distributor__id manuell angelegt Neuer Updateversuch: isys_exception_database : Query error: 'ALTER TABLE `isys_cats_lic_group` ADD `isys_cats_lic_group__isys_obj__id` INT( 10 ) NOT NULL AFTER `isys_cats_lic_group__isys_contact__id` ,ADD INDEX ( `isys_cats_lic_group__isys_obj__id` );': Duplicate column name 'isys_cats_lic_group__isys_obj__id' >> isys_cats_lic_group__isys_obj__id manuell gelöscht Neuer Updateversuch: isys_exception_database : Query error: 'SELECT * FROM isys_cats_group_list INNER JOIN isys_cats_distributor ON isys_cats_group_list__isys_cats_distributor__id = isys_cats_distributor__id': Unknown column 'isys_cats_group_list__isys_cats_distributor__id' in 'on clause' (gleicher Fehler erneut wie oben) >> Hauptseite laden -> lädt in Version 0.9.9 >> beim dateien verknüpfen isys_exception_database : Query error: 'INSERT INTO isys_connection SET isys_connection__isys_obj__id = '345'': Cannot add or update a child row: a foreign key constraint fails (`idoit0983_data`.`isys_connection`, CONSTRAINT `isys_connection_ibfk_1` FOREIGN KEY (`isys_connection__isys_obj__id`) REFERENCES `isys_obj` (`isys_obj__id`) ON DELETE CASCADE ON UPDATE CASCADE) >> manuell: ALTER TABLE isys_connection drop FOREIGN KEY isys_connection_ibfk_1 >> Dateien hinzufügen klappt >> Abhängigkeiten klappen >> funktioniert soweit alles, obwohl Update nicht korrekt durchgelaufen ist Neuer Updateversuch: DB Migration > isys_exception_database : Query error: 'SELECT * FROM isys_cats_group_list INNER JOIN isys_cats_distributor ON isys_cats_group_list__isys_cats_distributor__id = isys_cats_distributor__id': Unknown column 'isys_cats_group_list__isys_cats_distributor__id' in 'on clause' Update auf 0.9.9-1 Updateversuch: isys_exception_database : Query error: 'ALTER TABLE `isys_catg_ip_list_2_isys_catg_port_list` DROP INDEX `isys_catg_ip_list_2_isys_netp_port__isys_netp_port__id`': Error on rename of '.\idoit0983_data\#sql-ca0_16' to '.\idoit0983_data\isys_catg_ip_list_2_isys_catg_port_list' (errno: 150) Neuer Updateversuch: >> i-doIT system 0.9.9-1 >> i-doIT data 0.9.9 >> Tabelle gelöscht + neu angelegt isys_exception_database : Query error: 'SHOW INDEX FROM `isys_catg_ip_list_2_isys_catg_port_list` WHERE (`Key_name` = 'isys_catg_ip_list_2_isys_catg_port_list__isys_catg_ip_list__id')': Table 'idoit0983_data.isys_catg_ip_list_2_isys_catg_port_list' doesn't exist >> nur System DB geupdated -> Seite geladen >> Dateien anlegen klappt >> Abhängigkeiten klappen >> Update läuft nicht komplett durch >> Daten-DB weiterhin auf Version 0.9.9