XF 1.5 Mysqli prepare error: Unknown column 'location' in 'field list' in ....

[snoopy5]

Hi,

I just upgraded from Xf1.5.15 to 1.5.16a. After successfull upgade, I can operate the admincp, but as soo as I go to the frontpage, I get a white scren with an error alert:


An exception occurred: Mysqli prepare error: Unknown column 'location' in 'field list' in /mypathto/library/Zend/Db/Statement/Mysqli.php on line 77

1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
4. Zend_Db_Adapter_Abstract->query() in Andy/UserAgent/Index.php at line 57
5. Andy_UserAgent_Index::getHtml() in XenForo/Template/Abstract.php at line 344
6. XenForo_Template_Abstract->callTemplateCallback() in XenForo/Template/Abstract.php(279) : eval()'d code at line 5180
7. eval() in XenForo/Template/Abstract.php at line 279
8. XenForo_Template_Abstract->_renderInternal() in XenForo/Template/Abstract.php at line 201
9. XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
10. XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 140
11. XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 662
12. XenForo_FrontController->renderView() in XenForo/FrontController.php at line 176
13. XenForo_FrontController->run() in /mypathto/index.php at line 13

In the admincp, I can see under error reports:

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'location' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generiert durch: admin, Vor 5 Minuten
Stapelverfolgung

#0 /mypathto/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n\t\t\t\tINSERT INT...')
#1 /mypathto/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n\t\t\t\tINSERT INT...')
#2 /mypathto/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n\t\t\t\tINSERT INT...')
#3 /mypathto/library/Andy/UserAgent/Index.php(57): Zend_Db_Adapter_Abstract->query('\n\t\t\t\tINSERT INT...', Array)
#4 /mypathto/library/XenForo/Template/Abstract.php(344): Andy_UserAgent_Index::getHtml('', Array, Object(XenForo_Template_Public))
#5/mypathto/library/XenForo/Template/Abstract.php(279) : eval()'d code(5180): XenForo_Template_Abstract->callTemplateCallback('Andy_UserAgent_...', 'getHtml', '', Array)
#6 /mypathto/library/XenForo/Template/Abstract.php(279): eval()
#7 /mypathto/library/XenForo/Template/Abstract.php(201): XenForo_Template_Abstract->_renderInternal('$__output = '';...', Array)
#8 /mypathto/library/XenForo/Template/Public.php(110): XenForo_Template_Abstract->render()
#9 /mypathto/library/XenForo/ViewRenderer/HtmlPublic.php(140): XenForo_Template_Public->render()
#10 /mypathto/library/XenForo/FrontController.php(662): XenForo_ViewRenderer_HtmlPublic->renderContainer('\n\t\n\n\n\n\n\n\t\n\n\n\n\t\n...', Array)
#11 /mypathto/library/XenForo/FrontController.php(176): XenForo_FrontController->renderView(Object(XenForo_ControllerResponse_View), Object(XenForo_ViewRenderer_HtmlPublic), Array)
#12 /mypathto/index.php(13): XenForo_FrontController->run()
#13 {main}

Benötigter Status

array(3) {
  ["url"] => string(23) "http://www.mywebsite.de/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

What could be the reason for this? File healthcheck is o.k.

 

[Mike]

That appears to be related to the "Andy_UserAgent" add-on.

 

[snoopy5]

That appears to be related to the "Andy_UserAgent" add-on.

Thanks. It was really that addon! I disabled it and now the site works again.