External Data Provider / RSS doesn't seem to work?

**ksmike** · Thu 2 Feb '12, 3:07pm

Originally posted by Zachery

Run our feeds agasint an RSS validator, they validate 100%.

I beg to differ. I have a VB feed that works intermittently. I have not gotten it to validate at W3C or rssboard. Other sites cannot pull the feeds. Try it:

http://www.stockplaysonline.com/external.php?type=RSS2

Sometimes it pulls a blank result and other times I get this:

Warning: mysql_query(): 22 is not a valid MySQL-Link resource in [path]/includes/class_core.php on line 408

Warning: mysql_error(): 22 is not a valid MySQL-Link resource in [path]/includes/class_core.php on line 897

Warning: mysql_errno(): 22 is not a valid MySQL-Link resource in [path]/includes/class_core.php on line 915

Warning: mysql_query(): 22 is not a valid MySQL-Link resource in [path]/includes/class_core.php on line 408

Warning: mysql_error(): 22 is not a valid MySQL-Link resource in [path]/includes/class_core.php on line 897

Warning: mysql_errno(): 22 is not a valid MySQL-Link resource in [path]/includes/class_core.php on line 915

Not very often does it pull good feed results. I have upped the packet_size to 64M, checked all forumgroup permissions are viewable, replaced the external.php file with a new one on the server and a half dozen other things with no luck.

Any ideas?

Thanks in advance for any help!

**Wayne Luke** · Thu 2 Feb '12, 3:47pm

That is a completely different issue. Those errors above say that the system can't connect to MySQL properly.

Do you have persistent connections turned on in your config.php? Is so, you need to turn these off. They should only be turned on if you're on a dedicated server network. And even then any benefit is debatable.

**ksmike** · Thu 2 Feb '12, 4:18pm

We are on a dedicated server. So why would the feed work sometimes and NOT validate with W3C and others? Strange, right?

**Zachery** · Thu 2 Feb '12, 4:52pm

Because you're getting mysql errors in the middle of the document that shouldn't be there.

**ksmike** · Thu 2 Feb '12, 4:56pm

Okay, thanks. So do you have a solution? Or should I dig it out of you?

**ksmike** · Thu 2 Feb '12, 4:59pm

Seriously, it sounds to me like you have a solution. Would you like to share it? It would be much appreciated!

**Zachery** · Thu 2 Feb '12, 5:04pm

I don't know whats causing the errors, but they are there plain as day. Do you have third party addons?

**ksmike** · Thu 2 Feb '12, 5:14pm

Not many, VBSEO; Gravity Insights; VBadvanced and Thread Prefixes.

Sorry but the bug is not plain as day to me...

**Zachery** · Thu 2 Feb '12, 5:26pm

You see those gaint mysql errors?

External Data Provider / RSS doesn't seem to work? - vBulletin Community Forum

https://www.vbulletin.com/forum/showthread.php/312866-External-Data-Provider-RSS-doesn-t-seem-to-work?p=2261020&viewfull=1#post2261020

You posted them yourself. Infact they're in the xml doc atm.

Code:

]]></content:encoded> <category domain="[URL]http://www.stockplaysonline.com/penny-stocks-forum/">Penny[/URL] Stocks Forum</category> <dc:creator>chuck44l</dc:creator> <guid isPermaLink="true">http://www.stockplaysonline.com/penny-stocks-forum/2189-itonis-inc.html</guid> </item> </channel> </rss> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "[URL]http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd[/URL]"> <html> <head> <title>StockPlaysOnline - Hot Penny Stock Forums Database Error</title> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" /> <meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" /> <style type="text/css"> <!-- 
 body { background-color: white; color: black; }
 #container { width: 400px; }
 #message   { width: 400px; color: black; background-color: #FFFFCC; }
 #bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
 .bodytext  { font: 8pt/11pt verdana, arial, sans-serif; }
 a:link     { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
 a:visited  { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }
 --> </style> </head> <body> <table cellpadding="3" cellspacing="5" id="container"> <tr> <td><img src="[URL]http://www.stockplaysonline.com/image.php?type=dberror[/URL]" alt="Database Error" width="48" height="48" /></td> <td id="bodytitle" width="100%">Database error</td> </tr> <tr> <td class="bodytext" colspan="2">The StockPlaysOnline - Hot Penny Stock Forums database has encountered a problem.</td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td class="bodytext" colspan="2">
  Please try the following:
  <ul> <li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li> <li>Open the <a href="/">www.stockplaysonline.com</a> home page, then try to open another page.</li> <li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li> </ul> </td> </tr> <tr> <td class="bodytext" colspan="2">The [URL="http://www.stockplaysonline.com"]www.stockplaysonline.com[/URL] forum technical staff have been notified of the error, though you may <a href="[EMAIL="[email protected]">contact"]mailto:[email protected]">contact[/EMAIL] them</a> if the problem persists.</td> </tr> <tr> <td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td> </tr> </table>  </body> </html>

You really need to fix your techemail account in your config file, you'd have been notified of the database errors.

**ksmike** · Thu 2 Feb '12, 5:58pm

Thanks and found it. Work is started. Your help and advice is appreciated.

**Wayne Luke** · Thu 2 Feb '12, 9:27pm

Originally posted by ksmike

Seriously, it sounds to me like you have a solution. Would you like to share it? It would be much appreciated!

Your server is misconfigured. You should visit the Server Configuration forum to help get it configured correctly.

vBulletin 3 End of Life

External Data Provider / RSS doesn't seem to work?

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment