WordPress.org

Ready to get started?Download WordPress

Forums

Deleting Duplicate Comments in SQL or Plugin (6 posts)

  1. xbiboy
    Member
    Posted 2 years ago #

    hi, we had this issue where some of our post had duplicated comments not sure if it was an error but our comments went upto 100k and some of them are duplicated is there a way to delete the duplicate comments using a plugin or running a sql query thanks

  2. You could probably do an SQL query, but you'd have to know exactly what comments to delete. 100k? Wow.

  3. xbiboy
    Member
    Posted 2 years ago #

    what kind of sql query can I execute

  4. xbiboy
    Member
    Posted 2 years ago #

    this image shows whats happening on the comment, when I deleted all the comments in the database it's still coming back and generates it where do I check this ?

  5. If you delete them via WP or the DB and they're coming back then you have three options.

    1) Bad theme
    2) Bad plugin
    3) Bad user

    Turn on Akismet for starters.

  6. xbiboy
    Member
    Posted 2 years ago #

    yes , I think it's the plugins SEO Facebook Comment is causing it because it generates the comments that are coming from facebook it will loop until finds the comments and store it in the wordpress database , I think it made some infinite loop or something that cause it 100k comments, I just emptied our wp_comments table and disabled the plugin and it worked our fine :) and basically I used the basic facebook comment code and it on the theme,

    SEO Facebook comment is quite good because it stores it on the database and converts it into a wordpress comment

    will contact the developer to report the bug

Topic Closed

This topic has been closed to new replies.

About this Topic