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

Fixed  Register New Feed PHP error

woody

Active member
#1
GREAT new feature...now to get it working...

Pulled a feed link http://feeds.feedburner.com/BlueRibbonCoalition - set the permissions and the new forum these news feeds will reside in...have set the News forum both 'allow' and 'disallow' new messages (I assume a feed would override that, but neither works...)

I constantly received the following error, no matter what settings I switch....and have no idea where the 'console' is so I can find the error and track it...

"The server responded with an error. The error message is in the console."

TIA for assistance...

 

Andy.N

Well-known member
#3
There's a PHP error from that feed. Moving this to bugs.
I have some problems with feeds from feedburners. Once in a while, feedburner feed will timeout, gives errors and as a result, the simplepie we use to update our content from that feed will make the forum (VB 3.8) inresponsive.

I have not used the feed on XF yet, but what is solution for non-working feeds?
 

Dan

Well-known member
#5
Right or Wrong, not sure but a quick "fix"
Find in library/XenForo/Model/Feed.php
PHP:
    'date_modified' => $entry->getDateModified()->getTimestamp(),
Replace With
PHP:
'date_modified' => $entry->getDateModified(),
Seems like it is working
 

Brogan

XenForo moderator
Staff member
#6
Not sure if I should open a new bug report for this or add it here.

I set up a feed from BBC F1 and it was working fine.

URL: http://newsrss.bbc.co.uk/rss/sportonline_uk_edition/motorsport/formula_one/rss.xml

Then I edited the message template like so:
{title}
{authors}
{content}

[URL='http://{link}']Continue reading...[/URL]

Importing the feeds then resulted in this error:
feed_error.PNG

 
#8
Not sure if this is the same error that Brogan saw or not.

I tried to set up a feed, and the error I get is:

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 /home/conserve/public_html/community/admin.php at line 13
 

Romchik®

Well-known member
#9
I have same error:
Code:
Mysqli statement execute error : Column 'thread_id' cannot be null

   1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 317
   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 /data/***********/admin.php at line 13
 

Raitsa

Well-known member
#10
Here is one of mine from http://www.speedtv.com/rss/news/auto-racing/nhra/

unsupported ISO8601 format (01/13/2011)
  1. Zend_Date->_calculate() in Zend/Date.php at line 1078
  2. Zend_Date->set() in Zend/Feed/Reader/Extension/DublinCore/Entry.php at line 248
  3. Zend_Feed_Reader_Extension_DublinCore_Entry->getDate() in Zend/Feed/Reader/Entry/Rss.php at line 296
  4. Zend_Feed_Reader_Entry_Rss->getDateModified() in XenForo/Model/Feed.php at line 189
  5. XenForo_Model_Feed->getFeedData() in XenForo/DataWriter/Feed.php at line 92
  6. XenForo_DataWriter_Feed->_preSave() in XenForo/DataWriter.php at line 1331
  7. XenForo_DataWriter->preSave() in XenForo/DataWriter.php at line 1271
  8. XenForo_DataWriter->save() in XenForo/ControllerAdmin/Feed.php at line 90
  9. XenForo_ControllerAdmin_Feed->actionSave() in XenForo/FrontController.php at line 310
  10. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
  11. XenForo_FrontController->run() in ....................admin.php at line 13
 

Paul

Well-known member
#13
mine is slightly different... however also doesnt work...

http://www.pinballnews.com/headlines.rss

Comes up with..

The following error occurred:

Could not load date due to unrecognised format (should follow RFC 822 or 2822):Missing locale file '/home/toibs/public_html/forums/library/Zend/Locale/Data/en_GB.xml' for 'en_GB' locale.
  1. Zend_Feed_Reader_Entry_Rss->getDateModified() in XenForo/Model/Feed.php at line 189
  2. XenForo_Model_Feed->getFeedData() in XenForo/DataWriter/Feed.php at line 92
  3. XenForo_DataWriter_Feed->_preSave() in XenForo/DataWriter.php at line 1331
  4. XenForo_DataWriter->preSave() in XenForo/DataWriter.php at line 1271
  5. XenForo_DataWriter->save() in XenForo/ControllerAdmin/Feed.php at line 90
  6. XenForo_ControllerAdmin_Feed->actionSave() in XenForo/FrontController.php at line 310
  7. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
  8. XenForo_FrontController->run() in /home/toibs/public_html/forums/admin.php at line 13
Looks like /library/Zen/Locale/Data needs the is missing some of the locale files.

So i added en_GB.xml and en.xml (it prompted this afterwards) and all works fine now.
 
#14
Same here
Server Error

Mysqli statement execute error : Column 'thread_id' cannot be null

PHP:
   1. Zend_Db_Statement_Mysqli->_execute() in C:\xampplite\htdocs\dev\xen\vibe\library\Zend\Db\Statement.php at line 317
   2. Zend_Db_Statement->execute() in C:\xampplite\htdocs\dev\xen\vibe\library\Zend\Db\Adapter\Abstract.php at line 479
   3. Zend_Db_Adapter_Abstract->query() in C:\xampplite\htdocs\dev\xen\vibe\library\Zend\Db\Adapter\Abstract.php at line 574
   4. Zend_Db_Adapter_Abstract->insert() in C:\xampplite\htdocs\dev\xen\vibe\library\XenForo\Model\Feed.php at line 407
   5. XenForo_Model_Feed->_insertFeedEntry() in C:\xampplite\htdocs\dev\xen\vibe\library\XenForo\Model\Feed.php at line 426
   6. XenForo_Model_Feed->_insertFeedData() in C:\xampplite\htdocs\dev\xen\vibe\library\XenForo\Model\Feed.php at line 453
   7. XenForo_Model_Feed->importFeedData() in C:\xampplite\htdocs\dev\xen\vibe\library\XenForo\ControllerAdmin\Feed.php at line 128
   8. XenForo_ControllerAdmin_Feed->actionImport() in C:\xampplite\htdocs\dev\xen\vibe\library\XenForo\FrontController.php at line 310
   9. XenForo_FrontController->dispatch() in C:\xampplite\htdocs\dev\xen\vibe\library\XenForo\FrontController.php at line 132
  10. XenForo_FrontController->run() in C:\xampplite\htdocs\dev\xen\vibe\admin.php at line 13
 
#16
Hello
When I add Registered Feeds and press "Import Now" Shows me this error

Server Error

Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3
  1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
  2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
  3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
  4. Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 218
  5. XenForo_Model->fetchAllKeyed() in XenForo/Model/Feed.php at line 329
  6. XenForo_Model_Feed->_checkProcessedEntries() in XenForo/Model/Feed.php at line 450
  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 /home/*****/public_html/forum/admin.php at line 13
 

Kier

XenForo Developer
Staff member
#17
Can I ask that when anyone reports a feeder error, they also include the URL of the feed that caused the problem, thanks!