Missing Birthdays

[Savage702]

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]

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.