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

          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
          • First post
            Last post