XF 1.3 Reset Users Birthdays

[Hentai]

Is there any way to mass-reset or allow users to change their birthday?

My message board was initially SMF but after some problems we had switched to MyBB before XenForo. Part of the SMF -> MyBB transition included setting many users birthdays to 1/1/1901.

What are my options in terms of fixing this because having admins manually set birthdays for +500 members is arduous to say the least.

 

[Amaury]

You'll need an add-on to allow anyone that isn't an administrator to change their birthday.

For now, you can just have the users with incorrect birth years message you and the other admins their correct birth years, and then you guys can fix them.

 

[AndyB]

What are my options in terms of fixing this because having admins manually set birthdays for +500 members is arduous to say the least.

500 isn't too many. Just do about 50 a day in your spare time and you will be done in 10 days.

 

[Mike]

Well, if you wipe out the birthdays in the DB, they can reset them: (they just can't change them after the fact)

UPDATE xf_user_profile SET dob_day = 0, dob_month = 0, dob_year = 0 WHERE dob_year = 1901;

 

[Hentai]

@Mike Thanks that is just what I needed!