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

what does this error indicate?

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

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

(when clicking 'save and exit')
0052.png

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
#4
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.
 
#5
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 :)