My-idoit weg nach "one support button to fix them all"
-
Hallo,
nachdem ich den oben erwähnten Button geklickt hab, kommt bei my-idoit nur noch diese Fehlermeldung:
Database error : Query error: 'SELECT isys_workflow__id, isys_workflow__isys_contact__id, isys_workflow__isys_workflow_category__id, isys_workflow__isys_workflow_type__id, isys_workflow__title, isys_workflow__occurrence, isys_workflow__exception, isys_workflow__datetime, isys_workflow__status, isys_workflow_type__id, isys_workflow_type__title, new.isys_workflow_action__id, new.isys_workflow_action__isys_contact__id, isys_workflow_action_type__id , isys_workflow_action_type__title, isys_workflow_action_type__class, isys_workflow_action_type__const, start_date.isys_workflow_action_parameter__id AS start_id, date_format(start_date.isys_workflow_action_parameter__datetime, '%Y-%m-%d') AS startdate, end_date.isys_workflow_action_parameter__id AS end_id, date_format(end_date.isys_workflow_action_parameter__datetime, '%Y-%m-%d') AS enddate, con.isys_contact_2_isys_obj__isys_contact__id AS isys_contact__id, creator.isys_obj__title, creator.isys_obj__id AS isys_workflow__isys_obj__id FROM isys_workflow AS wf INNER JOIN isys_workflow_type ON isys_workflow__isys_workflow_type__id = isys_workflow_type__id INNER JOIN isys_workflow_2_isys_workflow_action w2a_new ON w2a_new.isys_workflow_2_isys_workflow_action__isys_workflow__id = isys_workflow__id INNER JOIN isys_workflow_action new ON w2a_new.isys_workflow_2_isys_workflow_action__isys_workflow_action__id = new.isys_workflow_action__id INNER JOIN isys_workflow_action_type ON isys_workflow_action_type__id = new.isys_workflow_action__isys_workflow_action_type__id LEFT OUTER JOIN isys_workflow_action_parameter start_date ON start_date.isys_workflow_action_parameter__isys_workflow_action__id = new.isys_workflow_action__id AND start_date.isys_workflow_action_parameter__isys_wf_template_parameter__id = (SELECT isys_workflow_template_parameter__id FROM isys_workflow_template_parameter WHERE isys_workflow_template_parameter__key = 'task__start_date') LEFT OUTER JOIN isys_workflow_action_parameter end_date ON end_date.isys_workflow_action_parameter__isys_workflow_action__id = new.isys_workflow_action__id AND end_date.isys_workflow_action_parameter__isys_wf_template_parameter__id = (SELECT isys_workflow_template_parameter__id FROM isys_workflow_template_parameter WHERE isys_workflow_template_parameter__key = 'task__end_date') INNER JOIN isys_workflow_2_isys_workflow_action w2a ON w2a.isys_workflow_2_isys_workflow_action__isys_workflow__id = isys_workflow__id INNER JOIN isys_workflow_action accept ON w2a.isys_workflow_2_isys_workflow_action__isys_workflow_action__id = accept.isys_workflow_action__id LEFT JOIN isys_contact_2_isys_obj AS con ON con.isys_contact_2_isys_obj__isys_contact__id = accept.isys_workflow_action__isys_contact__id LEFT JOIN isys_contact_2_isys_obj AS con_creator ON con_creator.isys_contact_2_isys_obj__isys_contact__id = wf.isys_workflow__isys_contact__id LEFT JOIN isys_obj AS creator ON creator.isys_obj__id = con_creator.isys_contact_2_isys_obj__isys_obj__id WHERE TRUE AND isys_workflow__isys_workflow_type__id = 1 AND (accept.isys_workflow_action__isys_workflow_action_type__id = '3') AND (isys_workflow__status = '8' OR isys_workflow__status = '3') AND con.isys_contact_2_isys_obj__isys_obj__id IN(9,14) AND isys_workflow_action_type__id = 3 GROUP BY isys_workflow__id ORDER BY startdate DESC LIMIT 10': Subquery returns more than 1 row
Leider wurde das zuvor im temp Verzeichnis gespeicherte Datenbankbackup bei diesem Vorgang gelöscht. Kann da jemand bitte weiterhelfen?
-
Hallo Ruth,
dieses Verhalten konnten wir bisher weder lokal noch auf unserer Demo-Installation reproduzieren. Kannst du uns weitere Informationen zukommen lassen?
Viele Grüße
Leo -
Ich habe einfach nur den Button geklickt, danach funktionierte es nicht mehr.
Vielleicht sollte ich dazu sagen das ich vorher einige Parameter in den Workflows ausversehen gelöscht hatte.
Ich hab das Problem nun behoben indem ich einfach eine zweite i-doit Installation gemacht habe und die Workflowtabellen exportiert und in die zerschossene Installation wieder importiert habe.
Danach funktionierte my-idoit wieder wie gewohnt.
