Unable to delete workflow processes
- Status
- Closed
- Subject
- Unable to delete workflow processes
- Version
- 1.9.x
- Category
- Error
- Usability
- Feature
- ~Workflow engine (Galaxia)
- Resolution status
- Won't Fix
- Submitted by
- it.tikiwiki
- Lastmod by
- Marc Laporte
- Rating
- Description
Under Admin Processes, upon attempting to a process, a number of MySQL errors are returned. The problem has to do with the syntax of the DELETE statement. As stated on the Mysql 5.0 reference manual
under the DELETE Syntax,
If you provide an alias for a table, you must use the alias when referring to the table:However, in the DELETE queries, the first reference to the table is the table name itself, which causes the failure.
- Solution
In ProcessManager.php, under the function
remove_process($pID), under the section entitled "Remove all instance data", replace all references to the table name with the table name's alias.- Importance
- 8
- Priority
- 40
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 1707
- Created
- Friday 18 April, 2008 16:22:07 UTC
by Unknown - LastModif
- Thursday 14 January, 2010 19:24:32 UTC