XF 1.3 Spam Cleaner Timing out

[Blot]

Hi there,

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?

 

[rdn]

Try to increase this on your my.cnf:

innodb_lock_wait_timeout