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

XF 1.5 Server Errors

Discussion in 'Troubleshooting and Problems' started by Market1234, Jul 31, 2015.

  1. Market1234

    Market1234 Member

    Server Error
    Mysqli statement execute error : Deadlock found when trying to get lock; 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 XenForo/Model/Template.php at line 1642
    4. XenForo_Model_Template->compileAndInsertParsedTemplate() in XenForo/Model/Template.php at line 1378
    5. XenForo_Model_Template->compileTemplateInStyleTree() in XenForo/Model/Template.php at line 1328
    6. XenForo_Model_Template->compileNamedTemplateInStyleTree() in XenForo/DataWriter/Template.php at line 383
    7. XenForo_DataWriter_Template->_recompileTemplate() in XenForo/DataWriter/Template.php at line 364
    8. XenForo_DataWriter_Template->_postSave() in XenForo/DataWriter.php at line 1409
    9. XenForo_DataWriter->save() in XenForo/ControllerAdmin/Template.php at line 483
    10. XenForo_ControllerAdmin_Template->actionMergeOutdated() in XenForo/FrontController.php at line 347
    11. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    12. XenForo_FrontController->run() in /home/clubcens/public_html/admin.php at line 13
     
  2. Market1234

    Market1234 Member

    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Deadlock found when trying to get lock; try restarting transaction - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: Admin, 3 minutes ago
    Stack Trace
    #0 /home/clubcens/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /home/clubcens/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /home/clubcens/public_html/library/XenForo/Model/Template.php(1642): Zend_Db_Adapter_Abstract->query('\r\n\t\t\t\t\tINSERT I...')
    #3 /home/clubcens/public_html/library/XenForo/Model/Template.php(1378): XenForo_Model_Template->compileAndInsertParsedTemplate(1731, Array, 'sidebar_visitor...', 2)
    #4 /home/clubcens/public_html/library/XenForo/Model/Template.php(1328): XenForo_Model_Template->compileTemplateInStyleTree(Array)
    #5 /home/clubcens/public_html/library/XenForo/DataWriter/Template.php(383): XenForo_Model_Template->compileNamedTemplateInStyleTree('sidebar_visitor...', 2)
    #6 /home/clubcens/public_html/library/XenForo/DataWriter/Template.php(364): XenForo_DataWriter_Template->_recompileTemplate()
    #7 /home/clubcens/public_html/library/XenForo/DataWriter.php(1409): XenForo_DataWriter_Template->_postSave()
    #8 /home/clubcens/public_html/library/XenForo/ControllerAdmin/Template.php(483): XenForo_DataWriter->save()
    #9 /home/clubcens/public_html/library/XenForo/FrontController.php(347): XenForo_ControllerAdmin_Template->actionMergeOutdated()
    #10 /home/clubcens/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #11 /home/clubcens/public_html/admin.php(13): XenForo_FrontController->run()
    #12 {main}
    Request State
    array(3) {
    ["url"] => string(86) "ClubCensus.com - New Strip Club and Stripper Resource - Admin Control Panel Login | Admin CP - ClubCensus.com - New Strip Club and Stripper Resource"
    ["_GET"] => array(1) {
    ["templates/sidebar_visitor_panel_567/merge-outdated"] => string(0) ""
    }
    ["_POST"] => array(3) {
    ["merged"] => array(7) {
    [0] => string(371) "<xen:if is="{$visitor.user_id}">

    <div class="section visitorPanel">
    <div class="secondaryContent">

    <xen:avatar user="$visitor" size="m" img="true" />

    <div class="visitorText">
    <h2>{xen:phrase signed_in_as_x_sidebar, 'name={xen:helper username, $visitor, 'NoOverlay'}'}</h2>
    <div class="stats">
    <xen:hook name="sidebar_visitor_panel_stats">"
    [1] => string(1019) " <xen:if is="{$xenOptions.enableTrophies}">
    <dl class="pairsJustified"><dt>{xen:phrase points}:</dt> <dd>{xen:number $visitor.trophy_points}</dd></dl>
    </xen:if>

    <dl class="pairsJustified"><dt>{xen:if '{xen:property uix_visitorStatsIcons}', '<i class="uix_icon uix_icon-comment Tooltip" title="{xen:number $visitor.message_count} {xen:phrase messages}"></i>', '{xen:phrase messages}:'}</dt><dd>{xen:number $visitor.message_count}</dd></dl>
    <dl class="pairsJustified"><dt>{xen:if '{xen:property uix_visitorStatsIcons}', '<i class="uix_icon uix_icon-thumbsUp Tooltip" title="{xen:number $visitor.like_count} {xen:phrase likes}"></i>', '{xen:phrase likes}:'}</dt><dd>{xen:number $visitor.like_count}</dd></dl>
    <dl class="pairsJustified"><dt>{xen:if '{xen:property uix_visitorStatsIcons}', '<i class="uix_icon uix_icon-trophy Tooltip" title="{xen:number $visitor.trophy_points} {xen:phrase points}"></i>', '{xen:phrase points}:'}</dt><dd>{xen:number $visitor.trophy_points}</dd></dl>
    "
    [2] => string(144) " </div>
    </xen:hook>
    </div>

    </div>
    </div>

    <xen:else />

    <div class="section loginButton">
    <div class="secondaryContent">"
    [3] => string(372) " <label<xen:if is="{xen:property uix_loginTriggerStyle} == 0 && {xen:property uix_loginTriggerStyle} != 3"> for="LoginControl"</xen:if> id="SignupButton"><a href="{xen:link login}" class="inner{xen:if '{xen:property uix_loginTriggerStyle} == 3', ' OverlayTrigger'}">{xen:if $xenOptions.registrationSetup.enabled, {xen:phrase sign_up_now}, {xen:phrase log_in}}</a></label>"
    [4] => string(15) " </div>
    </div>"
    [5] => string(227) "
    <xen:if is="{xen:property uix_loginFormSidebar}">
    <div class="section uix_loginForm">
    <div class="secondaryContent">
    <h3>{xen:phrase log_in}</h3>
    <xen:include template="uix_loginForm" />
    </div>
    </div>
    </xen:if>"
    [6] => string(72) "
    </xen:if>

    <xen:include template="ad_sidebar_below_visitor_panel" />"
    }
    ["_xfConfirm"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    }
    }
     
  3. Mike

    Mike XenForo Developer Staff Member

    Try again. It sounds to me like there were multiple template merge processes running simultaneously.
     

Share This Page