Details
-
Bug
-
Resolution: Obsolete
-
Medium
-
None
-
4.1.4
-
None
Description
A ezUser who was assigned to a workflow and afterwards being removed is still listed within the workflow. The workflow itself is not editable because of references to the removed ezUser. The workflow itself does not work anymore.
Errormessage:
Some of passed user IDs are not valid, must be IDs of existing users only.
Tested with ezpublish 4.0.0 and 4.1.4. So i assume all 4.x are affected. Perhaps 3.x too, as some other workflow-issues do exists to similar problems.
+++ Background-information: +++
Table ezworkflow_event has a column 'data_text3'. This Column holds the user-id's of user assigned to the workflow.
mysql> select * from ezworkflow_event; ... data_text3: 651,645,653 ...
UserId 651 is a deleted user, so does not exist anymore. Not even in trash.
Altering the workflow failes with message supplied above.
+++ Expected behavior +++
When removing users from ezpublish, consider looking for the userid in table ezworkflow_event and remove the userid from column data_text3.
The workflow then can be edited successfully as no references to the deleted user exist.
Steps to reproduce
- Create a user 'Alice'
- Add this user to any workflow as 'user allowed to grant...'
- remove this user from ezpublish (delete user completely, do not throw into trash)
- try to edit/alter the workflow