To avoid this issue, you need to remove NO_ZERO_DATE from the mysql mode configuration.

1. Go to ‘phpmyadmin’.
2. Once phpmyadmin is loaded up, click on the ‘variables’ tab.
3. Search for ‘sql mode’.
4. Click on the Edit option and remove NO_ZERO_DATE (and its trailing comma) from the configuration.

This is a very common issue in the local environment with wamp or xamp.