what does this error indicate?


75% of the times i try to save a template i get this infernal error:

(when clicking 'save all changes')
(ironically it saves the template half the time despite this error)

(when clicking 'save and exit')

obviously i need to make some changes within the server environment, but im not sure what i should look at first.
any ideas?

Jake Bunce

XenForo moderator
Staff member
If you have root access to the server then you can edit the my.cnf file (usually at /etc/my.cnf) to increase the value of innodb_lock_wait_timeout. Increasing this limit should avoid that error.

Or as Brogan intimated, the number of styles might be causing it to hit the timeout. You can try removing some styles.


i do have root access!
i checked my.cnf and there is no innodb_lock_wait_timeout. i did find that restarting the mysql server allowed me to save the template, but the errors started again.
then i reduced the number of styles down to a total of 4 (from a total of 8) and that did stop the problem from reoccurring.
thanks for the help :)