Syntax Error MYSQ

Hi edandrea,

Go into Admin > Section Editors for the section that is causing the error.

First, check that you have a field called "Number". If you don't you'll need to remove it from the fields listed in the sorting tab.

Next, click through all the tabs and check the fieldnames look correct. Sometimes when removing fields if a fieldname is still left in the searching or order by tab you'll get an error because it's trying to sort the record by a field that is no longer there.

If that doesn't fix it feel free to email me CMS login details to dave@interactivetools.com (email, don't post login details to forum) and I can take a look.

Hope that helps!

Hi Dave,

Thanks for your response. I believe I did what you asked me to do and checked the tabs. I renamed what I thought was the trouble area and re pasted it into my .html page but still having the same trouble.



I emailed you back with the login info.

You are going to see two tabs, listings home ( which I will eventually delete) and featured listings (the one I am having trouble with).



For anybody else having the same trouble; I was sorting by "Field Label" and not "Field Name". I had to refresh a couple of times but it did eventually work. So in actuality sort by "Field Name".

edandrea,

Thanks for posting back and glad it's working now.

I've added some more error checking code to the next version to make it easier to identify and resolve these kinds of problems in future.

Hope that helps!