Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › MySQLi Server Behaviors › MySQLI Server Behaviors General / Announcements › How to Diagnose "Error in SQL Syntax" on live server

View all replies to this thread

How to Diagnose "Error in SQL Syntax" on live server

Thread began 11/08/2016 3:25 am by astrostrom | Last modified 12/02/2016 9:48 am by astrostrom | 1292 views | 4 replies

11/08/2016 3:25 amastrostrom

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?

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.