0.9.9 Exception bei Task

twittenhorst

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

dbluemer

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


SHOW CREATE TABLE isys_workflow_action_parameter;

twittenhorst

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)

dbluemer

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

twittenhorst

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

joed

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

joed

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

dbluemer

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

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