Deleting Duplicate Comments in SQL or Plugin

  • 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

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

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

    Thread Starter xbiboy

    (@xbiboy)

    what kind of sql query can I execute

    Thread Starter xbiboy

    (@xbiboy)

    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 ?

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    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.

    Thread Starter xbiboy

    (@xbiboy)

    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

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Deleting Duplicate Comments in SQL or Plugin’ is closed to new replies.