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

    Probleme Lizenzen anzeigen nach update (V0.9.1 2949)

    Scheduled Pinned Locked Moved Betrieb
    3 Posts 2 Posters 1.1k Views
    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.
    • H
      helmi543
      last edited by

      Wenn man von einem Objekt zugeordnete Lizenzen anzeigen will erhalte ich folgenden Fehler:

      isys_exception_database : Query error: 'INSERT INTO tempObjList_cbc77e51de83b37aa4da09e073230dd9 VALUES ('186', '156', '369', NULL, '', NULL, '2', NULL, '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '155', '156', NULL, '156', '156', '155', '156', '1155', NULL, NULL, NULL, '', NULL, NULL, '', NULL, '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, '', '', '', NULL, NULL, NULL, '156', '156', NULL, '1', '156', NULL, 'Eric Zöhner', NULL, '0', '2007-10-22 00:00:00', 'SYSID_1162818659', '2', '0'), ('187', '156', '347', NULL, '', NULL, '2', NULL, '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '155', '156', NULL, '156', '156', '155', '156', '1155', NULL, NULL, NULL, '', NULL, NULL, '', NULL, '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, '', '', '', NULL, NULL, NULL, '156', '156', NULL, '1', '156', NULL, 'Name, NULL, '0', '2007-10-22 00:00:00', 'SYSID_1162818659', '2', '0');': Incorrect datetime value: '' for column 'isys_cats_lic_item__start' at row 1 (Extended Information: array ( 'server' => '5.1.15-beta-community-nt', 'host' => '192.168.0.57 via TCP/IP', 'client' => '4.1.6-gamma', 'proto' => 10, ))

      isys_exception_dao : DAO Exception: Running transaction has been canceled. Could not isys_component_dao::update() : INSERT INTO tempObjList_cbc77e51de83b37aa4da09e073230dd9 VALUES ('186', '156', '369', NULL, '', NULL, '2', NULL, '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '155', '156', NULL, '156', '156', '155', '156', '1155', NULL, NULL, NULL, '', NULL, NULL, '', NULL, '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, '', '', '', NULL, NULL, NULL, '156', '156', NULL, '1', '156', NULL, 'Eric Zöhner', NULL, '0', '2007-10-22 00:00:00', 'SYSID_1162818659', '2', '0'), ('187', '156', '347', NULL, '', NULL, '2', NULL, '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '155', '156', NULL, '156', '156', '155', '156', '1155', NULL, NULL, NULL, '', NULL, NULL, '', NULL, '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, '', '', '', NULL, NULL, NULL, '156', '156', NULL, '1', '156', NULL, 'Eric Zöhner', NULL, '0', '2007-10-22 00:00:00', 'SYSID_1162818659', '2', '0'); (Extended Information: 0)

      VIEW HANDLER (isys_cmdb_view_list_category):
      Backtrace:
      #11 called: isys_component_dao::update() in [/var/www/html/i-doit/src/classes/components/isys_component_dao.class.php:224]
      –
      #10 called: isys_component_dao->update(INSERT INTO tempObjList_cbc77e51de83b37aa4da09e073230dd9 VALUES ('186', '156', '369', NULL, '', NULL, '2', NULL, '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '155', '156', NULL, '156', '156', '155', '156', '1155', NULL, NULL, NULL, '', NULL, NULL, '', NULL, '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, '', '', '', NULL, NULL, NULL, '156', '156', NULL, '1', '156', NULL, 'Eric Zöhner', NULL, '0', '2007-10-22 00:00:00', 'SYSID_1162818659', '2', '0'), ('187', '156', '347', NULL, '', NULL, '2', NULL, '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '156', '155', '156', NULL, '156', '156', '155', '156', '1155', NULL, NULL, NULL, '', NULL, NULL, '', NULL, '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, '', '', '', NULL, NULL, NULL, '156', '156', NULL, '1', '156', NULL, 'Eric Zöhner', NULL, '0', '2007-10-22 00:00:00', 'SYSID_1162818659', '2', '0');) in [/var/www/html/i-doit/src/classes/components/isys_component_list.class.php:528]
      –
      #9 called: isys_component_list->createTempTable() in [/var/www/html/i-doit/src/classes/cmdb/ui/isys_cmdb_ui_category.class.php:360]
      –
      #8 called: isys_cmdb_ui_category_g_assign_lic->list_view(,156,Object) in [/var/www/html/i-doit/src/classes/cmdb/ui/global/isys_cmdb_ui_category_g_assign_lic.class.php:54]
      –
      #7 called: isys_cmdb_ui_category_g_assign_lic->process_list(Object) in [/var/www/html/i-doit/src/classes/cmdb/view/isys_cmdb_view_list_category.class.php:155]
      –
      #6 called: isys_cmdb_view_list_category->list_process() in [/var/www/html/i-doit/src/classes/cmdb/view/isys_cmdb_view_list.class.php:47]
      –
      #5 called: isys_cmdb_view_list_category->process() in [/var/www/html/i-doit/src/classes/modules/isys_module_cmdb.class.php:517]
      –
      #4 called: isys_module_cmdb->start() in [/var/www/html/i-doit/src/classes/modules/isys_module_manager.class.php:270]
      –
      #3 called: isys_module_manager->load(2) in [/var/www/html/i-doit/src/i-doit.inc.php:126]
      –
      #2 called: include_once(/var/www/html/i-doit/src/i-doit.inc.php) in [/var/www/html/i-doit/src/hypergate.inc.php:183]
      –
      #1 called: include_once(/var/www/html/i-doit/src/hypergate.inc.php) in [/var/www/html/i-doit/index.php:304]

      Über Hilfe wäre ich sehr Dankbar   🙂

      1 Reply Last reply Reply Quote 0
      • N
        npotthast
        last edited by

        Gib doch bitte noch einmal an, mit welcher mysql Version du deine Updates ausgeführt hast. Ich habe die Befürchtung, dass eventuell inzwischen die DB nicht mehr die Struktur hat, die sie eigentlich haben müsste, weil du ja doch einige Änderungen manuell gemacht hast.
        Ich beziehe mich jetzt auf alle deine Postings, nicht nur das letzte.

        Deine jetziger mysql Server könnte eventuell auch Ursache des Problems sein. Ich sehe da ein 'beta' im Namen 😉
        Vielleicht macht ein Update ja doch noch einmal Sinn. Ist es denn ein Produktivsystem?

        MfG,
        Niclas Potthast

        1 Reply Last reply Reply Quote 0
        • H
          helmi543
          last edited by

          Hi,
          ich habe heute noch einmal getestet. Das Produktivsystem läuft noch auf der 0.9final 😉
          Ich habe mir Testweise eine aktuelle Xampp umgebung bei mir lokal installiert, Damit ist das Update ohne Probleme verlaufen.
          Dann habe ich das LinuxTestsystem 0.9.1 gegen die Datenbank auf meinem lokalen Rechner laufen lassen und es funktioniert ohne Probleme.
          Bei dem XAMPP ist die MySQL Version 5.0.45 dabei.
          Ich probiere das ganze Update auch nochmal mit der andere MySQL Version und geb Feedback in dem anderen Thread.

          Danke für deine Hilfe

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