mysql error Field doesn’t have a default values ?

Here is the steps to solve  field doesn’t have a default values error

1) Go to phpMyadmin

2) Click on variables menu  as shown in figure

mysql error Field doesn't have a default values

 

3) Scroll down to find sql mode and click on edit button as shown in below  image remove ‘STRICT_TRANS_TABLES’ Save it.

 

remove 'STRICT_TRANS_TABLES' Save it.

 

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *