Public Forums 71,145 posts

[kicr Friend kicrJoin date: June 2007Posts: 84Downloads:30Uploads:10 Thanks: 13 Thanked: 6 times in 1 posts]

#575915

I got the same error and my database had duplicated titles in the #__k2_items table. This statement show you the duplicated entries:

SELECT COUNT(*) AS COUNT, title, id FROM j25_k2_items GROUP BY title HAVING COUNT(*) > 1

Then i edited each entry to make it unique. After that, the import ran successfully.

1 user says Thank You to kicr for this useful post

1. John Wesley Brett

[kicr Friend kicrJoin date: June 2007Posts: 84Downloads:30Uploads:10 Thanks: 13 Thanked: 6 times in 1 posts]

#642244

I got the same error and my database had duplicated titles in the #__k2_items table. This statement show you the duplicated entries:

SELECT COUNT(*) AS COUNT, title, id FROM j25_k2_items GROUP BY title HAVING COUNT(*) > 1

Then i edited each entry to make it unique. After that, the import ran successfully.

1 user says Thank You to kicr for this useful post

1. John Wesley Brett

[kicr Friend kicrJoin date: June 2007Posts: 84Downloads:30Uploads:10 Thanks: 13 Thanked: 6 times in 1 posts]

#740904

I got the same error and my database had duplicated titles in the #__k2_items table. This statement show you the duplicated entries:

SELECT COUNT(*) AS COUNT, title, id FROM j25_k2_items GROUP BY title HAVING COUNT(*) > 1

Then i edited each entry to make it unique. After that, the import ran successfully.

1 user says Thank You to kicr for this useful post

1. John Wesley Brett

[John Wesley Brett Moderator John Wesley BrettJoin date: July 2013Posts: 2142Downloads:17Uploads:26 Thanks: 175 Thanked: 645 times in 426 posts]

#575920

Thanks for this!

The duplicates apparently occurred, at least most of them, as a result of using FEEDGATOR.
User beware!
So before we use the K2 Migrator, all of the Feedgator duplicates needs to be fixed.

Brilliant Kicr!

John.

[John Wesley Brett Moderator John Wesley BrettJoin date: July 2013Posts: 2142Downloads:17Uploads:26 Thanks: 175 Thanked: 645 times in 426 posts]

#642249

Thanks for this!

The duplicates apparently occurred, at least most of them, as a result of using FEEDGATOR.
User beware!
So before we use the K2 Migrator, all of the Feedgator duplicates needs to be fixed.

Brilliant Kicr!

John.

[John Wesley Brett Moderator John Wesley BrettJoin date: July 2013Posts: 2142Downloads:17Uploads:26 Thanks: 175 Thanked: 645 times in 426 posts]

#740909

Thanks for this!

The duplicates apparently occurred, at least most of them, as a result of using FEEDGATOR.
User beware!
So before we use the K2 Migrator, all of the Feedgator duplicates needs to be fixed.

Brilliant Kicr!

John.

[Author]

Posts