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.

1 Answer 1


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.

  • Its just DATETIME: Magical numbers problem in my database I edit it and It worked thank you for your comment man I appreciate.
    – Sachin
    Oct 19, 2020 at 3:50
  • No problem, please mark as solution if it helped. :)
    – Tom
    Oct 19, 2020 at 7:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.