0.9.9 Exception bei Task



  • 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, CONSTRAINTisys_workflow_action_parameter_ibfk_2FOREIGN KEY (isys_workflow_action_parameter__isys_wf_template_parameter__id) REFERENCESisys
    ), 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



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

    
    SHOW CREATE TABLE isys_workflow_action_parameter;
    
    


  • 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)



  • 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



  • 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



  • 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_)



  • 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



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

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


Log in to reply
 


Datenschutz / Privacy Policy