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

I can't spot the problem, but if you give me FTP access and steps to reproduce with the URL where the problem happens then I can try to debug it and see what is happening.

Thank you. FTP info in private message.

This appears to be an issue with out of sync connection scripts. It might be a bug in our product that happens when you have data bridge v1 installed and mySQLi server behaviors when editing an old mySQL version of the search server behavior.

I can't reproduce it since I have DataBridge v2 installed and it might be difficult to reproduce your environment.

I can look into this with you in a screen sharing session. If you are interested, please post a good phone number to reach you in the private area and I'll give you a call.

Thank you, Ray. I just remembered that I had installed eCart 6 a few days ago, so I uninstalled that extension and still had the same issue. I then uninstalled and reinstalled Data Bridge and that resolved the issue. So, my assumption is that eCart overwrote some a file that triggered the problem. I don't use eCart often, so this shouldn't be an issue for me.

Re-installing DataBridge after eCart should resolve the issue if you need eCart installed.