Once your birthday has been entered, it cannot be changed. Please contact an administrator if it is incorrect.
If you want to have your members reset them all, then you need a query to set the birthdate to 0/0/0.Can this please be reconsidered? I have 3,000 users who all have incorrect birthdays as a result of a forum conversion. Can't fathom why this isn't an option in the ACP.
If you want to have your members reset them all, then you need a query to set the birthdate to 0/0/0.
I used an update because I had many users with the same birthdate that someone coded in their by default.
Did you want to reset all of them?not that familiar with queries. could someone help me out with this?
UPDATE xf_user_profile
SET dob_day=0, dob_month=0, dob_year=0
Did you want to reset all of them?
Yes, although you may way someone else to verify that.if we reset them, will that allow them to at least go back in and set them?
Yes, although you may way someone else to verify that.
It worked for me but I'd feel terrible if I wrecked your forum.
if we reset them, will that allow them to at least go back in and set them?
UPDATE xf_user_profile
SET dob_day=0, dob_month=0, dob_year=0
WHERE user_id = X
Worked on my test site too. I just don't trust myself giving advice that can self destruct.I just tested on my dev site and it worked fine.
Good idea. Or he can just use his own member number.If you want to test yourself create a new user to test on, and then update for only that user_id.
Code:UPDATE xf_user_profile SET dob_day=0, dob_month=0, dob_year=0 WHERE user_id = [B]X[/B]
Change X to the user_id of the newly created member and execute. Then log in as that member and go into personal details and update birthday.
So the X simply gets replaced by a number, correct? what would the query look like if I wanted to do it to everyone?
bumping this. I have many users who make a mistake on registration
Why punish the admin for the user's mistakes. I got better things to doThey can easily send an admin a message to fix it. Other than that, though, people's birthdays do not change.
Why punish the admin for the user's mistakes. I got better things to do
Of course, but in this case when you have 150k users you'll think differentThe staff is there to help out users. If they can't do that, then they shouldn't be staff.
Did you want to reset all of them?
Add: If you want to reset all birthdates so members can set themselves.
BACKUP YOUR DATABASE FIRST!
Did I mention, BACKUP YOUR DATABASE FIRST?Code:UPDATE xf_user_profile SET dob_day=0, dob_month=0, dob_year=0
We use essential cookies to make this site work, and optional cookies to enhance your experience.