WordPress.org

Ready to get started?Download WordPress

Forums

Query to Delete Duplicate Comments? (2 posts)

  1. rhythmdoctor
    Member
    Posted 3 years ago #

    I had an issue with Disqus whereby it created duplicate comments on many posts, sometimes 4 duplicates of the same comment. I've been going through to try and manually remove these but we have more than 10K comments total and unfortunately, this happened haphazardly whereby it only happened to some of the posts. So...

    does anyone know of a mysql query whereby I could detect and delete duplicate comments by searching for entries that match in terms of the comment itself or the author? The comment IDs are not duplicate (it created new comment IDs for each) so Im not sure how to do this in mysql (plus Im not very good at it :-)... Any help would be greatly appreciated. Thank you.

  2. patrickhealy
    Member
    Posted 2 years ago #

    I had the same thing happen with Livefyre. Annoying. If you find out how to get rid of the dupes, please let me know.

Topic Closed

This topic has been closed to new replies.

About this Topic