removing spam comments from mySQL db / Spam protection for WP 1.5?

  • zooph

    (@zooph)


    13 years, 4 months ago

    hi there.

    I regularly delete thousands of spam comments from my wordpress blog using the wp-admin page. Recently there are so many that i have used phpMyAdmin to flush them out in bulk.

    However, when i backup the mySQL database it appears that all those spam comment are still contained in the database file – why does this happen? And more importantly how can i delete them for good?

    I have a very bloated mSQL db file as a result – over 15Mb

    Secondly since im running such and old install any recommendations on spam filters? Askimet is not compatible with this version im using.

    thanks so much in advance,
    paul

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter zooph

    (@zooph)

    13 years, 4 months ago

    anyone?

    Rev. Voodoo

    (@rvoodoo)

    13 years, 4 months ago

    Nobody will have any advice on how to maintain such an old version of WP, nothing is compatible with it.

    You seriously need to upgrade. Your WP version is highly unstable/insecure.

    Mark Ratledge

    (@songdogtech)

    13 years, 4 months ago

    Upgrade. Seriously. Probably a bug in the old database structure that doesn’t fully delete spam comments.

    Try this as an SQL query in phpmyadmin:

    DELETE FROM wp_comments WHERE comment_approved = 'spam'

    but no guarantees and backup first.

    Thread Starter zooph

    (@zooph)

    13 years ago

    Rev. Voodoo, songdogtech.

    A belated thanks for your replies and advice. Since there is no way i will upgrade in the near future, do either of you, or anyone, know how to disable comments completely for every post on my site.

    songdogtech: At some point ill try that SQL query.

    Allthough Ive disabled comments for recent posts, I still receive hundreds of spam comments for all the old posts going back to 2004.

    hopefully there is a quick fix to prevent this from continuing and bloating my mSQL database.

    many thanks in advance!

    paul

    Thread Starter zooph

    (@zooph)

    12 years, 11 months ago

    Heh there,
    just bumping this in the hope that someone can help with the above issue.

    I want to disable comments on my blog and fully delete ‘deleted’ comments in my SQL db.

    All previous comments that Ive deleted are still added to the db file making it very huge. Also, allthough Ive disabled comments for new posts, there doesnt seemed to be a way of deleting the ability to add new comments to old posts,

    thus im still recieving a lot of spam!

    thanks,
    paul

    Thread Starter zooph

    (@zooph)

    12 years, 11 months ago

    just bumping this for a final time, anyone?

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘removing spam comments from mySQL db / Spam protection for WP 1.5?’ is closed to new replies.