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_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



  • 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__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;


Log in to reply
 


Datenschutz / Privacy Policy