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

XF 1.1 Template modifying problem

Discussion in 'Troubleshooting and Problems' started by CyberAP, May 2, 2012.

  1. CyberAP

    CyberAP Well-Known Member

    I have 13 styles on my forum. XenForo seems working relatively fast, I used to delete templates or edit them with no problem at all. But in last 5 or 6 months I keep getting errors. If I try to edit or to revert some of the default templates (like 'message' or 'likes_summary') I get an error that server didn't respond in time. On the 3rd or 4th take it saves all the changes, but this doesn't work with deletion.
    Is there any way of fixing this? Is that procedure of deleting default template such resource consuming?
  2. Brogan

    Brogan XenForo Moderator Staff Member

    This is a known problem due to the templates being rebuilt.

    The only solution currently is to reduce the number of styles.
  3. CyberAP

    CyberAP Well-Known Member

    Will there be any fixes in the future versions?
  4. CyberAP

    CyberAP Well-Known Member

    Unfortunately safe rebuild didn't help.

    I get this error:

    Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
    1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    3. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 661
    4. Zend_Db_Adapter_Abstract->delete() in XenForo/DataWriter.php at line 1784
    5. XenForo_DataWriter->_delete() in XenForo/DataWriter.php at line 1737
    6. XenForo_DataWriter->delete() in XenForo/ControllerAdmin/Template.php at line 187
    7. XenForo_ControllerAdmin_Template->actionDelete() in XenForo/FrontController.php at line 310
    8. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
    9. XenForo_FrontController->run() in admin.php at line 13
  5. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    That's a server limit.

    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 that limit should avoid this error. If you don't have root access then you need to ask your host or server person to do this.

    For reference:
    CyberAP likes this.
  6. guiltar

    guiltar Well-Known Member

    Safe rebuild doesn't change after deletion behaviour, it only changes complete template rebuilding.
    Edit: I thought the problem was in rebuilding (same to what I had). Sorry.
    CyberAP likes this.
  7. CyberAP

    CyberAP Well-Known Member

    Thanks for that tip, but I use shared hosting.
  8. guiltar

    guiltar Well-Known Member

    Partial inline rebuilding (in background) could be implemented.
  9. CyberAP

    CyberAP Well-Known Member

    Is it hard to do?
  10. guiltar

    guiltar Well-Known Member

    Not hard but solid amount of code. It changes current logic.
    Now when you delete template, you find dependent templates and recompile them in one request.
    Partial rebuild should first find dependant templates, mark them as needed to rebuild, then run multi-request rebuild in background.

Share This Page