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?