Ph: 786-539-6996

Mysql: Incorrect date value: ‘0000-00-00’ for column ‘date’ at row…

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.

March 15th, 2023 | aesio

Leave a Reply

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

Time Programmer Corp Since 2014 ®