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

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

Oops, my bad. There are downsides when you copy queries from phpMyAdmin.

at 99% of the messages import I get

ERROR: KunenaImporterTablePolls::store failed - Duplicate entry '234149' for key 'PRIMARY' SQL=INSERT INTO `jos_kunena_polls` (`id`,`title`,`threadid`,`polltimetolive`) VALUES ('234149','','234149','0000-00-00 00:00:00')

too bad

there is no users in jos_users tables and all my users in kunena_users but all the userid are negatives !
the forum is empty and no users

it doesnt work

I have deleted all and reinstall, now the importation was 100 % ok but :
all my 150 users are in the table jos_kunenaimporter_users , all are migrated = 0
jos_users and jos_kunena_users are empty but me, how can I migrate the users ?

thank you

if I go to Forum Importer: Migrate Users


they are all Blocked how can I add all the users to Kunena and Joomla ?

if I check all and click map missing it change nothing

I must open the users one by one and import them