
November 13th, 2012, 01:29 PM
|
|
Contributing User
|
|
Join Date: Oct 2012
Posts: 35
Time spent in forums: 4 h 15 m 8 sec
Reputation Power: 1
|
|
|
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.
R
|