Elxis CMS Forum

Support => General => Topic started by: xmanhattan on May 28, 2009, 17:11:25

Title: Elxis 2009 1064 error
Post by: xmanhattan on May 28, 2009, 17:11:25

Hello all,

While making changes to the title of the faq's category in 2009, I received the following mysql error.

Code: [Select]

mysql Error [1064] : EXECUTE
URI: index2.php
Message: 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 's') OR (seotitle='faqs')) AND section='2'' at line 1
SELECT id FROM wye_categories WHERE ((name='FAQ's') OR (seotitle='faqs')) AND section='2'
mysql Error [1064] : EXECUTE
URI: index2.php
Message: 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 's' WHERE name='FAQ\'s' AND type='content_category'' at line 1
UPDATE wye_menu SET name='FAQ's' WHERE name='FAQ\'s' AND type='content_category'
mysql Error [1064] : EXECUTE
URI: index2.php
Message: 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 's' WHERE name='FAQ\'s' AND type='content_category'' at line 1
UPDATE wye_menu SET name='FAQ's' WHERE name='FAQ\'s' AND type='content_category'

Elxis 2009.0 Stable rev2437 [ Pandora ] 22-May-2009 10:31 GMT+2

Title: Re: Elxis 2009 1064 error
Post by: datahell on May 28, 2009, 19:13:47

Please don't insert quotes in titles.