1. 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?

Discussion in 'Troubleshooting and Problems' started by lauren, Jun 7, 2011.

  1. lauren

    lauren Member

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

    Brogan XenForo Moderator Staff Member

    How many styles do you have installed?
    lauren likes this.
  3. lauren

    lauren Member

    there are 7 child styles of the default.
  4. Jake Bunce

    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 likes this.
  5. lauren

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

Share This Page