 |

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
|
|
|  |
|