1064 You have an error in your SQL syntax - now appears when looking at any/all forms in backend of Chronoforms 5

Hi there,

I just updated to Joomla 3.8 and ensured that I have the August update of Chronoforms 5....

My forms are all working fine from the front-end, but I can no longer edit any of them in the administration portal. Clicking on any one of them gives me the following error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= '4'' at line 1

I checked that I have the latest version of ChronoForms 5...

I'm not too sure how to debug this - any advice is much appreciated.

Joomla: 3.8.1
ChronoForms v5: 5.0.16
Php: 5.6.31
Database: mysqli


Thanks & best regards,

Alex

Hi Alex,

I'm not seeing this here with CFv5 and Joomla! 3.8.1

Does the error message show the full MySQL query that is failing?

Bob

Hi Hi Bob!

Thanks for the quick response!

The error does not show any further detail - hence I am not sure what I can do to debug further...



There is no additional data in the page source.

Is there a way to turn on additional debugging info?

Thank you!

Alex

Hi Alex,

Please try turning Site Debugging on temporarily, with luck that will show all the MySQL queries generated including this one.

Bob

Thanks Bob!

OK.... I turned on the site debugging and received this information:



I am afraid it still shows no query😟

Here are the forms I made.... (and which were editable before the updates...)



If you can suggest any other debugging toggles I can give them a try!

Thanks again for your help🙂

Alex

Hi Alex,

By all means PM me the site URL, the form name, and a SuperAdmin login and I'll take a quick look.

Bob