Question phpbb3 to Kunena

Well, here, point is to match them manually... so it's up to his eyes

No way. I tried in a lot of mode but I always have the same duplikate key error. I don't have any duplicated user, I checked. Just for test I tried to delete the PRIMARY KEY attribute from the "jos_fb_users" table for allow duplicate key. After this modify the query execute without error but at the end I find in the list of kunena users a lot of duplicate users id, probably this is the cause of the error but is very strange. I suspect I made some mistake during the porting phase where I need to use Excel for match the users list. Maybe I didn't understand well the actions I have to do, someone can explain me better how I sould do using Excel for user matching operation?
Thank you

Falsinfab,

How many users do you have to migrate ?

Did you checked if the posts where linked to the right author or not ?

Hi,

Thank you for your support. The users to migrate are around 100. I don't know how to make the check you asked but maybe you are referring to check after the migration? (in the kunena forum just imported?).

Exactly.

I made the same kind of migration, somehow 100 users and it worked perfetly with my mentionned method... Sorry to say that, but I don't understand why it doesn't work.

Hi again,

I'm tring to repeat the entire process step by step however there is a point in the described process that I don't understane very well. The go.php script imported all the forum categories and post into my kunena db and also created all the users (my starting Joomla have only the administrator user) into Kunena and Joomla. At the end of this operation I have the same users between Joomla and Kunena syncronized with the same ids thta why I need to execute the first query? (the query return me the error). From what I understand from the description this query allow to syncronize Kunena users with Joomla users but in my case it seem they are already syncronized (same id in Joomla and Kunena) that what is the purpose of this query?

UPDATE `jos_fb_users`,`test_mig_users_id`
SET `jos_fb_users`.`userid`= `test_mig_users_id`.`final_jos_id`
WHERE `jos_fb_users`.`userid`=`test_mig_users_id`.`former_phpbb3_id`;