MySQL Error

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!

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

Thanks for posting a followup.

Glad it's working again. If you run into any other problems just let us know. :)