Problem Update auf V0.9.9-1
-
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_listWHERE (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
-
Wurde der Code auf den neuesten Stand gebracht, aber das DB-Update nicht durchgeführt?
-
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"...
-
…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
-
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__idint(10) unsigned NOT NULL,
isys_catg_ip_list_2_isys_catg_port_list__isys_catg_port_list__idint(10) unsigned NOT NULL,
KEYisys_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),
KEYisys_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),
CONSTRAINTisys_catg_ip_list_2_isys_catg_port_list_ibfk_2FOREIGN KEY (isys_catg_ip_list_2_isys_catg_port_list__isys_catg_ip_list__id) REFERENCESisys_catg_ip_list(isys_catg_ip_list__id) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINTisys_catg_ip_list_2_isys_catg_port_list_ibfk_1FOREIGN KEY (isys_catg_ip_list_2_isys_catg_port_list__isys_catg_port_list__id) REFERENCESisys_catg_port_list(isys_catg_port_list__id) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login