XF 2.0 Statistics not updating

[Kangy]

I've noticed that since 10/25 none of my business statistics are updating. We're getting more traffic and activity but everything shows zero. I try to run the update daily stats and get this error.

XF\Db\Exception: MySQL query error [1406]: Data too long for column 'stats_type' at row 1 in src/XF/Db/AbstractStatement.php at line 212
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 174
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 69
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 69
XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 144
XF\Db\AbstractAdapter->insert() in src/XF/Repository/Stats.php at line 72
XF\Repository\Stats->build() in src/XF/Job/Stats.php at line 43
XF\Job\Stats->run() in src/XF/Job/Manager.php at line 241
XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 187
XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 103
XF\Job\Manager->runByIds() in src/XF/Admin/Controller/Tools.php at line 120
XF\Admin\Controller\Tools->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 249
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 87
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1844
XF\App->run() in src/XF.php at line 328
XF::runApp() in admin.php at line 13

The one recent plugin around that time I added is the Reactions?

 

[Kangy]

It actually looks like non of the chron jobs are running.

 

[Chris D]

I've noticed that since 10/25 none of my business statistics are updating. We're getting more traffic and activity but everything shows zero. I try to run the update daily stats and get this error.

XF\Db\Exception: MySQL query error [1406]: Data too long for column 'stats_type' at row 1 in src/XF/Db/AbstractStatement.php at line 212
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 174
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 69
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 69
XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 144
XF\Db\AbstractAdapter->insert() in src/XF/Repository/Stats.php at line 72
XF\Repository\Stats->build() in src/XF/Job/Stats.php at line 43
XF\Job\Stats->run() in src/XF/Job/Manager.php at line 241
XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 187
XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 103
XF\Job\Manager->runByIds() in src/XF/Admin/Controller/Tools.php at line 120
XF\Admin\Controller\Tools->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 249
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 87
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1844
XF\App->run() in src/XF.php at line 328
XF::runApp() in admin.php at line 13

The one recent plugin around that time I added is the Reactions?

Nothing within XF itself would cause this so in the first instance try and disable all add-ons (even ones you've had for a while) and see if that allows the stat building to go through.

If it does, re-enable each add-on and try and run the stats build again until the issue happens again, then report the issue to the authors of that add-on.