sql error adding a nav button [message #795] |
Wed, 02 May 2007 12:22 |
interop
Messages: 45 Registered: October 2006
|
Member |
|
|
I'm trying to add a nav button to my employee list task and get the following error. It looks to be happening in Default_Table::_examineWorkflowInstance().
(version 1.24.0)
Fatal Error: MySQL error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('iol_employee(list1)''%' AND workitem_status='EN') ORDER BY wf_workitem.work' at line 1 (# 1064).
SQL query: SELECT SQL_CALC_FOUND_ROWS user_id, role_id, wf_workitem.workflow_id, case_id, workitem_id, wf_workitem.task_id, transition_trigger, workitem_status, enabled_date, cancelled_date, finished_date, deadline, context, workflow_name, task_desc FROM wf_workitem LEFT JOIN wf_workflow ON (wf_workflow.workflow_id=wf_workitem.workflow_id) LEFT JOIN menu.mnu_task ON (mnu_task.task_id=wf_workitem.task_id) WHERE wf_workitem.task_id='mnu_nav_button(multi)' AND wf_workitem.context LIKE 'task_id=' ('iol_employee(list1)''%' AND workitem_status='EN') ORDER BY wf_workitem.workflow_id, wf_workitem.case_id, wf_workitem.workitem_id asc
[Updated on: Wed, 02 May 2007 12:36] Report message to a moderator
|
|
|