Problem Update auf V0.9.9-1

Ingo01

Hallo leider habe ich noch ein Problem beim Update auf V0.9.9-1…

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 'mandant.isys_catg_ip_list_2_isys_catg_port_list' doesn't exist

... es felt die Tabelle.

Dies entstand durch MySQL Wirrwar auf V5.1.45 und den Versuch einer Rücksicherung

Wenn ich i-doit starte funktioniert es bis ich einen Punkt aufrufe z.B.: Gebäude Imbiss Fehler (ist auch klar wnn etwas fehlt):

isys_exception_database : Query error: 'SELECT * FROM isys_obj_type INNER JOIN isys_obj_type_2_isysgui_catg_custom ON isys_obj_type_2_isysgui_catg_custom__isys_obj_type__id = isys_obj_type__id INNER JOIN isysgui_catg_custom ON isys_obj_type_2_isysgui_catg_custom__isysgui_catg_custom__id = isysgui_catg_custom__id WHERE TRUE AND isys_obj_type__id = '3'': Table 'mandant.isys_obj_type_2_isysgui_catg_custom' doesn't exist

Backtrace:
#0 _get_backtrace() called at [C:\Programme\Apache\htdocs\I-Doit\src\classes\exceptions\isys_exception.class.php:101]
#1 isys_exception::get_trace() called at [C:\Programme\Apache\htdocs\I-Doit\src\classes\exceptions\isys_exception.class.php:32]
#2 isys_exception->__construct(isys_exception_database : Query error: 'SELECT * FROM isys_obj_type INNER JOIN isys_obj_type_2_isysgui_catg_custom ON isys_obj_type_2_isysgui_catg_custom__isys_obj_type__id = isys_obj_type__id INNER JOIN isysgui_catg_custom ON isys_obj_type_2_isysgui_catg_custom__isysgui_catg_custom__id = isysgui_catg_custom__id WHERE TRUE AND isys_obj_type__id = '3'':
Table 'mandant.isys_obj_type_2_isysgui_catg_custom' doesn't exist
, array (
'server' => '5.1.45-community',
'host' => 'localhost via TCP/IP',
'client' => 'mysqlnd 5.0.7-dev - 091210 - $Revision: 294543 $',
'proto' => 10,
), 0) called at [C:\Programme\Apache\htdocs\I-Doit\src\classes\exceptions\isys_exception_database.class.php:25]
#3 isys_exception_database->__construct(Query error: 'SELECT * FROM isys_obj_type INNER JOIN isys_obj_type_2_isysgui_catg_custom ON isys_obj_type_2_isysgui_catg_custom__isys_obj_type__id = isys_obj_type__id INNER JOIN isysgui_catg_custom ON isys_obj_type_2_isysgui_catg_custom__isysgui_catg_custom__id = isysgui_catg_custom__id WHERE TRUE AND isys_obj_type__id = '3'':
Table 'mandant.isys_obj_type_2_isysgui_catg_custom' doesn't exist, Array ([server] => 5.1.45-community,[host] => localhost via TCP/IP,[client] => mysqlnd 5.0.7-dev - 091210 - $Revision: 294543 $,[proto] => 10)) called at [C:\Programme\Apache\htdocs\I-Doit\src\classes\components\isys_component_database_mysql.class.php:159]
#4 isys_component_database_mysql->query(SELECT * FROM isys_obj_type INNER JOIN isys_obj_type_2_isysgui_catg_custom ON isys_obj_type_2_isysgui_catg_custom__isys_obj_type__id = isys_obj_type__id INNER JOIN isysgui_catg_custom ON isys_obj_type_2_isysgui_catg_custom__isysgui_catg_custom__id = isysgui_catg_custom__id WHERE TRUE AND isys_obj_type__id = '3') called at [C:\Programme\Apache\htdocs\I-Doit\src\classes\components\isys_component_dao.class.php:203]
#5 isys_component_dao->retrieve(SELECT * FROM isys_obj_type INNER JOIN isys_obj_type_2_isysgui_catg_custom ON isys_obj_type_2_isysgui_catg_custom__isys_obj_type__id = isys_obj_type__id INNER JOIN isysgui_catg_custom ON isys_obj_type_2_isysgui_catg_custom__isysgui_catg_custom__id = isysgui_catg_custom__id WHERE TRUE AND isys_obj_type__id = '3') called at [C:\Programme\Apache\htdocs\I-Doit\src\classes\modules\dao\isys_module_dao_custom_fields.class.php:152]
#6 isys_module_dao_custom_fields->get_assignments(, 3) called at [C:\Programme\Apache\htdocs\I-Doit\src\classes\cmdb\view\isys_cmdb_view_tree_object.class.php:297]
#7 isys_cmdb_view_tree_object->tree_build() called at [C:\Programme\Apache\htdocs\I-Doit\src\classes\cmdb\view\isys_cmdb_view_tree.class.php:194]
#8 isys_cmdb_view_tree->process() called at [C:\Programme\Apache\htdocs\I-Doit\src\classes\modules\isys_module_cmdb.class.php:480]
#9 isys_module_cmdb->start() called at [C:\Programme\Apache\htdocs\I-Doit\src\classes\modules\isys_module_manager.class.php:567]
#10 isys_module_manager->load(2) called at [C:\Programme\Apache\htdocs\I-Doit\src\i-doit.inc.php:171]
#11 include_once(C:\Programme\Apache\htdocs\I-Doit\src\i-doit.inc.php) called at [C:\Programme\Apache\htdocs\I-Doit\src\hypergate.inc.php:257]
#12 include_once(C:\Programme\Apache\htdocs\I-Doit\src\hypergate.inc.php) called at [C:\Programme\Apache\htdocs\I-Doit\src\ajax.inc.php:151]
#13 require_once(C:\Programme\Apache\htdocs\I-Doit\src\ajax.inc.php) called at [C:\Programme\Apache\htdocs\I-Doit\index.php:227]

Gruß Ingo

dbluemer

Wurde der Code auf den neuesten Stand gebracht, aber das DB-Update nicht durchgeführt?

Ingo01

Die obige Meldung kommt bei DB Update…

Mir würde die Tabell 'isys_catg_ip_list_2_isys_catg_port_list__isys_catg_ip_list__id' fürs Erste reichen

Zur Zeit bastle ich an einem Clone der VM, aber die Zeit die "drauf geht"...

Ingo01

…Tage später...

1. Ich habe die Kopie der vm hinbekommen
2. Ansatz: Herstellung einer Grundinstallation -> o.k.
Bemerkung Extension: php_pdo_mysql.dll fehlt! Dieser Fehler ist mir bei Updates nie aufgefallen (nur bei einer Neuinstallation!)
3. Versuch, die fehlende Tabelle zu ex- bzw. importieren -> sinnlos
4. Rücksicherung der DB's -erfolgreich!!!
5. Test mit Firefox o.k. -> bei IE8 aktuelle Updates funktioniert das speichern nicht!!!

Optimierung + Test der DB's verlief ohne Fehler

ds

Also die Tabelle isys_catg_ip_list_2_isys_catg_port_list hätte beim Update auf Version 0.9.9 angelegt werden müssen. Hier der Code dafür:

CREATE TABLE isys_catg_ip_list_2_isys_catg_port_list (
isys_catg_ip_list_2_isys_catg_port_list__isys_catg_ip_list__id int(10) unsigned NOT NULL,
isys_catg_ip_list_2_isys_catg_port_list__isys_catg_port_list__id int(10) unsigned NOT NULL,
KEY 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),
KEY isys_catg_ip_list_2_isys_catg_port_list__isys_catg_port_list__id (isys_catg_ip_list_2_isys_catg_port_list__isys_catg_port_list__id),
CONSTRAINT isys_catg_ip_list_2_isys_catg_port_list_ibfk_2 FOREIGN KEY (isys_catg_ip_list_2_isys_catg_port_list__isys_catg_ip_list__id) REFERENCES isys_catg_ip_list (isys_catg_ip_list__id) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT isys_catg_ip_list_2_isys_catg_port_list_ibfk_1 FOREIGN KEY (isys_catg_ip_list_2_isys_catg_port_list__isys_catg_port_list__id) REFERENCES isys_catg_port_list (isys_catg_port_list__id) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;