Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › DataAssist Search Page: Getting MM_Error: MySQL Error#: 1064 You have an error in your SQ

View all replies to this thread

DataAssist Search Page: Getting MM_Error: MySQL Error#: 1064 You have an error in your SQ

Thread began 9/28/2020 1:20 pm by keith505 | Last modified 9/29/2020 2:24 pm by keith505 | 381 views | 5 replies

9/28/2020 1:20 pmkeith505

DataAssist Search Page: Getting MM_Error: MySQL Error#: 1064 You have an error in your SQ

I setup a DataAssist search and it has been working fine. When back into it today to create a new search column and under the "Column" field, it says "Getting MM_Error: MySQL Error#: 1064 You have an error in your SQ". I also see that error if I try to edit one of the existing columns. The page still runs fine locally and on the server. The recordset connection tests fine. Not sure what changed all of a sudden to cause this but I can't edit or create new search columns.

Using Dreamweaver 2020 - Databridge 1.2.4 -Windows 10

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.