• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 2.0 MySQL query error [1406]: Data too long for column 'stats_type' at row 1

#1
Server error log

  • 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
  • Dec 3, 2017 at 7:45 PM
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(70): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1406, '22001')
#2 src/XF/Db/AbstractAdapter.php(69): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(146): XF\Db\AbstractAdapter->query('INSERT INTO xf...', 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(1512259200, 1512345600)
#6 [internal function]: XF\Cron\Counters::recordDailyStats(Object(XF\Entity\CronEntry))
#7 src/XF/Job/Cron.php(36): call_user_func(Array, Object(XF\Entity\CronEntry))
#8 src/XF/Job/Manager.php(241): XF\Job\Cron->run(7.9999978542328)
#9 src/XF/Job/Manager.php(187): XF\Job\Manager->runJobInternal(Array, 7.9999978542328)
#10 src/XF/Job/Manager.php(76): XF\Job\Manager->runJobEntry(Array, 7.9999978542328)
#11 job.php(15): XF\Job\Manager->runQueue(false, 8)
#12 {main}


Is this something to be worried about?
 

Mike

XenForo developer
Staff member
#3
I believe the only other time we've seen this has been add-on related. You may need to disable add-ons to identify which is causing it specifically.