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

XF 1.2 Any idea what is causing this server error? Unknown column 'post.ip_id' in 'on clause'

Stuart Wright

Well-known member
#1
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'post.ip_id' in 'on clause' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Stuart Wright, A moment ago
Stack Trace
#0 /home/sites/xf.avforums.com/public_html/sandbox/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('????SELECT COUN...')
#1 /home/sites/xf.avforums.com/public_html/sandbox/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '????SELECT COUN...')
#2 /home/sites/xf.avforums.com/public_html/sandbox/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('????SELECT COUN...')
#3 /home/sites/xf.avforums.com/public_html/sandbox/library/Zend/Db/Adapter/Abstract.php(825): Zend_Db_Adapter_Abstract->query('????SELECT COUN...', Array)
#4 /home/sites/xf.avforums.com/public_html/sandbox/library/XenForo/Model/Thread.php(574): Zend_Db_Adapter_Abstract->fetchOne('????SELECT COUN...')
#5 /home/sites/xf.avforums.com/public_html/sandbox/library/XenForo/Model/Thread.php(637): XenForo_Model_Thread->countThreads(Array)
#6 /home/sites/xf.avforums.com/public_html/sandbox/library/XenForo/ControllerPublic/Forum.php(119): XenForo_Model_Thread->countThreadsInForum(82, Array)
#7 /home/sites/xf.avforums.com/public_html/sandbox/library/AVForums/AgeRestrictions/ControllerPublic/Forum.php(7): XenForo_ControllerPublic_Forum->actionForum()
#8 /home/sites/xf.avforums.com/public_html/sandbox/library/ModEss/ControllerPublic/Forum.php(22): AVForums_AgeRestrictions_ControllerPublic_Forum->actionForum()
#9 /home/sites/xf.avforums.com/public_html/sandbox/library/AVForums/CreateThreadText/ControllerPublic/Forum.php(7): ModEss_ControllerPublic_Forum->actionForum()
#10 /home/sites/xf.avforums.com/public_html/sandbox/library/AVForums/LimitThreads/ControllerPublic/Forum.php(7): AVForums_CreateThreadText_ControllerPublic_Forum->actionForum()
#11 /home/sites/xf.avforums.com/public_html/sandbox/library/AVForums/ModCheckpoint/ControllerPublic/Forum.php(14): AVForums_LimitThreads_ControllerPublic_Forum->actionForum()
#12 /home/sites/xf.avforums.com/public_html/sandbox/library/XenForo/FrontController.php(337): AVForums_ModCheckpoint_ControllerPublic_Forum->actionForum()
#13 /home/sites/xf.avforums.com/public_html/sandbox/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#14 /home/sites/xf.avforums.com/public_html/sandbox/index.php(13): XenForo_FrontController->run()
#15 {main}
Request State
array(3) {
["url"] => string(52) "http://xf.avforums.com/sandbox/forums/plasma-tvs.82/"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}
I realise it could be one of the 40+ addons we have. Any idea where to start looking?
Thanks
 

Brogan

XenForo moderator
Staff member
#2
I see a few add-ons listed in the trace:

AVForums/AgeRestrictions
ModEss
AVForums/CreateThreadText
AVForums/LimitThreads
AVForums/ModCheckpoint