Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › Dreamweaver › mysql error #1064

mysql error #1064

Thread began 12/18/2018 3:55 pm by davidgard | Last modified 12/18/2018 5:04 pm by Ray Borduin | 16 views | 2 replies |

12/18/2018 3:55 pm | #1 davidgard

mysql error #1064

I just installed the MySQLi Server Behaviors and after successfully defining a database connections, I tried to run a simple query to test (Select * from users) and I get a mysql error #1064

12/18/2018 4:43 pm | #2 Ray BorduinWebAssist

That error usually means a bad SQL statement. I'd need FTP access and a URL to reproduce. Are you sure your connection information is correct? Are you able to test your database connection and see the table names in Dreamweaver?

12/18/2018 4:57 pm | #3 davidgard

Yes, I am positive the connection details are correct (I can see the tables).
The statement is correct. It runs fine in MySQL workbench. If I skip the test button and just insert, it worked. Im not sure what changed, but it seems to work now.

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.