1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.3 Reset Users Birthdays

Discussion in 'Troubleshooting and Problems' started by Hentai, Aug 17, 2014.

  1. Hentai

    Hentai Member

    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.
  2. Amaury

    Amaury Well-Known Member

    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.
  3. AndyB

    AndyB Well-Known Member

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

    Mike XenForo Developer Staff Member

    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;
  5. Hentai

    Hentai Member

    @Mike Thanks that is just what I needed!

Share This Page