XF 1.5 Daily Stats mysql error

Ludachris

Well-known member
Trying to run the Daily Stats for a XF 1.5 site - I'm a new admin so I don't know how long this error has been occurring. Posting the error log below... any ideas on what to try for a fix? Running XF 1.5.12, file health check comes back fine. It's running an an AWS server.

Server Error Log


Request State
Stack Trace
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 'grouping, stats_type, counter FROM xf_stats_daily WHERE stats_date BETWE' at line 1 - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Admin, 2 minutes ago
#0 /var/www/site.com/htdocs/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n\t\t\t\tSELECT sta...')
#1 /var/www/site.com/htdocs/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n\t\t\t\tSELECT sta...')
#2 /var/www/site.com/htdocs/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n\t\t\t\tSELECT sta...')
#3 /var/www/site.com/htdocs/library/Zend/Db/Adapter/Abstract.php(734): Zend_Db_Adapter_Abstract->query('\n\t\t\t\tSELECT sta...', Array)
#4 /var/www/site.com/htdocs/library/XenForo/Model/Stats.php(59): Zend_Db_Adapter_Abstract->fetchAll('\n\t\t\t\tSELECT sta...', Array)
#5 /var/www/site.com/htdocs/library/XenForo/ControllerAdmin/Stats.php(58): XenForo_Model_Stats->getStatsData(1573062520, 1575654520, Array, 'daily')
#6 /var/www/site.com/htdocs/library/XenForo/ControllerAdmin/Stats.php(112): XenForo_ControllerAdmin_Stats->getStatsData('daily', 1573062520)
#7 /var/www/site.com/htdocs/library/XenForo/FrontController.php(351): XenForo_ControllerAdmin_Stats->actionDaily()
#8 /var/www/site.com/htdocs/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /var/www/site.com/htdocs/admin.php(13): XenForo_FrontController->run()
#10 {main}
array(3) {
["url"] => string(53) "https://site.com/admin.php?stats/daily"
["_GET"] => array(1) {
["stats/daily"] => string(0) ""
}
["_POST"] => array(0) {
}
}
 
Top Bottom