Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › Data Bridge General / Announcements › Weird "There is an error in your SQL syntax." error appearing on INSERT behaviour page.

View all replies to this thread

Weird "There is an error in your SQL syntax." error appearing on INSERT behaviour page.

Thread began 4/05/2023 10:43 am by Nathon Jones Web Design | Last modified 4/05/2023 4:15 pm by Nathon Jones Web Design | 244 views | 4 replies

4/05/2023 10:43 amNathon Jones Web Design

Weird "There is an error in your SQL syntax." error appearing on INSERT behaviour page.

Client has been in touch to say that when they attempt to "Add Property" from their admin area, no matter what they do they get "There is an error in your SQL syntax" upon submission of the form.

The form uses WebAssist extensions to support the INSERT to database and File Uploading. I've provide a link to the admin area and credentials for logging in.

The weird bit is that the page that's reporting the error loads fine, it's only when you submit the form that it reports the syntax error.

We've downloaded and updated DataBridge, so far as we can tell, so we're pretty sure it's not that. We've also got PHP errors switched to display, so we can see the syntax error, but that's not working either.

Hoping you can help. Thank you.
NJ

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.