Data at Your Fingertips: Explore Our New Reporting and Statistical Capabilities By Ryan Ashbrook Tuesday at 01:29 PM
Gabriel Torres Posted September 11, 2017 Share Posted September 11, 2017 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. Link to comment Share on other sites More sharing options...
Ryan H. Posted September 11, 2017 Share Posted September 11, 2017 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. Link to comment Share on other sites More sharing options...
Gabriel Torres Posted September 11, 2017 Author Share Posted September 11, 2017 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? Link to comment Share on other sites More sharing options...
Gabriel Torres Posted September 12, 2017 Author Share Posted September 12, 2017 @Ryan H. I've just found where I reindex the search. Still need advice where/how I recache the tags. Link to comment Share on other sites More sharing options...
Ryan H. Posted September 12, 2017 Share Posted September 12, 2017 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. Link to comment Share on other sites More sharing options...
Gabriel Torres Posted September 12, 2017 Author Share Posted September 12, 2017 Excellent @Ryan H. you helped me a lot. Link to comment Share on other sites More sharing options...
Gabriel Torres Posted September 13, 2017 Author Share Posted September 13, 2017 @Ryan H. Worked like a charm. You are the best! Link to comment Share on other sites More sharing options...
DSystem Posted September 13, 2017 Share Posted September 13, 2017 Hello! What is it? "AT&P, under Advanced Tools" Link to comment Share on other sites More sharing options...
Adriano Faria Posted September 13, 2017 Share Posted September 13, 2017 31 minutes ago, DSystem said: Hello! What is it? "AT&P, under Advanced Tools" Advanced Tags & Prefixes app. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.