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 ?
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
(@xbiboy)
11 years, 11 months 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