[3.3] RSS not working

(Have a look at my signature for my installation info)

http://www.acciofanfiction.com/rss.php
It seems like the variable TABLEPREFIX could not be read, so the script look for the table fanfiction_ratings (and not chamberfanfiction_ratings, 'chamber' being the table prefix).

Then, I tried to look at other eFiction3.3 sites that don't encounter this problem (probably they don't have any table prefix), like Tammy's Scribbles site, and here we go:
http://scribbles.hugosnebula.com/rss.php
The name of the site is not recognized, and the links works only on certain services (Bloglines) and not in Firefox Live Bookmarks.

Thank you.

My scribbles site does have a prefix.  I suggest you make sure the rss.php got uploaded correctly.

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.

This is still an issue with 3.3.

I'm merging my RSS bug thread with this one...

it seems to work on my new site, which doesn't have a table prefix on anything except the settings.

http://genficrecs.freehostia.com/index.php?skin=CivilWar

But it's not working on the other one.

http://www.potionsandsnitches.net/fanfiction/index.php?skin=CivilWar

I even copied the rss.php from the working site and replaced the nonworking site one. No change.

I havent had any rss feeds on mine since the update either, i am using prefixes.

I think I've found the problem.  We'll see with 3.3.1.

So I'm not really sure that what I did was right, but on line 31 of rss.php I changed $tableprefix to $settingsprefix.  It seems to be working, and we have a prefix.

It was working fine in 3.21., but I was getting this error after upgrading to 3.3:

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

Then I made the change mentioned above, and now it works.  Hopefully this is helpful and the correct way to go about it.  If it's not, I apologize!

Thought I'd include a link: http://www.dracoandginny.com/rss.php

Edit:

So I wasn't thorough in checking it out, and this doesn't seem to be working correctly.  After changing the variable, the last twenty fics or so appeared on my livejournal (where I have the feed monitored).  That's not really the issue - it's that none of the info in this section appears in the feed:

  $rss="<?xml version="1.0" encoding=""._CHARSET.""?>n"; 
  $rss.="<rss version="2.0">n"; 
  $rss.="<channel>n"; 
  $rss.="<copyright>Copyright ".date("Y")."</copyright>n"; 
  $rss.="<lastBuildDate>".date("r")."</lastBuildDate>n"; 
  $rss.="<description>".xmlentities($slogan)."</description>n"; 
  $rss.="<link>$url</link>n"; 
  $rss.="<title>".xmlentities($sitename)."</title>n"; 
  $rss.="<managingEditor>$siteemail</managingEditor>n"; 
  $rss.="<webMaster>$siteemail</webMaster>n"; 
  $rss.="<language>$language</language>n"; 

So the title doesn't appear on iGoogle pages, and the links appear as "/viewstory.php?sid=5541", etc., without the " http://dracoandginny.com" on front.

I should just wait for 3.3.1, probably...

Is there a trend that this isn't working for upgraded sites, only?

My site is on the new install, and works fine.

Could you post a copy of your rss.php file here so that we can compare?

Is there a trend that this isn't working for upgraded sites, only?

My site is on the new install, and works fine.

It would work find if you aren't using a prefix on your tables.

I am using a prefix on my tables, though. 😛

It's working on my site that is using php 5.2.2 but not on the one that's using php 4.4.7 . My guess is that it's something to do with which version of php you're running.

Ah yes, that's a trend, too. 😛

Couldn't it be possible to use the working rss.php (past versions?) and simply replace it with the new variables?