MyBB Community Forums

Full Version: help with a sql query
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I was wondering what query to run to reset all birthdays set to 1-1-1970 so it's blank instead.
UPDATE `mybb_users` SET `birthday ` = '' WHERE `birthday` = '1-1-1970';
Thanks matt that did the trick and then i had to rebuild birthdays cache.
i belive this has been fixed in 1.6.1 as new registration since upgrade don't seem to have their birthday set at 1-1-1970.
I don't believe there's any bug related to this is there...??
I believe there was a bug as i don't believe 36 members would type in 1-1-1970 maybe it was a bug in the merge system i'm not sure.
I think it was a bug during 1.4...
Ok well as the issue is now solved i'll mark it as so