Kunena 6.3.7 Released

The Kunena team has announce the arrival of Kunena 6.3.7 [K 6.3.7] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x/5.2.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 and issues discovered during the last development stages of K 6.3
Note: Please go to the Kunena Dashboard after an upgrade so that the Kunena database tables are also updated.

Question Error trying to import from Agora 3

More
12 years 10 months ago #1 by tinny
When trying to import Agora I get this error
Code:
ERROR: KunenaImporterTableUserProfile::store failed - Duplicate entry '62' for key 1 SQL=INSERT INTO `jos_kunena_users` ( `userid`,`view`,`signature`,`moderator`,`ordering`,`posts`,`avatar`,`karma`,`karma_time`,`uhits`,`personalText`,`gender`,`location`,`ICQ`,`AIM`,`YIM`,`MSN`,`SKYPE`,`GTALK`,`websiteurl`,`hideEmail`,`showOnline` ) VALUES ( '62','flat','www.urlofmysite.it','0','0','28','','0','0','0','','0','','','','','','','','','0','1' )

Please Log in or Create an account to join the conversation.

More
12 years 10 months ago #2 by xillibit
Hello,

Your Kunena installation was clean or not ?

I don't provide support by PM, because this can be useful for someone else.

Please Log in or Create an account to join the conversation.

More
12 years 10 months ago #3 by tinny
1.71 just installed, absolutely clean.
The id 62 is the admin's id

Please Log in or Create an account to join the conversation.

More
12 years 10 months ago #4 by xillibit
Make a backup of your table jos_kunena_users, then delete the item in it and try a new once to import data with Kunena importer.

I don't provide support by PM, because this can be useful for someone else.

Please Log in or Create an account to join the conversation.

More
12 years 10 months ago - 12 years 10 months ago #5 by tinny

xillibit wrote: Make a backup of your table jos_kunena_users, then delete the item in it and try a new once to import data with Kunena importer.

Thanks for the support.
I got the same error with messages and categories, truncated the tables and tried again.
Got this one when nearly finished importing messages
Code:
ERROR: KunenaImporterTableMessages::store failed - Duplicate entry '91311' for key 1 SQL=INSERT INTO `jos_kunena_messages` ( `id`,`parent`,`thread`,`catid`,`name`,`userid`,`email`,`subject`,`time`,`locked`,`ordering`,`hits` ) VALUES ( '91311','6020','6020','12','alia','1148','[email protected]','ritardi spedizioni','1326374256','0','0','458' )
Just tried several times to truncate and re-import... Got similar error in different positions.
Isn't there the possibility to automatically skip duplicates?
Last edit: 12 years 10 months ago by tinny.

Please Log in or Create an account to join the conversation.

More
12 years 10 months ago #6 by tinny
Tried again and again, still stuck there. :(

Please Log in or Create an account to join the conversation.

More
12 years 10 months ago #7 by tinny
the error is always at ID 90690.
tried to change this id, but I get the same error when importing next items in kunena_messages and kunena_messages_text

Please Log in or Create an account to join the conversation.

More
12 years 9 months ago #8 by tinny
@xillibit @matias anyone?

Please Log in or Create an account to join the conversation.

More
12 years 9 months ago #9 by tinny
@santa claus?

Please Log in or Create an account to join the conversation.

More
12 years 8 months ago #10 by tinny
@Freddy Krueger?

Please Log in or Create an account to join the conversation.

Time to create page: 0.348 seconds