I have moved my website from one server to another am now getting the following error in my admin panel where I view and manage agents: 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 'desc limit 0, 50' at line 1 Anyone recognize this?
'desc limit 0, 50' is your code for sorting query result. did you accidentally change your script? do you use the same mysql version?
I did not change the page code at all. I moved the site because the host I was on had a very old version of MySQL and wanted me to pay them $75 an hour for them to upgrade the versions of MySQL and PHP. I changed to a host that had a new versions already installed. The problem is in code functions I am using that sort the data by either user name or plan expiration date and trying to advance from one page to another (I have 110 agents, with 50 on each page, thus 1, 2, 3, ...)