Our forums were left unattended for a while and we have numerous spam members and a couple with 3000+ posts.
I was able to batch delete the spam accounts, but is there anyway that I can remove the posts? I tried the spam cleaner, but it times out with:
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction - library/Zend/Db/Statement/Mysqli.php:214
Any suggestions on how I can remove those posts?