November 13th, 2012, 02:29 PM
INSERTing unspecified fields on my new server
I just moved my DB to a new server and upgraded to the latest version on MySQL.
On my old server config (hosted by others) if I inserted a record without specifying all columns, it would enter a null or blank value for the unspecified columns.
On the new server, I get an error for each unspecified column.
Since the table and column attributes have not changed, I believe this a global setting that needs to be modified on the new setup.
Any help would be appreciated.
November 13th, 2012, 04:29 PM
confirm this by doing a SHOW CREATE TABLE for the same table on both servers
Originally Posted by karnival800