×
Kunena 5.2 Beta 1 Released (24 Sep 2020)

The Kunena team is thrilled to announce the first public beta release of Kunena 5.2, a native Joomla extension for Joomla 3.9. This is a development release and should be only be used for testing; this version is not recommended for live websites at this stage.

The purpose of this release is to encourage testing by downloading, installing and identifying any problems or shortcomings that people may discover. K 5.2.0 B1 is stable and we are aware that people will discover defects. We encourage you to use the forum to report defects, as soon as they are discovered, so that the development team can work through the problems before the release of K 5.1 as a stable product. Reporting defects does not mean that the problems can or will be fixed. The Kunena team is looking forward to hearing your feedback on how well we have achieved our design goals.

Question Error trying to import from Agora 3

More
8 years 8 months ago #1 by tinny
When trying to import Agora I get this error
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
8 years 8 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
8 years 8 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
8 years 8 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
8 years 8 months ago - 8 years 8 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
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: 8 years 8 months ago by tinny.

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

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

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

More
8 years 8 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
8 years 7 months ago #8 by tinny
@xillibit @matias anyone?

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

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

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

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

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

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Time to create page: 0.173 seconds