Long status_type

[abdfahim]

A 3rd atempt is necessary I guess

XF\Db\Exception: MySQL query error [1406]: Data too long for column 'stats_type' at row 1 src/XF/Db/AbstractStatement.php:212
Generated by: Unknown account Jan 19, 2018 at 11:30 AM

Stack trace
INSERT INTO `xf_stats_daily` (`stats_date`, `stats_type`, `counter`) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE counter = 2
------------

#0 src/XF/Db/Mysqli/Statement.php(174): XF\Db\AbstractStatement->getException('MySQL query err...', 1406, '22001')
#1 src/XF/Db/Mysqli/Statement.php(69): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1406, '22001')
#2 src/XF/Db/AbstractAdapter.php(74): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(150): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#4 src/XF/Repository/Stats.php(72): XF\Db\AbstractAdapter->insert('xf_stats_daily', Array, false, 'counter = 2')
#5 src/XF/Cron/Counters.php(30): XF\Repository\Stats->build(1516233600, 1516320000)
#6 [internal function]: XF\Cron\Counters::recordDailyStats(Object(XF\Entity\CronEntry))
#7 src/XF/Job/Cron.php(35): call_user_func(Array, Object(XF\Entity\CronEntry))
#8 src/XF/Job/Manager.php(241): XF\Job\Cron->run(8)
#9 src/XF/Job/Manager.php(187): XF\Job\Manager->runJobInternal(Array, 8)
#10 src/XF/Job/Manager.php(76): XF\Job\Manager->runJobEntry(Array, 8)
#11 job.php(15): XF\Job\Manager->runQueue(false, 8)
#12 {main}

Click to shrink...

 

[Xon]

Please install the attached mini-addon and then under Tools => Cron Entries, and run "Record daily statistics".

This should then report the contents of stats_type which is failing.

 

[abdfahim]

Exception: sv_contentratings_profile_post_comment_0 length > 25 in src/addons/SV/StatsErrorReport/XF/Repository/Stats.php at line 27

1. SV\StatsErrorReport\XF\Repository\Stats->build() in src/XF/Cron/Counters.php at line 30
2. XF\Cron\Counters::recordDailyStats()
3. call_user_func() in src/XF/Admin/Controller/CronEntry.php at line 112
4. XF\Admin\Controller\CronEntry->actionRun() in src/XF/Mvc/Dispatcher.php at line 249
5. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
6. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
7. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1880
8. XF\App->run() in src/XF.php at line 328
9. XF::runApp() in admin.php at line 13

 

[Xon]

@abdfahim upgrading to the latest 0.14.x version should fix that. That I'll be releasing in a day or so.