Thread

Hello, I’ve started working on an EE1.6.4 site that has 150,000 closed comments (spam) in “Comments Awaiting Validation” in the CP home.

I’m familiar with phpmyadmin from other CMSs. Is there an SQL query I can run to delete all those closed spam comments?

There may be a few “good” comments that are closed, but they will be too old to be useful anyway.

Thanks, Mark

Off the top of my head I’m a bit rusty on EE 1.x. But if you look under Admin and then Utilities (?) you can do your SQL from within the EE CP. There’s also a link to show the tables and from there the fields. You probably don’t need phpMyAdmin.

And to answer your question, yes there is a SQL statement. I just don’t know it off the top of my head :(

Thanks, I found some help at Stack Overflow. Run

DELETE FROM exp_comments WHERE status = ‘c’

in phpmyadmin or within admin where you can run queries. That will delete all closed comments. Backup the DB before you run it.

How about starting with

SELECT * FROM exp_comments WHERE status = ‘c’?

or

SELECT * FROM exp_comments WHERE status = ‘c’ AND entry_id > #?

Most of the times I’ve done mass deletes they are after a certain row. If you add that to your where you’re less likely to break something 😊