I'm testing my forum and with a test user I created a topic to see if everything worked. Then I deleted the user and all its content but the topic tag still shows up. When I click on it, I can't find any topic with that tag. How can I remove this? I deleted all forum caches, updated topic, forum and user statistics but the empty tag is still there. Any help is appreciated 🙂
Hi @jasonjase,
Have you deleted all caches before checking?
If not, please navigate to Dashboard > Forums > Dashboard admin page, click on [Delete all caches] button. If you use some other cache plugins delete those plugins caches as well and check again.
Use some SQL executing tool. Some plugin or the phpMyAdmin of your Hosting cPanel and execute this SQL query. Don't forget backup the wp_wpforo_tags table. And change the wp_ prefix with your database table prefix:
DELETE FROM `wp_wpforo_tags`
WHERE NOT EXISTS (
SELECT `wp_wpforo_topics`.`topicid`
FROM `wp_wpforo_topics`
WHERE `wp_wpforo_topics`.`tags` IN( `wp_wpforo_tags`.`tag` )
)