1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.3 Spam Cleaner Timing out

Discussion in 'XenForo Questions and Support' started by Blot, Jun 19, 2014.

  1. Blot

    Blot Member

    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?
  2. RoldanLT

    RoldanLT Well-Known Member

    Try to increase this on your my.cnf:

Share This Page