PDA

View Full Version : Missing Birthdays


Savage702
Wed 5th Mar '08, 2:20pm
Sorry, not sure if this is the right area, and I may be beyond help.

I imported from my old forum to vbulletin (older version of phpbb), went to the latest stable version, then upgraded to 3.7.0 b5. Got all setup, everything is great except birthdays. For some reason in the database all I see for birthdays is '--2281' '--1933' '--3054' or some variation of random numbers. I'd really hate to lose the birthdays, but I will to save me all the time I spent with permissions and such.

Thanks,

Mark

Savage702
Wed 5th Mar '08, 3:56pm
Sorry, not sure if this is the right area, and I may be beyond help.

I imported from my old forum to vbulletin (older version of phpbb), went to the latest stable version, then upgraded to 3.7.0 b5. Got all setup, everything is great except birthdays. For some reason in the database all I see for birthdays is '--2281' '--1933' '--3054' or some variation of random numbers. I'd really hate to lose the birthdays, but I will to save me all the time I spent with permissions and such.

Thanks,

Mark

Ok, I think I figured this out. Mods please move this to appropriate location as it's not a 3.7 issue.

If others have this prob, open following Imprex file upload\impex\systems\phpBB2\004.php

Look around line 189 for the following:
/* Old Hack
$bd = $user['user_birthday']*86400+86400;
$year = @date("Y", $bd); // Errors off for windows
$month = @date("m", $bd);
$day = @date("d", $bd);
*/


and uncomment it, and comment in the following right below it:


$year = substr($user['user_birthday'], 0, 4);
$month = substr($user['user_birthday'], 4, 2);
$day = substr($user['user_birthday'], 6, 2);


Rerun import users. Worked for me on a quick test board I setup. Now I'm just going to upgrade the test all the way to 3.7 b5 and export the users table and re-import it.