RSS feed not working after moving to a new server....

WebKat
WebKat's picture

Joined: 2002-11-22
Posts: 182
Posted: Sun, 2012-03-25 08:06


Gallery version (not just "2"): 2.3.1 core 1.3.0.1
PHP version (e.g. 5.1.6):5.2.17 cgi-fcgi
PHPInfo Link (see FAQ): http://gallery2.opalcat.com/gallery2/phpinfo.php
Webserver (e.g. Apache 1.3.33): Apache
Database (e.g. MySql 5.0.32):mysqli 5.1.62-community-log, lock.system=flock
Activated toolkits (e.g. NetPbm, GD): ArchiveUpload, Exif, Getid3, ImageMagick, LinkItemToolkit, NetPBM, Thumbnail, Gd
Operating system (e.g. Linux):Linux host180.hostmonster.com 2.6.32-46.1.BHsmp #1 SMP Tue Sep 6 12:18:02 MDT 2011 x86_64
Browser (e.g. Firefox 2.0): Google Chrome 17.0.963.79 m

This exact RSS feed used to work fine, but the other day I moved to another server (same hosting company, different hosting account). I changed all the server paths everywhere I found them (I even went through the database) and so I don't know what is going on. The feed doesn't show up on my homepage using the feed displaying plugin I have been using there for ages (the same plugin is displaying other feeds just fine)...
Here is the url of the feed:
http://gallery2.opalcat.com/gallery2/main.php?g2_view=rss.Render&g2_name=OpalCat%27s+Gallery+Feed

Any thoughts?
--
WebKat, Gallery2 holdover extraordinaire.
 
WebKat
WebKat's picture

Joined: 2002-11-22
Posts: 182
Posted: Sun, 2012-03-25 08:32

If it's of any use, it looks like this in the database:

Quote:
a:15:{s:6:"itemId";s:1:"7";s:8:"feedType";s:15:"photosRecursive";s:8:"feedDate";s:7:"updated";s:7:"version";s:3:"2.0";s:5:"count";s:3:"100";s:3:"ttl";s:3:"120";s:8:"category";s:0:"";s:8:"language";s:5:"en-us";s:9:"copyright";s:11:"opalcat.com";s:11:"description";s:43:"A feed of overall updates from the gallery.";s:8:"useImage";s:1:"1";s:12:"useEnclosure";s:1:"0";s:8:"useCloud";s:1:"0";s:8:"useMedia";s:1:"1";s:20:"photosRecursiveLimit";s:1:"0";}

--
WebKat, Gallery2 holdover extraordinaire.
 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Sun, 2012-03-25 12:21

The above rss feed works for me

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
 
WebKat
WebKat's picture

Joined: 2002-11-22
Posts: 182
Posted: Sun, 2012-03-25 18:18

Really? How are you viewing it? When I just open the feed url directly in my browser (Chrome) I get this error in a big pink box at the top of the page:

Quote:
This page contains the following errors:
error on line 675 at column 7: Extra content at the end of the document
Below is a rendering of the page up to the first error.

After the pink box it's followed by a bunch of urls and text and so on, until it reaches the first error, as stated.
Here is a screenshot of what it looks like to me...

...and the source code of the feed looks like this (basically it looks like a feed is supposed to look, except for the error at the bottom). I'm only posting the last "item" (since it said it is rendering the page up to the first error). I bolded the error part:

Quote:
<item>
<title><![CDATA[airpump2]]></title>
<link>http://gallery2.opalcat.com/gallery2/v/Dominic/misc_unsorted/airpump2.jpg.html</link>
<guid isPermaLink="false">http://gallery2.opalcat.com/gallery2/v/Dominic/misc_unsorted/airpump2.jpg.html</guid>
<description><![CDATA[<a href="http://gallery2.opalcat.com/gallery2/v/Dominic/misc_unsorted/airpump2.jpg.html"><img border="0" src="http://gallery2.opalcat.com/gallery2/d/51397-2/airpump2.jpg" width="124" height="150"/></a><br/>In album <a href="http://gallery2.opalcat.com/gallery2/v/Dominic/misc_unsorted/">Misc Unsorted</a>]]></description>
<author>OpalCat</author>
<category>photo</category>
<media:content url="http://gallery2.opalcat.com/gallery2/d/51396-1/airpump2.jpg" type="image/jpeg" height="155" width="128" />
<media:title><![CDATA[airpump2]]></media:title>
<media:text type="html"><![CDATA[<a href="http://gallery2.opalcat.com/gallery2/v/Dominic/misc_unsorted/airpump2.jpg.html"><img border="0" src="http://gallery2.opalcat.com/gallery2/d/51397-2/airpump2.jpg" width="124" height="150"/></a><br/>In album <a href="http://gallery2.opalcat.com/gallery2/v/Dominic/misc_unsorted/">Misc Unsorted</a>]]></media:text>
<media:thumbnail url="http://gallery2.opalcat.com/gallery2/v/Dominic/misc_unsorted/airpump2.jpg.html" width="124" height="150" />
<pubDate>Sun, 18 Mar 2012 17:34:51 -0600</pubDate>
</item>
</channel>
</rss>Access denied for user 'juggler1'@'localhost' (using password: NO)

So I don't know what that access denied thing is all about... do you? But apparently it's making my RSS feed throw an error.

As far as implementation/how I'm using it on my site, if you go to opalcat.com and scroll down to where it says "Recently Updated Gallery Items:" you'll see that the feed doesn't show up there (it's supposed to show the 3 most recent items.) It just skips directly to "Recent Twitter Tweets:" which is the next rss feed (which is working fine).

My page code calling it looks like this:

Quote:
<!-- Gallery --><a name="gallery"><!-- --></a>
<div class="noprint">
<h2 class="frontpage_h2"><a href="/Fun/most-recent-gallery-photos">Recently Updated Gallery Items</a>:</h2>
<div id="gallery_recent"><txp:rah_function call="html_entity_decode"><txp:bit_rss feed="http://gallery2.opalcat.com/gallery2/main.php?g2_view=rss.Render&g2_name=OpalCat%27s+Gallery+Feed" limit="3" form="rss_gallery" cache_dir="/home/vhosts/opalcat/www/textpattern/cache/" /></txp:rah_function></div><!--gallery_recent-->
</div><!--noprint-->

And the source code of that part of the page when it's loaded looks like this:

Quote:
<!-- Gallery --><a name="gallery"><!-- --></a>
<div class="noprint">
<h2 class="frontpage_h2"><a href="/Fun/most-recent-gallery-photos">Recently Updated Gallery Items</a>:</h2>
<div id="gallery_recent"></div><!--gallery_recent-->
</div><!--noprint-->

As you can see, the feed... she ain't there.

...and just to be thorough, here is form rss_gallery that the txp:bit_rss tag calls:

Quote:
<div class="gallery_recent_individual"><h3><txp:permlink><txp:title /></txp:permlink></h3>
<p><txp:rss_auto_excerpt words="75" showlinkwithexcerpt="0" /></p>
<p class="smallcaps"><txp:permlink>View Album</txp:permlink> &rarr;</p></div><!--gallery_recent_individual-->

So is the problem something with me? Is it working for you? If it works for you how are you viewing it? Does it show up on my page for you? Is there something wrong with my page or form code? It all worked fine before I switched servers...

--
WebKat, Gallery2 holdover extraordinaire.
 
Dayo

Joined: 2005-11-04
Posts: 1642
Posted: Sun, 2012-03-25 19:33

This a really interesting one.

1. Chrome: Fails with "error on line 675 at column 7: Extra content at the end of the document" msg
2. Camino: Fails with "XML Parsing Error: junk after document element ... Line Number 675, Column 7" (same identifier as Chrome)
3. Opera: Fails with "unexpected text (non-whitespace text outside root element)" Shows the offending lines leading to ... "675: </rss>Access denied for user 'juggler1'@'localhost' (using password: NO)"
4. Safari: Works fine. No issues
5. Firefox: Works fine. No issues
Summary, something is trying to access your database as user "juggler1" but without the credentials. This creates an error msg that is appended to the rss feed. Safari and Firefox ignore the appended text after the closing XML tag and work fine while the other three continue after the </xml> tag, see the text and choke on it.

Do you have a user "juggler1"?

--
dakanji.com
 
WebKat
WebKat's picture

Joined: 2002-11-22
Posts: 182
Posted: Sun, 2012-03-25 20:44

Yes,that is the main user for the account.

--
WebKat, Gallery2 holdover extraordinaire.
 
WebKat
WebKat's picture

Joined: 2002-11-22
Posts: 182
Posted: Sun, 2012-03-25 21:30

Ok, I just went to http://gallery2.opalcat.com/gallery2/main.php?g2_view=rss.Render&g2_name=OpalCat%27s+Gallery+Feed in Chrome, and the error didn't show up! It still isn't showing up in the rss tag on my site, though. All I really did was put my site in debug mode for a minute, then back out. I don't know what could have changed to make the feed error go away...

...but I still need to figure out why it's not showing up on the page.

--
WebKat, Gallery2 holdover extraordinaire.