relationship edit fails after version upgrade [message #501] |
Tue, 26 December 2006 12:47 |
David Lee
Messages: 44 Registered: June 2006
|
Member |
|
|
When trying to edit a relationship, Radicore generates the following error:
2006-12-26 17:21:29
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 '"menu".mnu_task ON (mnu_task.task_id=dict_column.task_id) WHERE (# 256).
SQL query: SELECT SQL_CALC_FOUND_ROWS dict_column.column_id, dict_column.column_desc, dict_table.table_desc, mnu_task.task_desc FROM dict_column LEFT JOIN dict_table ON (dict_table.database_id=dict_column.database_id AND dict_table.table_id=dict_column.table_id) LEFT JOIN "menu".mnu_task ON (mnu_task.task_id=dict_column.task_id) WHERE dict_column.database_id='keycontrol' AND dict_column.table_id='snag' ORDER BY column_seq asc
Error in line 384 of file '/projects/includes/dml.mysql.class.inc'.
Script: /radicore/dict/related_column_multi2.php
User Id: DNL
Remote Address: 192.168.0.187
Request URI: /radicore/dict/related_column_multi2.php?session_name=menu2
<pre>
</pre>
This may be due to having recently upgraded to version 1.19, and so I may have made a mistake in copying existing customised files across.
Can you point me in the right direction?
Thanks
Dave
|
|
|