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

    [solved] Probleme mit MySQL-DB

    Scheduled Pinned Locked Moved Betrieb
    3 Posts 2 Posters 1.1k Views 1 Watching
    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.
    • C Offline
      christian.lang
      last edited by

      Hi @all,

      ich habe ein Problem mit der MySQL-DB. Die Installation über die Weboberfläche ist ohne Fehler durchgelaufen und ich kann mich auch anmelden.

      Wenn ich jetzt aber ein Objekt erstellen will bekomme ich folgenden Fehler:

      isys_exception_dao > Running transaction has been canceled. Could not isys_component_dao::update() : MySQL-Error: Unknown column 'isys_catg_global_list__isys_contact__id' in 'field list' Query: UPDATE isys_catg_global_list SET isys_catg_global_list__isys_contact__id = NULL, isys_catg_global_list__isys_catg_global_category__id = '1',isys_catg_global_list__isys_purpose__id = NULL ,isys_catg_global_list__isys_guarantee_period_unit__id = NULL ,isys_catg_global_list__title = '23r2r', isys_catg_global_list__order_no = '', isys_catg_global_list__description = '', isys_catg_global_list__acquirementdate = NULL, isys_catg_global_list__guarantee_period = '0', isys_catg_global_list__status = '2' WHERE isys_catg_global_list__id = '9'

      Obwohl es diese Tabellen in meiner Datenbank eigentlich gibt.
      Kann es evtl. an Rechte-Problemen auf der DB liegen? (Dann frage ich mich aber wieso die Installation ohne Problem durchgelaufen ist?)

      Wenn ich in der I-Doit-Oberfläche auf "Abhängigkeiten" klicke bekomme ich folgenden Fehler:

      Message:

      isys_exception_database : Query error: 'SELECT isys_catg_odep_list__id, isys_dependency__id, isys_dependency__isys_obj__id__master, isys_dependency__isys_obj__id__slave, isys_dependency__title, isys_dependency__description, isys_dependency__status, isys_dependency__property, 'LC__MODULE__DEPENDENCY__DEPENDS_ON' dep_direction, master_isys_obj_type.isys_obj_type__title master_obj_type__title, master_isys_obj_type.isys_obj_type__id master_obj_type__id, master_isys_catg_global_list.isys_catg_global_list__title master_obj__title, slave_isys_obj_type.isys_obj_type__title slave_obj_type__title, slave_isys_catg_global_list.isys_catg_global_list__title slave_obj__title, slave_isys_obj_type.isys_obj_type__id slave_obj_type__id FROM isys_catg_odep_list INNER JOIN isys_dependency ON isys_catg_odep_list__isys_dependency__id = isys_dependency__id INNER JOIN isys_obj as master_isys_obj ON isys_dependency__isys_obj__id__master=master_isys_obj.isys_obj__id INNER JOIN isys_obj as slave_isys_obj ON isys_dependency__isys_obj__id__slave=slave_isys_obj.isys_obj__id INNER JOIN isys_obj_type as master_isys_obj_type ON master_isys_obj.isys_obj__isys_obj_type__id=master_isys_obj_type.isys_obj_type__id INNER JOIN isys_obj_type as slave_isys_obj_type ON slave_isys_obj.isys_obj__isys_obj_type__id=slave_isys_obj_type.isys_obj_type__id INNER JOIN isys_catg_distributor as master_isys_catg_distributor ON master_isys_catg_distributor.isys_catg_distributor__isys_obj__id=master_isys_obj.isys_obj__id INNER JOIN isys_catg_distributor as slave_isys_catg_distributor ON slave_isys_catg_distributor.isys_catg_distributor__isys_obj__id=slave_isys_obj.isys_obj__id INNER JOIN isys_catg_global as master_isys_catg_global ON master_isys_catg_distributor.isys_catg_distributor__isys_catg_global__id=master_isys_catg_global.isys_catg_global__id INNER JOIN isys_catg_global as slave_isys_catg_global ON slave_isys_catg_distributor.isys_catg_distributor__isys_catg_global__id=slave_isys_catg_global.isys_catg_global__id INNER JOIN isys_catg_global_list as master_isys_catg_global_list ON master_isys_catg_global_list.isys_catg_global_list__isys_catg_global__id=master_isys_catg_global.isys_catg_global__id INNER JOIN isys_catg_global_list as slave_isys_catg_global_list ON slave_isys_catg_global_list.isys_catg_global_list__isys_catg_global__id=slave_isys_catg_global.isys_catg_global__id WHERE 1 GROUP BY isys_dependency__id ORDER BY isys_dependency__datetime DESC ;':
      Unknown column 'isys_dependency__datetime' in 'order clause' (Extended Information: array (
      'server' => '5.0.26',
      'host' => 'Localhost via UNIX socket',
      'client' => '5.0.26',
      'proto' => 10,
      ))

      Schonmal Danke im Voraus für die Hilfe!

      Gruß,
      Christian

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

        Führe mal ein Update innerhalb von i-doit auf die neueste Version durch. Die Version heisst zur Zeit i-doit v0.9.3-rX (latest inofficial).

        1 Reply Last reply Reply Quote 0
        • C Offline
          christian.lang
          last edited by

          Nach dem Update funktionierts!

          Danke für die Hilfe!

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