Hello,
the following error starts to appear on my server error log:
the following error starts to appear on my server error log:
Code:
Server Error Log
Error Info
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 ')) AND (u.user_group_id NOT IN (1)) AND (NOT FIND_IN_SET(1, u.secondary_group_id' at line 13 - library\Zend\Db\Statement\Mysqli.php:77
Generated By: SirJoki80, Today at 08:55
Stack Trace
#0 C:\inetpub\wwwroot\domain.com\library\Zend\Db\Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\r\n S...')
#1 C:\inetpub\wwwroot\domain.com\library\Zend\Db\Adapter\Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\r\n S...')
#2 C:\inetpub\wwwroot\domain.com\library\Zend\Db\Adapter\Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\r\n S...')
#3 C:\inetpub\wwwroot\domain.com\library\XenForo\Model.php(219): Zend_Db_Adapter_Abstract->query('\r\n S...', Array, 2)
#4 C:\inetpub\wwwroot\domain.com\library\XFA\MembersMap\Model\Location.php(63): XenForo_Model->fetchAllKeyed('\r\n S...', 'location_id')
#5 C:\inetpub\wwwroot\domain.com\library\XFA\MembersMap\ControllerPublic\Map.php(85): XFA_MembersMap_Model_Location->getAllLocations(Array, Array)
#6 C:\inetpub\wwwroot\domain.com\library\XenForo\FrontController.php(351): XFA_MembersMap_ControllerPublic_Map->actionIndex()
#7 C:\inetpub\wwwroot\domain.com\library\XenForo\FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#8 C:\inetpub\wwwroot\domain.com\index.php(13): XenForo_FrontController->run()
#9 {main}
Request State
array(3) {
["url"] => string(89) "https://domain.com/members-map/?region=all&view=following&usergroup=all"
["_GET"] => array(3) {
["region"] => string(3) "all"
["view"] => string(9) "following"
["usergroup"] => string(3) "all"
}
["_POST"] => array(0) {
}
}
