Hello,

Due to the massive number of users not using the tag system properly, we decided to disable it, but keeping the prefix system enabled, as we use prefixes in a few forums. We were able to configure this behavior correctly using the Advanced Tags & Prefixes app.

Now we want to delete all tags already set (but preserving prefixes), and I thought an easy way to do that would be running an SQL query. I spent an hour going through IPS database structure, but couldn't find where the relationship between topic IDs and tag IDs is stored.

Any advice would be extremely helpful.

@Ryan H.?

Thanks.

core_tags having tag_prefix=0. Topic ID is tag_meta_id where tag_meta_app=forums. Once you clean that up, you'll have to recache tags to fix core_tags_cache, then reindex search to fix core_search_index_tags.

Have fun.

6 minutes ago, Ryan H. said:

Once you clean that up, you'll have to recache tags to fix core_tags_cache, then reindex search to fix core_search_index_tags.

And how do I do that?

@Ryan H. I've just found where I reindex the search. Still need advice where/how I recache the tags.

14 hours ago, Gabriel Torres said:

@Ryan H. I've just found where I reindex the search. Still need advice where/how I recache the tags.

AT&P, under Advanced Tools. Not part of IPS core.

Excellent @Ryan H. you helped me a lot.

@Ryan H. Worked like a charm. You are the best!

Hello!

What is it?

"AT&P, under Advanced Tools"

31 minutes ago, DSystem said:

Hello!

What is it?

"AT&P, under Advanced Tools"

Advanced Tags & Prefixes app.