Mass deletion of recent blog posts

[Chimpie]

It appears that about a week ago my blog section of my site got slammed with spammers, creating over 19,363 entries between Jan 12, 2014 and today.

Is there a way to mass delete these posts, either through the AdminCP or through the database itself?

Thanks,

Chimpie

[Lats]

Try this query...

DELETE FROM
 blog
WHERE
 dateline > '1389509567'

To fine tune the dateline value, use an online converter such as http://www.epochconverter.com/

[Chimpie]

I tried this, but it said it can't find the database. Would it matter if the forums where in the /forums directory?

EDIT: Okay, I tried something different and got this:

mport.php: Missing parameter: import_type
import.php: Missing parameter: format

[Wayne Luke]

Content of all blogs? Easiest way would be to uninstall the Blog product, delete blog_* tables from your database and then reinstall the blog product.

Only some of the entries.... It gets a lot more complicated.

If you have a relatively recent database backup from before the attack, I would use it to restore the blog tables.

[Chimpie]

Thanks for jumping in Wayne. Good to see that you're still here. I haven't had to log in for awhile.

The only entries that need to be deleted are from January 12, 2014 till now. Everything before that date is fine.

[Lats]

If you running the query within the admincp, try removing the vertical spacing.

[Chimpie]

I was running it through my phpAdmin. Would going through AdminCP yield better results? And help me out since I haven't had to mess with the site for a few years.. Where do I go to do this? Thanks

[Wayne Luke]

Just deleting from the blog table won't actually delete the entries and can cause irreparable damage to your database.
You can try running these queries after making a database backup.

truncate blog_textparsed;
delete from blog_text where dateline > '1389509567'
delete from blog where dateline > '1389509567'

Could still be remnants of these entries after this though.