How to Diagnose "Error in SQL Syntax" on live server
I have a set of admin pages that works fine locally. But on the live server I get the "Error in SQL Syntax" message. I ran a Test DB connection script and connection worked. I created a new DB user on the server backend and deleted the rsobj.php file and regenerated a new one by making a new recordset.
BTW - I did not find the line "Debug = false;" in the rsobj.php file - so I added it to the file but it did not help.
Checked the SQL in phpMyAdmin - no problem - so it must be a connection error of some kind.
Any idea what do to next?