[3.3] RSS not working

I've tested this on a new hosting grounds.

PHP 4.4.7

I received errors ... but then I changed:

define("TABLEPREFIX", $tableprefix);

~line 31.

To:

define("TABLEPREFIX", ink_);

ink_ being my actual table prefix. It worked.

That will work for individual archives for people who are willing to edit their files, but it won't work in the main download. :

Ah yes, but just a "quick fix" for anyone who needs it now. [:

I hope it gets fixed in the later versions. :3

So we had a server upgrade, from PHP 4.4.4 to 4.4.7, and the RSS feed quit working, so I tried the fix that Jenny suggested.  It appears, but still doesn't have all the info.  (www.dracoandginny.com/rss.php)  It looks like it's not able to pull the data from the settings table?  Could this because of the mySQL version (4.0.27)?  (That is supposed to be upgraded to 5.0.27 sometime soon, so if that's the case I won't worry about it too much.)

Okay, I solved the problem of it not retrieving data from the settings table.

At around line 27:

$settings = dbrow($settingsresults);

I changed to:

$settings = mysql_fetch_object($settingsresults);

Which is apparently what makes my versions of PHP/MySQL happy.

This is still an issue with 3.3.1

http://www.potionsandsnitches.net/fanfiction/rss.php

Well I can't see your site right now to check, but every site I've looked at the RSS was working.  Anyone else still having RSS problems after 3.3.1 upgrade?

Tammy, this is the rss.php in the 3.3.1 release. I just renamed it to rss2 so people who're using rss.php won't get affected by it:

http://ink.accio.nu/rss2.php

So yes, still an issue. :S

I just upgraded to 3.3.1 and http://www.fanforge.net/rss.php works. Was there something more specific in question? I did get an error on your links btw.

My site is back up now.

itanshi, it isn't an issue for everyone. I think the site needs to use table prefixes in order for the error to occur.

I was also getting the mysql SELECT error on rss.php.  I fixed that by hard coding the table prefix in.

Now I'm having the problem of it not retrieving all the data.  I have text, but no links, and none of the RSS readers can validate it.  http://www.starwarschicks.com/archive/rss.php

There were two suggested solutions to this problem, but I don't know enough about mysql.  Which is better - changing 'dbrow' to 'dbassoc' or to 'mysql_fetch_object'?  (See quoted below)

I tried to re-upload the file several times before posting, Tammy. I'm not the only one with this problem with rss.php, just try to have a look at any other eFiction3.3 site linked in this forum.

Anyway, I found a way to make it works:

I edited line 27 in rss.php:

$settings = dbrow($settingsresults);

Like this:

$settings = dbassoc($settingsresults);

If there is some reason 'dbrow' should be used instead of 'dbassoc', please let me know; however, this way also the urls and $sitename work correctly.

Okay, I solved the problem of it not retrieving data from the settings table.

At around line 27:

$settings = dbrow($settingsresults);

I changed to:

$settings = mysql_fetch_object($settingsresults);

Which is apparently what makes my versions of PHP/MySQL happy.

I just upgraded to 3.3.1, and I got this:

A fatal MySQL error was encountered.
Query: SELECT * FROM fanfiction_ratings
Error: (1146) Table 'fanfiction_ratings' doesn't exist

It's because we have a prefix, which it doesn't seem to be recognizing.  It's the same problem I had before, I believe.

I did the same fix as before, outlined by Jenny above, and it works.

Had the same issue with it not getting info from the settings table (sitename, URL, et.c), but authors and story info were showing up.  Did the same fix as I did before, as well.

Now I'm having the problem of it not retrieving all the data.  I have text, but no links, and none of the RSS readers can validate it.  http://www.starwarschicks.com/archive/rss.php

There were two suggested solutions to this problem, but I don't know enough about mysql.  Which is better - changing 'dbrow' to 'dbassoc' or to 'mysql_fetch_object'?  (See quoted below)

Crysta, what versions of PHP and MySQL do you have?  I switched it to mysql_fetch_object because it was an older version.

Change dbrow to dbassoc.

I'm not sure if this should go here or in another topic, but I've noticed another anomaly with the RSS feed.  We have a syndication at livejournal for the feed ( http://syndicated.livejournal.com/dandgdotcom/), and as of right now the most recently updated story is Stay by ReverseBeauty.  Only, that story has not yet been approved, and is still in the submissions queue.  This isn't the first time I've noticed it, but I never saw it before the update to 3.3.1.

(It's not showing up on my google homepage, but that sometimes has a delay.)

Change dbrow to dbassoc.

That worked, thanks!