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 *