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

Can't edit or revert a template

Discussion in 'Troubleshooting and Problems' started by GCSkye, Dec 17, 2010.

  1. GCSkye

    GCSkye Active Member

    I completely deleted everything under the message template and saved it. When I went to revert it, I got stuck with it loading. Eventually an error page displayed:

    Server Error

    Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
    1. [*]Zend_Db_Statement_Mysqli->_execute()inZend/Db/Statement.phpat line292
      [*]Zend_Db_Statement->execute()inZend/Db/Adapter/Abstract.phpat line479
      [*]Zend_Db_Adapter_Abstract->query()inZend/Db/Adapter/Abstract.phpat line661
      [*]Zend_Db_Adapter_Abstract->delete()inXenForo/DataWriter.phpat line1690
      [*]XenForo_DataWriter->_delete()inXenForo/DataWriter.phpat line1644
      [*]XenForo_DataWriter->delete()inXenForo/ControllerAdmin/Template.phpat line225
      [*]XenForo_ControllerAdmin_Template->actionDelete()inXenForo/FrontController.phpat line310
      [*]XenForo_FrontController->dispatch()inXenForo/FrontController.phpat line132
      [*]XenForo_FrontController->run()in/home/----/public_html/xf-skins/admin.phpat line13
    I've tried editing the template but also get stuck with it loading. All other templates on other skins, including the current style, seem to work just fine.
     
  2. Mike

    Mike XenForo Developer Staff Member

    It's probably worked itself out by now, but if it hasn't, can you try to run this MySQL query? (Using something like phpMyAdmin)

    SHOW FULL PROCESSLIST;
     
  3. GCSkye

    GCSkye Active Member

    Hey Mike,

    Hasn't worked itself out yet. Ran the command and got the following two tables:

    Id User Hostdb Command Time State Info
    1195634 ---- localhost database_name Sleep 22766 NULL
    1245438 ---- localhost database_name Query 0 NULL SHOW FULL PROCESSLIST
    Edit: I attempted to optimize the tables, it took about 5mins. After it was complete a few tables came up with the following msg_text Errors from these tables:
    database_table.xf_template | optimize | error | Lock wait timeout exceeded; try restarting transac...
    database_table.xf_template | optimize| status | Operation failed
    database_table.xf_template_compiled | optimize | Error | Lock wait timeout exceeded; try restarting transac...
    database_table.xf_template_compiled | optimize | error | Lock wait timeout exceeded; try restarting transac...
    database_table.xf_template_compiled | optimize | status | Operation failed
    database_table.xf_template_include | optimize | Error | Lock wait timeout exceeded; try restarting transac...
    database_table.xf_template_include| optimize | error | Lock wait timeout exceeded; try restarting transac...
    database_table.xf_template_include | optimize | status | Operation failed
    database_table.xf_template_map | optimize | Error | Lock wait timeout exceeded; try restarting transac...
    database_table.xf_template_map | optimize | error | Lock wait timeout exceeded; try restarting transac...
    database_table.xf_template_map | optimize | status | Operation failed
    database_table.xf_template_phrase | optimize | Error | Lock wait timeout exceeded; try restarting transac...
    database_table.xf_template_phrase | optimize | error | Lock wait timeout exceeded; try restarting transac...
    database_table.xf_template_phrase | optimize | status| Operation failed
    database_table.xf_thread | optimize | Error | Lock wait timeout exceeded; try restarting transac..
     
  4. Mike

    Mike XenForo Developer Staff Member

    Hi,

    Actually, can you try:

    SHOW FULL PROCESSLIST;

    and

    SHOW INNODB STATUS;

    It might be easier to attach the output as txt files for formatting reasons.

    There's no query that's running, but there's a connection that's been sitting there for a while. That must be holding on to a transaction.
     
  5. GCSkye

    GCSkye Active Member

    Hey Mike,

    I'll have to have the host run that, in the mean time maybe this will help? Its the XenForo Server Logs relating to the error:

    Error Info​


    Stack Trace​

    Code:
    #0 /home/skye/public_html/xf-skins/library/Zend/Db/Statement.php(292): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /home/skye/public_html/xf-skins/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /home/skye/public_html/xf-skins/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_temp...', Array)
    #3 /home/skye/public_html/xf-skins/library/XenForo/DataWriter.php(1516): Zend_Db_Adapter_Abstract->update('xf_template', Array, 'template_id = 1...')
    #4 /home/skye/public_html/xf-skins/library/XenForo/DataWriter.php(1485): XenForo_DataWriter->_update()
    #5 /home/skye/public_html/xf-skins/library/XenForo/DataWriter.php(1291): XenForo_DataWriter->_save()
    #6 /home/skye/public_html/xf-skins/library/XenForo/ControllerAdmin/Template.php(379): XenForo_DataWriter->save()
    #7 /home/skye/public_html/xf-skins/library/XenForo/FrontController.php(310): XenForo_ControllerAdmin_Template->actionSaveMultiple()
    #8 /home/skye/public_html/xf-skins/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #9 /home/skye/public_html/xf-skins/admin.php(13): XenForo_FrontController->run()
    #10 {main}

    Request State​

    PHP:
    Error Info
    Zend_Db_Statement_Mysqli_Exception
    Mysqli statement execute error Lock wait timeout exceeded; try restarting transaction library/Zend/Db/Statement/Mysqli.php:214
    Generated By
    SimbaFriday at 8:47 PM
    Stack Trace
    #0 /home/skye/public_html/xf-skins/library/Zend/Db/Statement.php(292): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /home/skye/public_html/xf-skins/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /home/skye/public_html/xf-skins/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_temp...', Array)
    #3 /home/skye/public_html/xf-skins/library/XenForo/DataWriter.php(1516): Zend_Db_Adapter_Abstract->update('xf_template', Array, 'template_id = 1...')
    #4 /home/skye/public_html/xf-skins/library/XenForo/DataWriter.php(1485): XenForo_DataWriter->_update()
    #5 /home/skye/public_html/xf-skins/library/XenForo/DataWriter.php(1291): XenForo_DataWriter->_save()
    #6 /home/skye/public_html/xf-skins/library/XenForo/ControllerAdmin/Template.php(379): XenForo_DataWriter->save()
    #7 /home/skye/public_html/xf-skins/library/XenForo/FrontController.php(310): XenForo_ControllerAdmin_Template->actionSaveMultiple()
    #8 /home/skye/public_html/xf-skins/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #9 /home/skye/public_html/xf-skins/admin.php(13): XenForo_FrontController->run()
    #10 {main}
    Request State
    array(3) {
      [
    "url"] => string(66"http://sleekvb.net/xf-skins/admin.php?templates/save-multiple.json"
      
    ["_GET"] => array(1) {
        [
    "templates/save-multiple_json"] => string(0""
      
    }
      [
    "_POST"] => array(12) {
        [
    "titleArray"] => array(2) {
          [
    1821] => string(7"message"
          
    [1591] => string(11"message.css"
        
    }
        [
    "styleidArray"] => array(2) {
          [
    1821] => string(2"10"
          
    [1591] => string(1"0"
        
    }
        [
    "templateArray"] => array(1) {
          [
    1821] => string(1512"<xen:require css="message.css" />
    <xen:require css="
    bb_code.css" />

    <li id="
    {$messageId}" class="message {xen:if $message.isDeleted'deleted'} {xen:if '{$message.is_admin} OR {$message.is_moderator}''staff'}" data-author="{$message.username}">

        <xen:include template="
    message_user_info">
            <xen:map from="
    $message" to="$user" />
        </xen:include>

        <div class="
    messageInfo primaryContent">
            <xen:if is="
    {$message.isNew}"><strong class="newIndicator"><span></span>{xen:phrase new}</strong></xen:if>

            <xen:if hascontent="
    true">
                <ul class="
    messageNotices">
                    <xen:contentcheck>
                        <xen:if is="
    {$message.isDeleted}">
                            <li class="
    deletedNotice">{xen:phrase this_message_has_been_removed_from_public_view}</li>
                        <xen:elseif is="
    {$message.isModerated}" />
                            <li class="
    moderatedNotice">{xen:phrase this_message_is_awaiting_moderator_approval_and_is_invisible_to_normal}</li>
                        </xen:if>
                    </xen:contentcheck>
                </ul>
            </xen:if>

            <div class="
    messageContent">
                <article><blockquote class="
    messageText ugc baseHtml">{xen:raw $message.messageHtml}</blockquote></article>

                {xen:raw 
    $messageContentAfterTemplate}
            </div>

            <xen:if is="
    {$visitor.content_show_signature} && {$message.signature}">
                <div class="
    baseHtml signature ugc"><aside>{xen:raw $message.signatureHtml}</aside></div>
            </xen:if>

            {xen:raw 
    $messageAfterTemplate}

            <div id="
    likes-{$messageId}"><xen:if is="{$message.likes}"><xen:include template="likes_summary" /></xen:if></div>
        </div>

    </li>"
        
    }
        [
    "addon_id"] => string(0""
        
    ["style_id"] => string(2"10"
        
    ["template_id"] => string(4"1821"
        
    ["title_original"] => string(7"message"
        
    ["_xfToken"] => string(53"1,1292618783,3c3f69b007731d8e489bcde829075d1b9245c667"
        
    ["includeTitles"] => array(10) {
          [
    0] => string(7"message"
          
    [1] => string(11"message.css"
          
    [2] => string(7"message"
          
    [3] => string(11"message.css"
          
    [4] => string(11"message.css"
          
    [5] => string(11"bb_code.css"
          
    [6] => string(17"message_user_info"
          
    [7] => string(21"message_user_info.css"
          
    [8] => string(13"likes_summary"
          
    [9] => string(17"likes_summary.css"
        
    }
        [
    "_TemplateEditorAjax"] => string(1"1"
        
    ["_xfNoRedirect"] => string(1"1"
        
    ["_xfResponseType"] => string(4"json"
      
    }
    }
     
  6. GCSkye

    GCSkye Active Member

    ===================================== 101229 20:0...

    I was told that was the output.

    I tried to revert the template today and was direct to these screens:

    First run attempt:
    Fatal error: Maximum execution time of 30 seconds exceeded in /home//public_html/xf-skins/library/XenForo/Template/Compiler.php on line 610

    Second Run attempt:
    Fatal error: Maximum execution time of 30 seconds exceeded in /home//public_html/xf-skins/library/XenForo/Template/Compiler/Statement/Abstract.php on line 7

    If you are unsure what is causing this or why it would start in the first place, I can just download the template and import it. I'm sure this would fix the problem but I'd hope the data supplied here helps.

    Edit: If I wait a day or so and go to edit the template, I can edit it. If I try to revert it, it gives the errors as mentioned. When attempting to edit after trying to revert, the same problems arrive as mentioned before.
     
  7. Mike

    Mike XenForo Developer Staff Member

    Unfortunately, who ever ran that didn't bother to get the full output (probably from phpMyAdmin). That's really not helpful.
     

Share This Page