Error Message
2 posts by 2 authors in: Forums > CMS Builder
Last Post: March 3, 2008 (RSS)
By JamesKB - March 3, 2008 - edited: March 3, 2008
HiYa Jake.... (I hope you see this)
I've created a section called "Test About Us," that has 2 records. I have created a field called "order" in each record. When I click "Test About Us" from the CMSB menu I get this error message:
MySQL Error: 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 'order LIMIT 25 OFFSET 0' at line 1
Have a look at: http://www.crcongregation.org/test.php
Any ideas?????
I've created a section called "Test About Us," that has 2 records. I have created a field called "order" in each record. When I click "Test About Us" from the CMSB menu I get this error message:
MySQL Error: 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 'order LIMIT 25 OFFSET 0' at line 1
Have a look at: http://www.crcongregation.org/test.php
Any ideas?????
Have a nice day....
--
JamesKB
--
JamesKB
Re: [JamesKB] Error Message
By Dave - March 3, 2008
"order" is a special MySQL keyword. Try putting `backticks` (the key beside the 1 on my keyboard) around it in the sort order fields like this: `order`. Or rename the field to something else such as "sortOrder".
Hope that helps!
Hope that helps!
Dave Edis - Senior Developer
interactivetools.com
interactivetools.com