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

XF 1.2 error in mysql syntax?

DarkGizmo

Active member
#1
I get this message in my Admin CP on a test board I did an upgrade on:
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT template.* FROM xf_template_map AS template_map INNER JOIN xf_tem' at line 1 - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Smokey, Today at 12:43 AM
Stack Trace
#0 /home/revillut/public_html/test_forum/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('????SELECT temp...')
#1 /home/revillut/public_html/test_forum/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '????SELECT temp...')
#2 /home/revillut/public_html/test_forum/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('????SELECT temp...')
#3 /home/revillut/public_html/test_forum/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('????SELECT temp...', Array, 2)
#4 /home/revillut/public_html/test_forum/library/TMS/Model/Template.php(232): XenForo_Model->fetchAllKeyed('????SELECT temp...', 'template_id', Array, '')
#5 /home/revillut/public_html/test_forum/library/XenForo/Model/Template.php(285): TMS_Model_Template->fetchAllKeyed('????SELECT DIST...', 'template_id')
#6 /home/revillut/public_html/test_forum/library/XenForo/Model/Template.php(1323): XenForo_Model_Template->getUniqueTemplatesByMapIds(Array)
#7 /home/revillut/public_html/test_forum/library/XenForo/DataWriter/Template.php(384): XenForo_Model_Template->compileMappedTemplatesInStyleTree(Array)
#8 /home/revillut/public_html/test_forum/library/XenForo/DataWriter/Template.php(364): XenForo_DataWriter_Template->_recompileTemplate()
#9 /home/revillut/public_html/test_forum/library/XenForo/DataWriter.php(1397): XenForo_DataWriter_Template->_postSave()
#10 /home/revillut/public_html/test_forum/library/XenForo/Model/Template.php(537): XenForo_DataWriter->save()
#11 /home/revillut/public_html/test_forum/library/XenForo/ControllerAdmin/Template.php(865): XenForo_Model_Template->autoMergeTemplate(Array, Object(XenForo_Diff3))
#12 /home/revillut/public_html/test_forum/library/XenForo/FrontController.php(337): XenForo_ControllerAdmin_Template->actionAutoMerge()
#13 /home/revillut/public_html/test_forum/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#14 /home/revillut/public_html/test_forum/admin.php(13): XenForo_FrontController->run()
#15 {main}
Request State
array(3) {
["url"] => string(58) "http://test.revillution.com/admin.php?templates/auto-merge"
["_GET"] => array(1) {
["templates/auto-merge"] => string(0) ""
}
["_POST"] => array(2) {
["_xfConfirm"] => string(1) "1"
["_xfToken"] => string(8) "********"
}
}
Can someone please tell me what this error means and how to fix it?