Hello, after running the convert system to move my phpBB forum to a myBB forum (1.6.1) it seem all dates of birth have been very messed up.
Is there any way to fix this?
Thank you.
A link to your forum and a more descriptive post about what is happening would help us help you. For support posting guidelines please read the Posting Rules notice at the top of this page:
http://community.mybb.com/forum-141-page-1.html
Sorry guys, I looked over stickied threads, but somehow missed that. My apologies for the mistake. That is somewhat what happens, and after running the query it solved the php error that was being thrown.
However, for those users, their DoB was set to "Not Specified", which is fine and works for me, but for some users, their DoB was (before query), and after that query still was set to "11-30- 0", leaving them at 2010 years old. This is of course somewhat bizzare and incorrect.
So I just took the query and chopped off the match, leaving me with
UPDATE `mybb_users` SET `birthday` = '';
You may want to update your post to also offer that query, in the event the first one doesn't fix the problems, although it of course changes ALL DoB's, not just the "bad" ones, but in my case, they were all errors, either the one you provided the fix for, or the user being 2010 years old.
Forum Url in-case you want for some reason:
http://xserverx.com/forums/
Example user that is (now) working properly:
http://xserverx.com/forums/user-226.html