Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Options

After deleting spam account and topics, still have leftovers

So, basically I deleted some spam account and chose to delete their content but somehow, I still have this.
On the left it still shows 1.2k topics and the pagination still shows 41 pages. But it's empty.
What could be the problem ?

https://mmo4teen.com/forum/categories/offline-marketing

Comments

  • Options
    hgtonighthgtonight ∞ · New MVP

    You are looking at what is called "denormalized data". Most counts are stored in the system to prevent expensive queries from executing every page load.

    Please visit https://mmo4teen.com/forum/dba/counts while logged in as an admin.

    Search first

    Check out the Documentation! We are always looking for new content and pull requests.

    Click on insightful, awesome, and funny reactions to thank community volunteers for their valuable posts.

  • Options

    @hgtonight said:
    You are looking at what is called "denormalized data". Most counts are stored in the system to prevent expensive queries from executing every page load.

    Please visit https://mmo4teen.com/forum/dba/counts while logged in as an admin.

    Thanks a lot @hgtonight , it worked perfectly.

  • Options

    Oh, but they also left 9k tags behind, how can I delete em ?

  • Options
    hgtonighthgtonight ∞ · New MVP

    For that, I suggest my Refresh Counts plugin: http://vanillaforums.org/addon/refreshcounts-plugin

    Enable it and visit the tagging dashboard setting (/settings/tagging). Click the button and you should be good to go.

    Search first

    Check out the Documentation! We are always looking for new content and pull requests.

    Click on insightful, awesome, and funny reactions to thank community volunteers for their valuable posts.

  • Options

    @hgtonight said:
    For that, I suggest my Refresh Counts plugin: http://vanillaforums.org/addon/refreshcounts-plugin

    Enable it and visit the tagging dashboard setting (/settings/tagging). Click the button and you should be good to go.

    Actually I mean the tag itself, manually deleting them is not really good.

  • Options
    hgtonighthgtonight ∞ · New MVP

    @Gogito said:
    Actually I mean the tag itself, manually deleting them is not really good.

    Did you click on the refresh counts button on the tagging page? That should delete orphan tags.

    Search first

    Check out the Documentation! We are always looking for new content and pull requests.

    Click on insightful, awesome, and funny reactions to thank community volunteers for their valuable posts.

  • Options

    You might as well want to use them twos (Anti-Spam and Stop Forum Spam) on your forum for future purpose.

Sign In or Register to comment.