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

XF 1.5 What is this Server Error Log?

Huskermax

Active member
#1
I am getting this error. I have no idea if this is bad or something to worry about.

Code:
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Data too long for column 'stats_type' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, Jul 23, 2016
Stack Trace

#0 /home/hmforum/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/hmforum/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/hmforum/public_html/library/XenForo/Model/Stats.php(353): Zend_Db_Adapter_Abstract->query('\n\t\t\t\t\t\tINSERT I...')
#3 /home/hmforum/public_html/library/XenForo/CronEntry/Counters.php(26): XenForo_Model_Stats->buildStatsData(1469232000, 1469318400)
#4 [internal function]: XenForo_CronEntry_Counters::recordDailyStats(Array)
#5 /home/hmforum/public_html/library/XenForo/Model/Cron.php(357): call_user_func(Array, Array)
#6 /home/hmforum/public_html/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#7 /home/hmforum/public_html/library/XenForo/Model/Deferred.php(295): XenForo_Deferred_Cron->execute(Array, Array, 7.99999690056, '')
#8 /home/hmforum/public_html/library/XenForo/Model/Deferred.php(429): XenForo_Model_Deferred->runDeferred(Array, 7.99999690056, '', false)
#9 /home/hmforum/public_html/library/XenForo/Model/Deferred.php(374): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#10 /home/hmforum/public_html/deferred.php(23): XenForo_Model_Deferred->run(false)
#11 {main}

Request State

array(3) {
  ["url"] => string(39) "http://forum.huskermax.com/deferred.php"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(3) {
    ["_xfRequestUri"] => string(31) "/index.php?forums/recruiting.3/"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}
 

Huskermax

Active member
#3
Not using the daily stats add-on.

I have:

Article system
Auto Lock
resource Manager - Date Change
rss feeds by waindigo
s9e media pack
XenForo Resource Manager
[AD] Monetize Pro
 

Brogan

XenForo moderator
Staff member
#4
Other than the RM, do any of those add any new stats?

Something is trying to insert a record into the stats table, with a type longer than 25 characters.

Can you run this query in phpMyAdmin and show the full text output?
Code:
SHOW CREATE TABLE xf_stats_daily
 

Huskermax

Active member
#5
Other than the RM, do any of those add any new stats?

Something is trying to insert a record into the stats table, with a type longer than 25 characters.

Can you run this query in phpMyAdmin and show the full text output?
Code:
SHOW CREATE TABLE xf_stats_daily
Code:
CREATE TABLE `xf_stats_daily` (
`stats_date` int(10) unsigned NOT NULL,
`stats_type` varbinary(25) NOT NULL,
`counter` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`stats_date`,`stats_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
Is this what you are looking for?
 

Brogan

XenForo moderator
Staff member
#6
What about the stats - do any of the add-ons add custom stats to the table?

It should look like this for XF and the RM:
upload_2016-8-1_13-47-51.png
 

Huskermax

Active member
#7
Yes, I can see that very screen shot in my admin. The only ad on would be the Xenforo resource manager and articles manager that has stats in it. That [AD] Monetize Pro has stats but that was installed after the time stamp of this error and it has it's own built in stats page.
 

Brogan

XenForo moderator
Staff member
#8
If there are other add-ons which add to the stats, I would have to suggest it's one of those - the articles manager sounds like it could be a possibility.
If there was a problem with XF or the RM, we would have been made aware of it before now.

You may want to check with the authors of the add-ons to see if there are any known issues.
 

Huskermax

Active member
#9
If there are other add-ons which add to the stats, I would have to suggest it's one of those - the articles manager sounds like it could be a possibility.
If there was a problem with XF or the RM, we would have been made aware of it before now.

You may want to check with the authors of the add-ons to see if there are any known issues.
Ok, thanks:)