Posted September 11, 20177 yr 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.
September 11, 20177 yr 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.
September 11, 20177 yr Author 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?
September 12, 20177 yr Author @Ryan H. I've just found where I reindex the search. Still need advice where/how I recache the tags.
September 12, 20177 yr 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.
September 13, 20177 yr 31 minutes ago, DSystem said: Hello! What is it? "AT&P, under Advanced Tools" Advanced Tags & Prefixes app.
Archived
This topic is now archived and is closed to further replies.