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?

You either have to
1) update the database to set a default value for nameProduct, or set it to allow NULL.
2) update your insert and update server behavior to set a value if blank to "blank" instead of "default", since there is no default set in the database.

The line of code in question would be:

$UpdateQuery->bindColumn("nameProduct", "s", "".((isset($_POST["txtNameProduct"]))?$_POST["txtNameProduct"]:"") ."", "WA_DEFAULT");

it would become:

$UpdateQuery->bindColumn("nameProduct", "s", "".((isset($_POST["txtNameProduct"]))?$_POST["txtNameProduct"]:"") ."", "WA_BLANK");

There are instances whereby a form field is filled with null data from the database because there wasn't any data inserted previously. Do I set it to "WA_BLANK"? How come this problem didn't occur prior to the server consolidation? Is it because something have "broken" somewhere?
The "WA_DEFAULT" is set by DataAssist by default. Hence I never thought it needs/has to be changed if there is a null record.

It has to be a database settings change that doesn't allow you to leave it as default. Usually if a column allows null, then it will use null by default and wouldn't error. "WA_BLANK" would use an empty string "WA_NULL" would use null, and "WA_DEFAULT" tells the database to use its default value for that column. If the database doesn't have a default then it throws the error.