Kunena Migration
By Shane Williams on Monday, 17 March 2014
Posted in Technical Issues
Replies 3
Likes 0
Views 846
Votes 0
Support,

I used the migration tool in EasyDiscuss to transfer my Kunena posts however changed my mind and would like to keep them in Kunena.

Whilst I do have a backup I can restore, I thought I would just go into EasyDiscuss discussions and delete them all ... when attempting to do this I receive an error ....

"An error has occurred. 1062 Duplicate entry '0' for key 'PRIMARY' SQL=INSERT INTO `p125i_discuss_users` (`points`) VALUES ('0') "

Please can you look to resolve this error.

You can delete any post you like, some will throw the error some wont ... this post is a good one to start with: "RE Error 404 on Amadeus"

Also - Do you know any method of getting Kunena posts into MyBlog? .... most of my forum posts are more suited to a blog rather than a forum.

Thanks
Shane.
Hello Shane,

Is it possible for you to provide us with the back end and FTP access to your site to check on this issue? As for getting Kunena posts into EasyBlog, unfortunately that is not possible currently
Mark
·
Monday, 17 March 2014 23:05
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Mark,

In did supply this access last week on a post - do I need to add it with each request?

Can you look at my previous request on this occasion?

Thanks
Shane
Shane Williams
·
Monday, 17 March 2014 23:32
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Shane Williams,

Sorry for late reply to this,
I have checked in your site, it seems like when you migrated the Kunena discussion post to Easydiscuss, i noticed that database message you provided to us
"An error has occurred. 1062 Duplicate entry '0' for key 'PRIMARY' SQL=INSERT INTO `p125i_discuss_users` (`points`) VALUES ('0') "

so i checked in your table p125i_discuss_users, it seems like inside the ID column have "0", so most probably you hitting this issues is because of this.
I have manually help you deleted it, and help you some of the discussion post change the guest author to Shane Williams ID 62


//discussion post

Azura - Travel Weekly Article

Ship Visit – Cruise & Maritime's Ocean Countess

Places to Stay in Southampton - ETAP HOTEL

The Queen Victoria, Greenock, 28th July 2010


Because i noticed this 2 user ID is not existed in your site.
Warning

JUser: :_load: Unable to load user with ID: 164

JUser: :_load: Unable to load user with ID: 141


Please have a check is it still hitting the error message? Please advise.
Arlex Wong
·
Tuesday, 18 March 2014 02:16
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post