Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to solve the mysql error report "# 1067 invalid default value", has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, let the editor take you to understand it.

Reminder: the information described in this article may have changed, please use it with caution.

Many wordpress comments have been deleted, causing the comment id fault to be too large. To make it continuous, use the following command to modify the self-increment id to re-count:

As a result, the report was wrong, prompting:

# 1067-Invalid default value for comment_date

I remember that there was no problem with using this command in the past. I looked it up on the Internet and found that it was the problem with mysql. The mysql5.6 I used before was upgraded to 5.7not long ago, and the online method was feasible.

Directly follow the online tutorial to modify the configuration file my.cnf of mysql and edit my.cnf

Add the following under [mysqld]:

After saving, restart mysql, and then execute the command to modify the self-incrementing id, and everything is fine.

There is another temporary way to do this online:

The reason for this problem is that the default value of comment_date is 0000-00-0000: 00:00, check sql_mode, there is "NO_ZERO_IN_DATE,NO_ZERO_DATE", these two parameters limit time cannot be 0, so there will be an error!

Thank you for reading this article carefully. I hope the article "how to solve the mysql error report" # 1067 invalid default value "shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.