Birthday Problem

[rockinaway]

You can see my forum here: http://www.adminfuel.com

All the birthdays that have been imported from SMF are today, lots of members.

Here is some more info: http://www.vbulletin.org/forum/showthread.php?t=200333

What should I do?

[Shadab]

You can do something like...

Run a SELECT query on your forum DB :

SELECT username, birthday FROM user
WHERE birthday LIKE '01-01-%'

(selects the users with a birthdate of 1st Jan [Any Year])

If it lists all the names of the users who are showing up as having a b'day today...
set their b'day to blank :

UPDATE user
SET birthday = ''
WHERE birthday LIKE '01-01-%'

Or if you are sure that those users are having b'day set to specifically :
01-01-0001 or 01-01-1970 you can run a more specific update query like :

UPDATE user
SET birthday = ''
WHERE birthday = '01-01-1970' OR birthday = '01-01-0001'

Run the SELECT queries first to be sure of what data you are gonna remove.
And then only execute the UPDATE. (that too after taking a backup of the USER table)

[rockinaway]

I did that, yet the birthday count is still the same. all the names are listed. what information do I have to rebuild?

[Shadab]

Ah.. after digging thru the database as well as some forum posts,
found that there is also another field "birthday_search" which needs to be set.

Searching...

SELECT username birthday, birthday_search
FROM user
where birthday_search = '0001-01-01'

Updating...

UPDATE user
SET birthday_search = '0000-00-00'
WHERE birthday = '01-01-0001' OR birthday_search = '0001-01-01'

[As always, take backup before executing queries].
Reference : http://www.vbulletin.com/forum/showthread.php?p=1168139

* hope it works.
* won't be available for the next some hours. Gonna get some sleep.

[rockinaway]

done them yet still the birthdays remain. do I need to rebuild?

[Shadab]

Maybe. But i couldn't find any option in the adminCP update counters page,
which would rebuild user profiles. Theres just an option to 'fix' them.

EDIT:

Looks like Steve suggested to empty the complete birthday field. Clearing even valid b'days too.
See the thread : http://www.vbulletin.com/forum/showthread.php?t=295224

[rockinaway]

I will wait until next year I guess. See if it happens again.