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

XF 1.1 Steam Authentication & Integration


New member
Hello XenForo members!

I am in need of some help, I was trying to install the Steam Authentication & Integration when suddently i got this error:

Server Error
Mysqli statement execute error : Data truncated for column 'game_hours' at row 1
    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
    Zend_Db_Adapter_Abstract->insert() in Steam/Cron.php at line 38
    Steam_Cron::update() in Steam/Manufacture.php at line 104
    Steam_Manufacture->_installVersion8() in Steam/Manufacture.php at line 59
    call_user_func() in XenForo/Model/AddOn.php at line 214
    XenForo_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
    XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 178
    XenForo_ControllerAdmin_AddOn->actionInstall() in XenForo/FrontController.php at line 310
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
    XenForo_FrontController->run() in /home/xhoster1/public_html/forum2/admin.php at line 13
And then I found this post, explaning what to do if I got that error:

It didn't work, I still got that error. So I made a new /forum2/ folder on my webserver and made a clean installation, and then it worked.
But the thing is, I don't want to make a clean installation, I mean, it must be a reason why it gives me that error?

I tried to delete the databases as he said, and use 1.0.7-c-v2 and set chmod 777 on cache folder.
So do you guys have any idea why It won't work?

Regards, Tokiz


New member
Server Error Log
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'game_hours_recent' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Tokiz, Wednesday at 10:46 PM
Stack Trace
#0 /home/xhoster1/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /home/xhoster1/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /home/xhoster1/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /home/xhoster1/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /home/xhoster1/public_html/library/Steam/Cron.php(38): Zend_Db_Adapter_Abstract->insert('xf_user_steam_g...', Array)
#5 /home/xhoster1/public_html/library/Steam/Manufacture.php(95): Steam_Cron::update()
#6 /home/xhoster1/public_html/library/Steam/Manufacture.php(59): Steam_Manufacture->_installVersion4()
#7 [internal function]: Steam_Manufacture::build(false, Array)
#8 /home/xhoster1/public_html/library/XenForo/Model/AddOn.php(214): call_user_func(Array, false, Array)
#9 /home/xhoster1/public_html/library/XenForo/Model/AddOn.php(169): XenForo_Model_AddOn->installAddOnXml(Object(SimpleXMLElement), false)
#10 /home/xhoster1/public_html/library/XenForo/ControllerAdmin/AddOn.php(178): XenForo_Model_AddOn->installAddOnXmlFromFile('/tmp/phpqrLAan')
#11 /home/xhoster1/public_html/library/XenForo/FrontController.php(310): XenForo_ControllerAdmin_AddOn->actionInstall()
#12 /home/xhoster1/public_html/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#13 /home/xhoster1/public_html/admin.php(13): XenForo_FrontController->run()
#14 {main}
Request State
array(3) {
  ["url"] => string(53) "http://xxxxxxxxxx/admin.php?add-ons/install"
  ["_GET"] => array(1) {
    ["add-ons/install"] => string(0) ""
  ["_POST"] => array(3) {
    ["server_file"] => string(0) ""
    ["_xfConfirm"] => string(1) "1"
    ["_xfToken"] => string(53) "1,1339019154,939e22189870d5218ae86a832d540754c87895ad"

Chris D

XenForo developer
Staff member
We use a much older add-on on our forum to achieve both of these things.

Which bit is most important? Authentication or having the Steam profile badge?