I imported an restore an database and It shows #1067 - Invalid default value for 'user_registered'

My database tables become corrupted so for fixing them I restored data and It shows an error #1067 - Invalid default value for 'user_registered' how can I fix it.

Topic wp-user-query phpmyadmin mysql errors database Wordpress

Category Web

1
answered at

Look up user_registered in your database and set a valid value. This should be a datetime type, as described in the WordPress Codex. Press CMD/CTRL + F and lookup user_registered to quickly navigate.

About

Geeks Mental is a community that publishes articles and tutorials about Web, Android, Data Science, new techniques and Linux security.