Fixed Feed URL length

[gamecock]

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

 

[Paul B]

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

 

[Kier]

What is the exception being generated?

 

[gamecock]

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}

 

[Kier]

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

 

[gamecock]

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

 

[gamecock]

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

 

[Kier]

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

 

[gamecock]

cool

 

[gamecock]

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