I've just done a conversion from PHPBB3.1.7-PL1 to Drupal 6.19 and all seems good except that the member join dates and the dates of all posts are set to today's date. This is pretty important as I am converting a forum that's been running for several years.

Did I miss something? I can't see any settings that would affect this.

I notice it was reported back in 2006 (for member join dates anyway) and was shown as "fixed".

Comments

websupportguy’s picture

Title: User dates and post dates were not converted » User dates and post dates were not converted (updated)
Component: Miscellaneous » Code
Priority: Normal » Major

Further information:

I blew my first conversion away completely and started again from scratch. This time I checked the box for date conversion and the forum post dates are OK, but all my users now joined 40 years and 33 days ago.

BTW, I converted this forum (again, before this run) from PHPBB2.0.22 (PHPBB Plus 1.5.3) to PHPBB3 3.1.7-PL1 before converting to Drupal 6.19. I checked all the forum and post dates in PHPBB3 and they were fine.

Also I can copy a member joined date from the PHPBB3 user table to the Drupal user table and the date works fine, so it's something that's happening in the conversion process itself, not in the data.

You can view the converted forums at http://test.bikesonshow.com/forum/.

Tony

websupportguy’s picture

No-one seems too keen to put forward a solution for this one, so I've had to do what I can to fix it myself. For those coming after me who are in a similar position, here's a handy piece of SQL (assuming you still have your PHPBB tables in your Drupal database from the conversion:

UPDATE users, phpbb_users
SET users.created = phpbb_users.user_regdate
WHERE users.name = phpbb_users.username

This copies the user regdate from PHPBB to the user created date in Drupal. Works like a charm.

Still, should not have to do this. It's a bit sad really.

JeremyFrench’s picture

Status: Active » Closed (won't fix)

Mass close of D6 issues for this module as won't fix. Please see #1854186: Support for the 6.x branch.