Skip to:
Content
Pages
Categories
Search
Top
Bottom

how to delete spam comments from the database


  • SteveDrum
    Member

    @stevedrum

    hello. i just want to check something… before i go and do it and mess everything up.

    askimet has caughts loads of spam comments on my forum, which is great, but they are still in the database. i would like to remove them completely.

    i reckon that this is the correct entry, but does anyone know for sure?

    delete from bb_posts where post_status = '2';

Viewing 1 replies (of 1 total)

  • chrishajer
    Participant

    @chrishajer

    There was this:

    https://bbpress.org/forums/topic/permanently-deleting-topocs-and-posts

    If post_status 2 is a reply marked as spam, then that query would take care of it. But I think it could strand information in other tables that is related to that reply. I’m thinking specifically where the last reply is attributed to a topic or a user. Not sure what happens when you delete the reply that is referred to in another table.

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.