Keyword

Duplicate tags when importing Joomla content

More
4 years 4 weeks ago #177263 by Hedgy
I have an issue when importing joomla content to K2.
It seems for every tag it finds it creates a new tag, even if the tag already existed.
Because of this I'm getting a lot of duplicate tags. And going to the tag-url will only show one item.

Is there a way to solve this? I tried looking for a way to merge the tags but can't find one.

I tried reinstalling K2 to reimport the articles, but I get the same issue

K2 version: v2.10.3
Joomla version: 3.9.22

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

More
4 years 4 weeks ago - 4 years 4 weeks ago #177286 by JoomlaWorks
Replied by JoomlaWorks on topic Duplicate tags when importing Joomla content
The K2 importer merges both tags and meta keywords and converts them to K2 tags.

However I see we have a bug in the code that decides how these are filtered and converted to tags.

Please test the following if you can. Edit the file /administrator/components/com_k2/models/items.php and replace these lines github.com/getk2/k2/blob/master/administrator/components/com_k2/models/items.php#L1413-L1431 with this:
// Check if the tag exists already
$query = "SELECT id FROM #__k2_tags WHERE name=".$db->Quote($itemTag);
$db->setQuery($query);
$id = $db->loadResult();
if ($id) {
    $query = "INSERT INTO #__k2_tags_xref (`id`, `tagID`, `itemID`) VALUES (NULL, {$id}, {$K2Item->id})";
} else {
    $K2Tag = JTable::getInstance('K2Tag', 'Table');
    $K2Tag->name = $itemTag;
    $K2Tag->published = 1;
    $K2Tag->store();
    $tags[] = $K2Tag;
    $query = "INSERT INTO #__k2_tags_xref (`id`, `tagID`, `itemID`) VALUES (NULL, {$K2Tag->id}, {$K2Item->id})";
}
$db->setQuery($query);
$db->query();

This should filter the tags correctly before importing them.

Let me know.

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Last edit: 4 years 4 weeks ago by JoomlaWorks.

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

More
4 years 3 weeks ago #177325 by Hedgy
That fixed it! Thank you :)

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

More
4 years 3 weeks ago #177333 by JoomlaWorks
Replied by JoomlaWorks on topic Duplicate tags when importing Joomla content
Great, I'll merge the change for K2 v2.10.4.

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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


Powered by Kunena Forum