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

Fixed Feed URL length

Discussion in 'Resolved Bug Reports' started by gamecock, Jan 19, 2011.

  1. gamecock

    gamecock Member

    I am getting an exception on some long feed urls. Having to use tinyurl. Can you make it accept longer?
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Is it actually triggering an error?
    If so I will move this to bug reports.
     
  3. Kier

    Kier XenForo Developer Staff Member

    What is the exception being generated?
     
  4. gamecock

    gamecock Member

    Mysqli statement execute error : Data too long for column 'url' at row 1

    /home6/ifootbal/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /home6/ifootbal/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /home6/ifootbal/public_html/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_feed...', Array)
    #3 /home6/ifootbal/public_html/library/XenForo/DataWriter.php(1516): Zend_Db_Adapter_Abstract->update('xf_feed', Array, 'feed_id = 2')
    #4 /home6/ifootbal/public_html/library/XenForo/DataWriter.php(1485): XenForo_DataWriter->_update()
    #5 /home6/ifootbal/public_html/library/XenForo/DataWriter.php(1291): XenForo_DataWriter->_save()
    #6 /home6/ifootbal/public_html/library/XenForo/ControllerAdmin/Feed.php(90): XenForo_DataWriter->save()
    #7 /home6/ifootbal/public_html/library/XenForo/FrontController.php(310): XenForo_ControllerAdmin_Feed->actionSave()
    #8 /home6/ifootbal/public_html/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #9 /home6/ifootbal/public_html/admin.php(13): XenForo_FrontController->run()
    #10 {main}
     
  5. Kier

    Kier XenForo Developer Staff Member

    What is the URL of the feed that you are trying to import?
     
  6. gamecock

    gamecock Member

    Good feature by the way. I think it was this one, but sometimes it is also not validating the url.

    http://news.google.com/news?pz=1&cf=all&ned=us&hl=en&q="Ji
    mbo+Fisher%22+OR+%22Randy+Edsall%22+OR+%22Jim+Grobe%22+OR+%2
    2Tom+O%27Brien+%22+OR+%22Frank+Spaziani%22+OR+%22Dabo+Swinne
    y%22+OR+%22Frank+Beamer%22+OR+%22David+Cutcliffe%22+OR+%22Bu
    tch+Davis%22+OR+%22Mike+London%22+OR+%22Paul+Johnson%22+OR+%
    22Al+Golden%22&cf=all&output=rss
     
  7. gamecock

    gamecock Member

    Another one is giving this when I try to "import"

    Server Error

    Mysqli statement execute error : Column 'thread_id' cannot be null
    1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    3. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
    4. Zend_Db_Adapter_Abstract->insert() in XenForo/Model/Feed.php at line 407
    5. XenForo_Model_Feed->_insertFeedEntry() in XenForo/Model/Feed.php at line 426
    6. XenForo_Model_Feed->_insertFeedData() in XenForo/Model/Feed.php at line 453
    7. XenForo_Model_Feed->importFeedData() in XenForo/ControllerAdmin/Feed.php at line 128
    8. XenForo_ControllerAdmin_Feed->actionImport() in XenForo/FrontController.php at line 310
    9. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
    10. XenForo_FrontController->run() in /home6/ifootbal/public_html/admin.php at line 13
     
  8. Kier

    Kier XenForo Developer Staff Member

    I've fixed the data too long error. The second error should already be resolved in the next release.
     
  9. gamecock

    gamecock Member

  10. gamecock

    gamecock Member

    Is it possible to share the threadId fix now? Error is all over the server log now
     

Share This Page