I have checked the function to update the dates in forum, but it still turns out to be 38 or 37 years some weeks. Is there any SQL queries to fix this?

Comments

naheemsays’s picture

naheemsays commented

In the import settings page there is a tick box for an alternative date processing (it asks you to tick it if all members joined over 30 years ago or something...). Did you accidentally tick that?

jaka’s picture

jaka commented

I think so... What can I do now?

naheemsays’s picture

naheemsays commented

The line doing the time coverssion is 

  $user_regdate = strtotime($user->user_regdate);

No idea how you can reverse that.

Other options would be to either reimport all the data with the correct settings, or to try to correct the timestamps by reimporting them. Use the data in the phpbb2drupal_temp_user table to use the phpbb user_id to drupal uid.

naheemsays’s picture

naheemsays commented
Status: Active » Closed (fixed)

If there is still a problem, please let me know. Otherwise, closing.