This Post Has 4 Comments

1. 

   Amr 2010-03-29 Reply

   Thanks for helping people 🙂

   Just I don’t know if this converter will work correctly with my forum because I have around 5 million post and around 130.000 user.
   please let me know if this possible, I’ve tried the old converter but I always had time out error.

   Thanks Mate.

   1. 

      Tom V 2010-03-29 Reply

      Hi,

      If you get a timeout, first try to convert offline (like told in the knownledgedb of phpBB.com)

      If you get a SQL ran out of memory problem, I suggest to open functinos_phpbb2CH and find
      
if ($convert->mysql_convert && $same_db)
{
$src_db->sql_query("SET NAMES 'binary'");
}
// Grab forum auth information from 2.0.xCH board, without the admin group
$sql = "SELECT ug.user_id, g.group_single_user, g.group_user_id, a . *
FROM {$convert->src_table_prefix}auths a
LEFT JOIN {$convert->src_table_prefix}groups g ON g.group_id = a.group_id
LEFT JOIN {$convert->src_table_prefix}forums f ON f.forum_id = a.obj_id
LEFT JOIN {$convert->src_table_prefix}user_group ug ON g.group_id = ug.group_id
WHERE a.obj_type = 'f'
AND g.group_id <> " . GROUP_FOUNDER . "
AND g.group_id <> " . GROUP_ADMIN;

      $result = $src_db->sql_query($sql);

      $usergroup_access = array();
while ($row = $src_db->sql_fetchrow($result))
{
$usergroup_access[] = $row;
}
$src_db->sql_freeresult($result);

      and replace it with
      $usergroup_access = array();

      This will remove the convertion of all authentication, but as founder you can set it manualy.
      Next it’s suggested to do this as you can then use roles instead of manual permissions.

      If it still doesn’t work, you can mail me, then I’ll update the database for you.

2. 

   Amr 2010-03-29 Reply

   Thanks a lot Tom. I am thinking to do that in April, so I will update you with the details.

   Thanks again.

3. 

   Tom V 2010-03-29 Reply

   Just to report, from 8 till 17 April I’m at the USA so I won’t be able to check Internet (at most, I can just surf a bit)