Announcement

Collapse
No announcement yet.

Birthday Problem

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    Leave a comment:


  • Shadab
    replied
    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
    Last edited by Shadab; Thu 1 Jan '09, 9:42pm.

    Leave a comment:


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

    Leave a comment:


  • Shadab
    replied
    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...
    Code:
    SELECT username birthday, birthday_search
    FROM user
    where birthday_search = '0001-01-01'
    Updating...
    Code:
    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.

    Leave a comment:


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

    Leave a comment:


  • Shadab
    replied
    You can do something like...

    Run a SELECT query on your forum DB :
    Code:
    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 :

    Code:
    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 :

    Code:
    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)

    Leave a comment:


  • rockinaway
    started a topic Birthday Problem

    Birthday Problem

    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?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X