Radicore Forum: RADICORE Installation Issues » relationship edit fails after version upgrade

Home » RADICORE » RADICORE Installation Issues » relationship edit fails after version upgrade

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: relationship edit fails after version upgrade [message #502 is a reply to message #501]

Wed, 27 December 2006 12:39

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

I have run this task several times without reproducing this error. I cannot even see where this sql query is being generated. Can you provide me with the contents of errorlog.html on this error? This contains output from debug_backtrace() which will provide more information.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: relationship edit fails after version upgrade [message #504 is a reply to message #502]

Wed, 27 December 2006 13:03

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

If you look at the upgrade instructions for version 1.19.0 you should see where you must set "sql_mode='ANSI_QUOTES'" if your version of MySQL is before 4.1

This is why it is objecting to the double quotes around "menu".

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: relationship edit fails after version upgrade [message #505 is a reply to message #504]

Wed, 27 December 2006 15:36

David Lee
Messages: 44
Registered: June 2006

Member

Thanks, Tony
Having put the option in the configuration file, and restarted the mysql server, it now works.

Report message to a moderator

Previous Topic:	help
Next Topic:	Supported versions of mysql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Jul 05 19:35:32 EDT 2025

Total time taken to generate the page: 0.10229 seconds