Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Insert and Update Failed

Insert and Update Failed

Thread began 5/07/2021 6:46 am by FPhu61701534 | Last modified 5/10/2021 8:47 am by FPhu61701534 | 252 views | 3 replies

5/07/2021 6:46 amFPhu61701534

Insert and Update Failed

I have 3 forms which used to work but are now throwing errors.
Background: There was a server consolidation exercise by my hosting provider a few days ago. The hostname of the WebAssist database connection was thus changed to the new database server's IP address. Since then, pages that insert and update database records failed. However, pages that generate recordsets are still working. The service provider later changed the hostname to "localhost". But the problem persists.

I re-uploaded the WebAssist files to the server several times but the problems persist. It's strange why the error message keeps saying a certain field does not have a default value, which didn't happen before.

May I know what is causing the problem?

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.