contract has line items inside, which means there are currency and amount involved.
so when the workflow runs, it generates a lot of warnings: “A non-numeric value encountered in ***/modules/Currencies/Currency.php on line 100”
when the workflow completes, and try to update into database job_queue, this message exceeds the maximum allowable length for the job_queue table Message column.
Then it resulted in a job_queue entry update failure, then the job stuck in “running” for ever.
The walk around solution is to disable “MySQL Strict” mode. So database will drop the oversized Message, and allow job_queue to be updated.
But I don’t think it is a longterm solution.
Can anyone suggest how to solve the warning: “A non-numeric value encountered in ***/modules/Currencies/Currency.php on line 100” ???
I had a similar problem with several workflow jobs that were stuck/running. I think I caused this by killing a php process that was sending me 100’s of dummy emails because of logic flaw in a workflow.
I tried editing the status of the workflows and their queued jobs, restarted mysql, apache and finally the server, but to no effect. No obvious log messages…
In the end I worked around it by duplicating each affected workflow, disabling the old and enabling the new. The ‘new’ workflows worked perfectly.