what does this error indicate?

lauren

Member
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
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.
 

lauren

Member
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 :)
 
Top