Hello, sorry to reopen this thread but I get exactly the same error
I changed
class plgK2Sjk2filter extends K2Plugin {
to
class __construct extends K2Plugin {
into plugins/k2/sjk2filter/sjk2filter.php file.
I changed
SELECT xref.tagID, #__k2_items.id, #__k2_items.language
FROM #__k2_items
JOIN #__k2_tags_xref AS xref ON #__k2_items.id = xref.itemID"
.$whereItem
to
SELECT xref.tagID, #__k2_items.id, #__k2_items.language
FROM #__k2_items
JOIN #__k2_tags_xref AS xref ON #__k2_items.id = xref.itemID"
.$whereItem
.' GROUP BY CONCAT(xref.tagID, #__k2_items.id)'
into components/sjk2filters/helpers/helper.php file as suggested into
www.joomlart.com/forums/topic/index-update-throws-a-1062-error/
I get this error when I click on "update indexing":
1062 Duplicate entry '13-0-xfield-Antonio Barile (n. 1948) pittore: fisarmonica, Nicol' for key 'asset_idx'
I'm using the latest K2 version (2.10.2) on J! 3.9.18
Thanks