Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE development » Bug Reports » sql error adding a nav button
sql error adding a nav button [message #795] Wed, 02 May 2007 12:22 Go to previous message
interop is currently offline  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

 
Read Message
Read Message
Read Message
Read Message
Previous Topic: include.xml.php5.inc syntax error
Next Topic: Primary Key in not complete
Goto Forum:
  


Current Time: Sat Apr 27 19:57:21 EDT 2024

Total time taken to generate the page: 0.00845 seconds