• 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

#1
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
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) "********"
}
}
 

Mike

XenForo developer
Staff member
#3
Try again. It sounds to me like there were multiple template merge processes running simultaneously.