Radicore Forum: Bug Reports » Auto assign user in workflow that starts with ADD1 task

Home » RADICORE development » Bug Reports » Auto assign user in workflow that starts with ADD1 task

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Auto assign user in workflow that starts with ADD1 task [message #5911]

Thu, 29 September 2016 16:36

kong
Messages: 90
Registered: December 2011

Member

If you apply http:// www.tonymarston.net/php-mysql/infrastructure-faq.html#faq161 to a workflow that starts with an ADD1 task, the ADD1 task will fail with the message "Nothing retrieved from the database".

Stepping through with a debugger shows that the error message is actually generated by the UPD4 task as triggered by the workflow engine.

It appears that upon hitting submit button on the ADD1 task, before the new record completes its commit to the database, the system will first check for and run workflow actions and as a consequence will suspend ADD1 and call UPD4 with the newly created but still uncommitted record as context. Thus, UPD4 won't be able to retrieve that new record from the database, returns the error message and the new record's commit never happens.

Report message to a moderator

Re: Auto assign user in workflow that starts with ADD1 task [message #5914 is a reply to message #5911]

Fri, 30 September 2016 05:14

AJM
Messages: 2368
Registered: April 2006
Location: Surrey, UK

Senior Member

I wonder why I never spotted this problem before? I fixed it by updating the commit() method inside std.table.class.inc so that the code which references the the workflow system comes AFTER the line which sets $GLOBALS['transaction_has_started'] to false.

See the attached file.