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

    0.9.9 Exception bei Task

    Scheduled Pinned Locked Moved
    Entwicklung
    3
    8
    1.6k
    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.
    • T
      twittenhorst
      last edited by

      Hallo,

      beim Editieren eines Tasks kam eine Exception (reproduzierbar, sowohl beim Speichern als auch beim Abbrechen):

      isys_exception_database : Query error: 'INSERT INTO isys_workflow_action_parameter SET isys_workflow_action_parameter__key = 'description',isys_workflow_action_parameter__isys_wf_template_parameter__id = '0', isys_workflow_action_parameter__isys_workflow_action__id = '6', isys_workflow_action_parameter__text = '';': Cannot add or update a child row: a foreign key constraint fails (idoit_data/isys_workflow_action_parameter, CONSTRAINT isys_workflow_action_parameter_ibfk_2 FOREIGN KEY (isys_workflow_action_parameter__isys_wf_template_parameter__id) REFERENCES `isys_)

      Backtrace:
      #0 _get_backtrace() called at [/usr/share/i-doit/src/classes/exceptions/isys_exception.class.php:101]
      #1 isys_exception::get_trace() called at [/usr/share/i-doit/src/classes/exceptions/isys_exception.class.php:32]
      #2 isys_exception->_construct(isys_exception_database : Query error: 'INSERT INTO isys_workflow_action_parameter SET isys_workflow_action_parameter__key = 'description',isys_workflow_action_parameter__isys_wf_template_parameter__id = '0', isys_workflow_action_parameter__isys_workflow_action__id = '6', isys_workflow_action_parameter__text = '';':
      Cannot add or update a child row: a foreign key constraint fails (idoit_data/isys_workflow_action_parameter, CONSTRAINT isys_workflow_action_parameter_ibfk_2 FOREIGN KEY (isys_workflow_action_parameter__isys_wf_template_parameter__id) REFERENCES isys_) , array ( 'server' => '5.0.56-enterprise-gpl-log', 'host' => 'mysql.heise.de via TCP/IP', 'client' => '5.0.51a', 'proto' => 10, ), 0) called at [/usr/share/i-doit/src/classes/exceptions/isys_exception_database.class.php:25] #3 isys_exception_database->__construct(Query error: 'INSERT INTO isys_workflow_action_parameter SET isys_workflow_action_parameter__key = 'description',isys_workflow_action_parameter__isys_wf_template_parameter__id = '0', isys_workflow_action_parameter__isys_workflow_action__id = '6', isys_workflow_action_parameter__text = '';': Cannot add or update a child row: a foreign key constraint fails (idoit_data/isys_workflow_action_parameter, CONSTRAINT isys_workflow_action_parameter_ibfk_2 FOREIGN KEY (isys_workflow_action_parameter__isys_wf_template_parameter__id) REFERENCES isys      ), Array ([server] => 5.0.56-enterprise-gpl-log,[host] => mysql.heise.de via TCP/IP,[client] => 5.0.51a,[proto] => 10)) called at [/usr/share/i-doit/src/classes/components/isys_component_database_mysql.class.php:160]
      #4 isys_component_database_mysql->query(INSERT INTO isys_workflow_action_parameter SET isys_workflow_action_parameter__key = 'description',isys_workflow_action_parameter__isys_wf_template_parameter__id = '0', isys_workflow_action_parameter__isys_workflow_action__id = '6', isys_workflow_action_parameter__text = '';) called at [/usr/share/i-doit/src/classes/components/isys_component_dao.class.php:240]
      #5 isys_component_dao->update(INSERT INTO isys_workflow_action_parameter SET isys_workflow_action_parameter__key = 'description',isys_workflow_action_parameter__isys_wf_template_parameter__id = '0', isys_workflow_action_parameter__isys_workflow_action__id = '6', isys_workflow_action_parameter__text = '';) called at [/usr/share/i-doit/src/classes/workflow/dao/isys_workflow_dao_action.class.php:289]
      #6 isys_workflow_dao_action->add_parameter(6, 3, description, ) called at [/usr/share/i-doit/src/classes/workflow/action/isys_workflow_action_complete.class.php:46]
      #7 isys_workflow_action_complete->save(2, ) called at [/usr/share/i-doit/src/classes/workflow/isys_workflow.class.php:119]
      #8 isys_workflow->save_action(6, 2) called at [/usr/share/i-doit/src/classes/workflow/view/isys_workflow_view_detail_generic.class.php:236]
      #9 isys_workflow_view_detail_generic->process() called at [/usr/share/i-doit/src/classes/modules/isys_module_cmdb.class.php:533]
      #10 isys_module_cmdb->start() called at [/usr/share/i-doit/src/classes/modules/isys_module_manager.class.php:559]
      #11 isys_module_manager->load(2) called at [/usr/share/i-doit/src/i-doit.inc.php:171]
      #12 include_once(/usr/share/i-doit/src/i-doit.inc.php) called at [/usr/share/i-doit/src/hypergate.inc.php:258]
      #13 include_once(/usr/share/i-doit/src/hypergate.inc.php) called at [/usr/share/i-doit/index.php:306]

      mfg
      hh80

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

        Kannst Du mal den Output des folgenden SQL-Statements posten:

        
SHOW CREATE TABLE isys_workflow_action_parameter;
        1 Reply Last reply Reply Quote 0
        • T
          twittenhorst
          last edited by

          mysql> SHOW CREATE TABLE isys_workflow_action_parameter;
          +–------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
          | Table                          | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
          +--------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
          | isys_workflow_action_parameter | CREATE TABLE isys_workflow_action_parameter (
            isys_workflow_action_parameter__id int(10) unsigned NOT NULL auto_increment,
            isys_workflow_action_parameter__isys_workflow_action__id int(10) default NULL,
            isys_workflow_action_parameter__isys_wf_template_parameter__id int(10) unsigned default NULL,
            isys_workflow_action_parameter__key varchar(255) collate utf8_unicode_ci default NULL,
            isys_workflow_action_parameter__int int(10) unsigned default NULL,
            isys_workflow_action_parameter__string varchar(255) collate utf8_unicode_ci default NULL,
            isys_workflow_action_parameter__text text collate utf8_unicode_ci,
            isys_workflow_action_parameter__datetime datetime default NULL,
            PRIMARY KEY  (isys_workflow_action_parameter__id),
            KEY isys_workflow_action_parameter__isys_workflow_action__id (isys_workflow_action_parameter__isys_workflow_action__id),
            KEY isys_workflow_action_parameter__isys_wf_template_parameter__id (isys_workflow_action_parameter__isys_wf_template_parameter__id),
            CONSTRAINT isys_workflow_action_parameter_ibfk_2 FOREIGN KEY (isys_workflow_action_parameter__isys_wf_template_parameter__id) REFERENCES isys_workflow_template_parameter (isys_workflow_template_parameter__id),
            CONSTRAINT isys_workflow_action_parameter_ibfk_1 FOREIGN KEY (isys_workflow_action_parameter__isys_workflow_action__id) REFERENCES isys_workflow_action (isys_workflow_action__id)
          ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |
          +--------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
          1 row in set (0.01 sec)

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

            Hallo,

            bitte ersetze mal die Datei

            src/classes/workflow/dao/isys_workflow_dao_action.class.php

            mit der beiliegenden.

            isys_workflow_dao_action.class.php

            1 Reply Last reply Reply Quote 0
            • T
              twittenhorst
              last edited by

              Ich kann den Fehler mittlerweile nicht mehr reproduzieren, trat anscheind nur in meiner damaligen Session auf. Mit der neuen Datei tritt er allerdings auch nicht auf. Insofern kann ich nicht sagen, ob der Fehler dadurch behoben wurde. Sorry.

              h80

              1 Reply Last reply Reply Quote 0
              • J
                joed
                last edited by

                ich bekam eben genau den gleichen Fehler ….

                Der Status des Task ist jetzt "Auftrag wurde durchgeführt und ist abgeschlossen.". Der Kommentare wurde
                natürlich nicht in der DB gespeichert. Hier scheint es doch ein generelles Problem zu geben..

                isys_exception_database : Query error: 'INSERT INTO isys_workflow_action_parameter SET isys_workflow_action_parameter__key = 'description',isys_workflow_action_parameter__isys_wf_template_parameter__id = '0', isys_workflow_action_parameter__isys_workflow_action__id = '4', isys_workflow_action_parameter__text = 'Alles erledigt. Keine Probleme.';': Cannot add or update a child row: a foreign key constraint fails (idoit_data/isys_workflow_action_parameter, CONSTRAINT isys_workflow_action_parameter_ibfk_2 FOREIGN KEY (isys_workflow_action_parameter__isys_wf_template_parameter__id) REFERENCES `isys_)

                1 Reply Last reply Reply Quote 0
                • J
                  joed
                  last edited by

                  habe es jetzt 3x nachgestellt und der Fehler tritt immer auf ….

                  Wollte dann die von Dir angebotene PHP-Datei laden.... die Datei hat 451 Zeilen und endet so:
                  /* ---------------------------------------------------------------------------- /
                  /                  *

                  • @desc KILLS ALL ACTIONS, ACTION PARAMETERS AND THE WORKFLOW ITSELF !
                    /
                    /                     ---------------------------------------------------------------------------- */
                    public function kill($p_workflow__id) {
                    $l_id = $p_workflow__id;

                  $l_workflow_data = $this->get_actions($l_id);
                  while ($l_row = $l_workflow_data->get_row()) {
                  $l_action_id = $l_row["isys_workflow_action__id"];

                  $l_sql = "DELETE FROM isys_workflow_2_isys_workflow_action ".
                  "WHERE ".
                  "(isys_workflow_2_isys_workflow_action__isys_workflow_action__id = '".$l_action_id."');";
                  $this->update($l_sql);

                  $l_sql = "DELETE FROM isys_workflow_action_parameter ".
                  "WHERE ".
                  "(isys_workflow_action_parameter__isys_workflow_action__id = '".$l_action_id."');";
                  $this->update($l_sql);

                  $this->unbind($l_id, $l_action_id);

                  $l_sql = "DELETE FROM isys_workflow_action ".
                  "WHERE

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

                    Es gibt wohl bei manchen Leuten Probleme beim Herunterladen von .php Dateien hier.

                    Das neue Release ist ja inzwischen draussen, bitte dieses probieren.

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