Important phpBB Migrator: Looking for phpBB3 users that want to convert their data to Kunena 1.6

I am getting

Kunena version: 1.7.0
Using relative path: ../myforum.net
Detecting phpBB3: OK
Database connection: OK
phpBB3 version: 3.0.5
Error: Unsupported forum: phpBB3 3.0.5

and nothing happen, why ?

it doesnt work , migrate users keeps empty

Error: Unsupported forum: phpBB3 3.0.5

Why dont you upgrade to the latest version?

Just upgrade the database part the rest doesnt matter - as you are going to merge you forum!

I have updated the database to 3.09

Kunena version: 1.7.0
Using relative path: ../myforum.net
Detecting phpBB3: OK
Database connection: OK
phpBB3 version: 3.0.9
phpBB authentication method: db

and now I get

Error: Table 'my_forum_phpbb.phpbb_acl_roles' doesn't exist SQL=SELECT u.user_id AS userid, ag.forum_id AS catid FROM phpbb_acl_roles AS ar INNER JOIN phpbb_acl_groups AS ag ON ar.role_id=ag.auth_role_id INNER JOIN phpbb_user_group AS ug ON ug.group_id=ag.group_id INNER JOIN phpbb_users AS u ON u.user_id=ug.user_id AND u.user_id > 0 AND u.user_type != 2 WHERE role_type='m_' LIMIT 0, 10000

I understand all my tables are phpbb3_acl_roles
is there any settings to change the prefix name ? maybe a line in your code ?

I have tried to change
$prefix = substr ( $prefix, 0, strpos ( $prefix, '_phpbb3_' ) );
but it doesnt work

polpaulin wrote: I have updated the database to 3.09

Kunena version: 1.7.0
Using relative path: ../myforum.net
Detecting phpBB3: OK
Database connection: OK
phpBB3 version: 3.0.9
phpBB authentication method: db

and now I get

Error: Table 'my_forum_phpbb.phpbb_acl_roles' doesn't exist SQL=SELECT u.user_id AS userid, ag.forum_id AS catid FROM phpbb_acl_roles AS ar INNER JOIN phpbb_acl_groups AS ag ON ar.role_id=ag.auth_role_id INNER JOIN phpbb_user_group AS ug ON ug.group_id=ag.group_id INNER JOIN phpbb_users AS u ON u.user_id=ug.user_id AND u.user_id > 0 AND u.user_type != 2 WHERE role_type='m_' LIMIT 0, 10000

I had the same error message. This is because the phpbb3 prefix is hardcoded into the migrator. The standard prefix is phpbb_. In my case, the prefix for the phpbb tables is phpbb3_. Therefore the converter does not find the phpbb tables.

Quick workaround is to modify the file models/export_phpbb3.php and change all table prefixes into your own prefix. It would be nice if in the final version, this can be entered into the converter.

Cheers,

Ronald

yes the prefix should be optional and not hardcoded


thank you