Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login

    Problem Update auf V0.9.9-1

    Scheduled Pinned Locked Moved
    Betrieb
    3
    5
    1.8k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • I
      Ingo01
      last edited by

      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

      1 Reply Last reply Reply Quote 0
      • D
        dbluemer
        last edited by

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

        1 Reply Last reply Reply Quote 0
        • I
          Ingo01
          last edited by

          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"...

          1 Reply Last reply Reply Quote 0
          • I
            Ingo01
            last edited by

            …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 🙂

            1 Reply Last reply Reply Quote 0
            • dsD
              ds
              last edited by

              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;

              1 Reply Last reply Reply Quote 0
              • First post
                Last post