How to transfer tags from k2 to main content in Joomla?

Question

Joomla

I moved posts and categories from k2 to the main content using this example:

INSERT INTO `yourDBname`.`dbprefix_content` (`id`, `title`, `alias`, `catid`, `introtext`, `fulltext`, `created `, `created_by`, `created_by_alias`, `checked_out`, `checked_out_time`, `modified`, `modified_by`, `publish_up`, `publish_down`, `access`, `featured`, `hits`, `language`) SELECT `id`, `title`, `alias`, `catid`, `introtext`, `fulltext`, `created`, `created_by`, `created_by_alias`, `checked_out`, `checked_out_time`, `modified`, ` modified_by`, `publish_up`, `publish_down`, `access`, `featured`, `hits`, `language` FROM `

yourDBname`.`dbprefix_k2_items`

Answer 1

You cannot drag tags by such simple copying of columns from one table to another. In K2, tags are stored in the k2_tags column of the dbprefix_k2_items table, but in the native Joomla component, tags are (sort of) stored in a separate dbprefix_contentitem_tag_map table. How specifically to carry out the transfer manually, I can not tell. Compare the data structure in these two tables, maybe you can write some tricky SQL query to transfer them.
By the way, there is a plugin for migrating data from K2 to com_content. Unfortunately, it's paid, but it can transfer tags too.