 |
IronVictory
User
Feb 19, 2008, 10:46 AM
Post #1 of 4
(260 views)
Shortcut
|
I am running MySQL version 4.1.21.
I get this error when I view the live page and in the admin:
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 'ASC LIMIT 25 OFFSET 0' at line 1
Peter
|
|
| |
|
Dave
Staff
/ Moderator
Feb 19, 2008, 11:21 AM
Post #2 of 4
(257 views)
Shortcut
|
Hi Peter, welcome aboard! :)
What version of CMS Builder are you using? (Check under Admin > General > Program Version). And does the error occur on all sections or just some?
My first guess is that you have a field name in one of the sections that is a reserved MySQL keyword (such as "order"). Check the "List Order" and "Order By" fields and if you have a field like that put `backticks` around it. The backtick key is beside the 1 key on my keyboard. Putting `backticks` around reserved fields let's MySQL know it's not a special command.
So if you had: order ASC, date DESC, title
Change that to: `order` ASC, date DESC, title
Let me know if that helps!
Dave Edis - Senior Developer
interactivetools.com
|
|
| |
|
IronVictory
User
Feb 19, 2008, 11:32 AM
Post #3 of 4
(256 views)
Shortcut
|
Hi Dave,
I found the error. To benefit others:
I had: community, ASC
It should be: community ASC (no comma)
BTW CMS Builder is v1.09
Peter
|
|
| |
|
Dave
Staff
/ Moderator
Feb 19, 2008, 1:06 PM
Post #4 of 4
(254 views)
Shortcut
|
Thanks for posting a followup.
Glad it's working again. If you run into any other problems just let us know. :)
Dave Edis - Senior Developer
interactivetools.com
|
|
| |
|
