1. 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

Discussion in 'XenForo Questions and Support' started by Tokiz, Jun 9, 2012.

  1. Tokiz

    Tokiz 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
  2. Tokiz

    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"
  3. Tokiz

    Tokiz New Member

    bump, I really need help with this and I would be very thankful.
  4. Chris D

    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?
  5. Tokiz

    Tokiz New Member

    Steam profile badge. What do you mean? That I can't have both?
  6. Chris D

    Chris D XenForo Developer Staff Member

  7. Tokiz

    Tokiz New Member

    Yorick likes this.

Share This Page