Merge Tags

[SoloInter]

My staff has created in the past (before the upgrade) a large number of tags and regularly several ways of writing the same thing. 

Example here with the tag "arsenal" and "arsenal fc" both designating the same thing, namely the name of the English football club Arsenal.

My question is the following : Can I, directly in phpMyAdmin, edit the tags that are not well written in order to unify everything ?

Concretely, I want to execute this query in this case:

UPDATE `ibf_core_tags` SET `tag_text` = 'arsenal fc' WHERE `ibf_core_tags`.`tag_text` = 'arsenal';

 

 

I know that it is not advisable to play with the database like that, but beyond any classic warnings, basically can I do that without upsetting the IC5 application?

[SoloInter]

Ok ok , nobody know, I will test and taste. 

[Marc]

Its not so much that nobody knows, but that its not something intended to do. We cant say "Yes that will work" without testing the concequences of an action really

[Daniel F]

I can certainly say it's not enough!

There's also the core_tags_cache and core_search_index_tags db table! And your action could also result in having the same tag more than once in the tag_cache_text column, e.g. when you have "Invision, IC5, IPS4, IC4" cached, and you replace Invision with IC4

[SoloInter]

Thanks for your feedback ^^

19 minutes ago, Daniel F said:

There's also the core_tags_cache and core_search_index_tags db table! And your action could also result in having the same tag more than once in the tag_cache_text column, e.g. when you have "Invision, IC5, IPS4, IC4" cached, and you replace Invision with IC4

The cache by definition can be emptied, right? Let's suppose that I empty this table (core_tags_cache) after executing the query? We won't be too bad? 😄

[Claudia999]

I'm currently managing our tags with this: https://www.ic-essentials.com/files/file/7-tags-manager/

I hope to be done with that before I upgrade to IC5. It's a lot. But it makes sense.

[SoloInter]

I have so many different tags for the same thing. Currently the only technique I have is to open the tag page, click on all the contents, delete the wrong tag, add the correct tag. Repeat. Repeat. Repeat ....

The temptation to run 2-3 queries to do everything is so strong.

[Claudia999]

1 hour ago, SoloInter said:

Repeat. Repeat. Repeat ....

I feel you. With the plugin above you can put all threads with the wrong tag easy to your best tag.

In your example you can type "arsenal" in plugin site in ACP and you see all other tags, "arsenal fc", "fc arsenal" and so on. One click, one typing of "arsenal" and all threads with "fc arsenal" are not more tagged with "fc arsenal" but with "arsenal".

[SoloInter]

Thank you for the compassion my friend. Indeed. This is what I should have done before upgrading. 

[SoloInter]

9 hours ago, Daniel F said:

I can certainly say it's not enough!

There's also the core_tags_cache and core_search_index_tags db table! And your action could also result in having the same tag more than once in the tag_cache_text column, e.g. when you have "Invision, IC5, IPS4, IC4" cached, and you replace Invision with IC4

core_tags_cache :

There is only 3 cols.

• CACHE KEY
• CACHE TEXT 
• CACHE DATE

So I just have update the tag in CACHE TEXT

 

core_search_index_tags :

There is only 3 cols. 

• ID of content who is linked
• TAG
• IS PREFIX

So I just have to do the same kind of query I did to core_tags table for TAG

 

But I find also :

core_tags_data where I will have to update by delete wrong tags and merge total tags in cms_records6 (because my database ID is 6)

 

With that I suppose it will works. 

I will have a try soon on the dev web site

[Matt]

A merge tags feature wouldn't be a bad idea for when people change their minds.

[SoloInter]

[G17 Media]

On 11/14/2024 at 11:15 AM, SoloInter said:

Thanks for your feedback ^^

The cache by definition can be emptied, right? Let's suppose that I empty this table (core_tags_cache) after executing the query? We won't be too bad? 😄

iirc; we had to build custom functionality for this; the caches will not be automatically rebuilt, but are necessary.

[SoloInter]

Thanks. I don’t plan to empty anything.

when I will take time to test I will just update. Hope in the meantime something official will be implemented. But I know how long it can take and I know me 🫣😂