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
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) { } } |
