Mysqli statement execute error : Data truncated for column 'score' at row 1

[Veer]

I found this error in the logs:

Error Info

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Data truncated for column 'score' at row 1 - library/Zend/Db/Statement/Mysqli.php:214

Stack Trace

#0 /library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /library/Arcade/Model/Session.php(11): Zend_Db_Adapter_Abstract->insert('xf_arcade_sessi...', Array)
#4 /library/Arcade/ControllerPublic/ArcadeUgly.php(192): Arcade_Model_Session->saveSession(Array, Array, Array)
#5 /library/XenForo/FrontController.php(310): Arcade_ControllerPublic_ArcadeUgly->actionIpbSaveScoreLegacy()
#6 /library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#7 /index.php(13): XenForo_FrontController->run()
#8 {main}

Request State

array(3) {
  ["url"] => string(59) "http://www.forum.com/index.php?act=Arcade&do=newscore"
  ["_GET"] => array(2) {
    ["act"] => string(6) "Arcade"
    ["do"] => string(8) "newscore"
  }
  ["_POST"] => array(0) {
  }
}

 

[TheVisitors]

I can confirm the error. Mine looks like this though.

Error Info

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Out of range value adjusted for column 'score' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Wanderer, Yesterday at 4:16 PM

Stack Trace

#0 /home/****/public_html/forums/library/Zend/Db/Statement.php(317): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/****/public_html/forums/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/****/public_html/forums/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /home/****/public_html/forums/library/Arcade/Model/Session.php(11): Zend_Db_Adapter_Abstract->insert('xf_arcade_sessi...', Array)
#4 /home/***/public_html/forums/library/Arcade/ControllerPublic/ArcadeUgly.php(192): Arcade_Model_Session->saveSession(Array, Array, Array)
#5 /home/****/public_html/forums/library/XenForo/FrontController.php(310): Arcade_ControllerPublic_ArcadeUgly->actionIpbSaveScoreLegacy()
#6 /home/*****/public_html/forums/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#7 /home/******/public_html/forums/index.php(13): XenForo_FrontController->run()
#8 {main}

Request State

array(3) {
  ["url"] => string(72) "http://www.sociallyuncensored.eu/forums/index.php?act=Arcade&do=newscore"
  ["_GET"] => array(2) {
    ["act"] => string(6) "Arcade"
    ["do"] => string(8) "newscore"
  }
  ["_POST"] => array(36) {
    ["yardage"] => string(6) "-21.02"
    ["virtx"] => string(12) "2430.9118125"
    ["virty"] => string(8) "-79.6625"
    ["virtz"] => string(17) "-114.882763143427"
    ["inc"] => string(2) "20"
    ["vanx"] => string(1) "0"
    ["vany"] => string(4) "-100"
    ["lightx"] => string(3) "450"
    ["lighty"] => string(3) "100"
    ["dim"] => string(4) "6000"
    ["decay"] => string(4) "0.97"
    ["build"] => string(4) "0.02"
    ["size"] => string(3) "0.3"
    ["fog"] => string(3) "3.5"
    ["jolt"] => string(1) "3"
    ["speedy"] => string(8) "-0.44625"
    ["speedz"] => string(20) "-0.00752223230419753"
    ["slice"] => string(1) "0"
    ["distance"] => string(6) "-21.02"
    ["slice2"] => string(10) "0.74874375"
    ["dir"] => string(2) "-1"
    ["ymover"] => string(3) "106"
    ["where"] => string(17) "-32.2442601751729"
    ["distx"] => string(17) "-261.008257725176"
    ["disty"] => string(17) "-2.05288456448601"
    ["power"] => string(18) "-0.940279038024691"
    ["shot"] => string(1) "1"
    ["hippy"] => string(2) "79"
    ["off"] => string(6) "1.9125"
    ["abs"] => string(6) "1.9125"
    ["counter"] => string(3) "214"
    ["c"] => string(1) "0"
    ["t"] => string(6) "-20.99"
    ["bounce"] => string(1) "3"
    ["gname"] => string(11) "powerdriver"
    ["gscore"] => string(6) "-21.02"
  }
}

 

[TheVisitors]

^^ Paths edited out with **** for security

 

[Numenorean7]

I get the same error. It happens when saving a score for a game I just installed. I double checked the install procedure, I'm pretty sure it's not something I missed.

Error Info

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Data truncated for column 'score' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Numenorean7, 3 minutes ago

Stack Trace

#0 /home/paranor/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/paranor/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/paranor/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /home/paranor/public_html/library/Arcade/Model/Session.php(11): Zend_Db_Adapter_Abstract->insert('xf_arcade_sessi...', Array)
#4 /home/paranor/public_html/library/Arcade/ControllerPublic/ArcadeUgly.php(227): Arcade_Model_Session->saveSession(Array, Array, Array)
#5 /home/paranor/public_html/library/XenForo/FrontController.php(310): Arcade_ControllerPublic_ArcadeUgly->actionIpbSaveScore()
#6 /home/paranor/public_html/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#7 /home/paranor/public_html/index.php(13): XenForo_FrontController->run()
#8 {main}

Request State

array(3) {
  ["url"] => string(61) "http://paranormalis.com/index.php?autocom=arcade&do=savescore"
  ["_GET"] => array(2) {
    ["autocom"] => string(6) "arcade"
    ["do"] => string(9) "savescore"
  }
  ["_POST"] => array(4) {
    ["enscore"] => string(2) "20"
    ["gname"] => string(18) "swingnpingv32MICRO"
    ["gscore"] => string(0) ""
    ["arcadegid"] => string(0) ""
  }
}