You can use a query like this:
UPDATE user
SET birthday = '00-00-0000', birthday_search = '0000-00-00'
WHERE birthday = '01-01-1901'
Announcement
Collapse
No announcement yet.
Change birthdate for imported users?
Collapse
X
-
Change birthdate for imported users?
After importing all our members back in April, we noticed a couple of things that are both related.
1) everyone that did not enter a birthdate was issued 1/1/1901. that doesnt seem like a big problem, however, we discovered that if the birthdays are set to that, and a user tries to get his password sent to them it will not work. Our Admins have to go in and at least change the year for that to function.
2) we sent out a ton of happy birthday messages today (2900) and users can not login and change the date (for the same reason) we have to go and change the year and then they can update with the real birthday.
is there any way to select everyone that has a 1/1/1901 birthday and automatically change the year? that way we can send out a mass mail and ask people to update the profile with the correct date.
Also because we had so many users listed with birthdays today, we were getting a fatal timeout error on index.php just because on our site we had todays birthday people listed on the main page, as soon as I shut that off, the page loaded fine... it did take me about an hour to figure out why it was doing thatTags: None
Related Topics
Collapse
-
by IncWolfToday we just noticed some strange trouble:
We have user's birthday today, but our module just show us "There is no birthdays today". How can it be?...-
Channel: Support Issues & Questions
Mon 22 Feb '16, 2:16am -
Leave a comment: