close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Inser / Update - error your SQL syntax

Thread began 11/03/2020 5:08 am by georgina_barrett_187762 | Last modified 11/03/2020 12:08 pm by Ray Borduin | 13 views | 2 replies |

georgina_barrett_187762

Inser / Update - error your SQL syntax

I have a content manger working perfectly on one of my sites. I have copied it and the database to another site hosted on a different server and for some reason I don't seem to be able to insert / update on some pages. I am getting an error your SQL syntax when I try and do it. Some inserts and updates on the content manager work and some don't. I have attached a copy of some of the files that don't work. I have checked to see if the datatyoes match with the database and as far as I can see they do. The strange thing is I have copied both the database and the content manger from a different domain that all works perfectly.

Sign in to reply to this post

Ray BorduinWebAssist

It is probably missing columns in the database. This isn't something I could spot in the code. If you give me a url with steps to reproduce and FTP access, then I could probably track it down.

You might try updating the queryobj.php file and changing the Debug setting to true. That might give you more information about the error to help you figure it out on your own.

Sign in to reply to this post
Did this help? Tips are appreciated...

georgina_barrett_187762

That did it thank you. I changed the Debug setting to true in the queryobj.php file and it showed the error:
Field 'Email' doesn't have a default value
I have made it a NULL default value in the database and it works now.

Sign in to reply to this post

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...