Thread: [Fofredux-devel] Adding a feed manually?

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Is there a way to add a feed without going thru the panel? I'm asking
since I would like to add a feed to my installation but the "add
feeds" function is currently broken.

-Miles

On 7/17/06, Andrew Turner <ajt...@hi...> wrote:
> Hi Miles,
>
> The url
> fofredux/add.php?rss_url=
>
> should work - unless, as you may mean, the underlying php function is
> broken. Then you could add the feed directly to the database table.
>
> What is the error you're getting? I don't see a message re: adding
> feeds broken or a bug ticket?
>
> Andrew

When I click on "add feeds" I get the following error.

Fatal error: Call to a member function on a non-object in
/var/www/fofredux_0.4-dev/lib/view_helper.php on line 272

This is documented in bug 1522826. Though this bug is referencing
editing a feed, that's where I first noticed it. But trying to add a
feed comes up with the same error.

-Miles

On 7/17/06, Miles Beck <mil...@gm...> wrote:
> On 7/17/06, Andrew Turner <ajt...@hi...> wrote:
> > Hi Miles,
> >
> > The url
> > fofredux/add.php?rss_url=
> >
> > should work - unless, as you may mean, the underlying php function is
> > broken. Then you could add the feed directly to the database table.

What command can I use to add the feed to the database table?

-Miles

I'm pushing this to the list so that Kevin and others can see this
specific message (and it can be archived for search posterity ;)

By default, a "None" category is created, which makes every feed have
at least a category and not a NULL ( I think this is actual proper db
design, not that I would know ;) So you will probably need to add that
back in. Once you add that in, you may need to repair your DB, b/c I
don't remember/know what happens to the feeds that ref'd a category
when you delete it. It used to push it to "None" by default.
Especially when that was the last category.

In the DB, it will look for the 1 id of categories (which used to be 'None').

On 7/19/06, Miles Beck <mil...@gm...> wrote:
> On 7/19/06, Andrew Turner <ajt...@hi...> wrote:
> > Do you have categories that show up under "Categories"?
>
> That's odd. I did have a category there, for some reason called
> "None". I deleted the category and now the "add feed" page comes up
> without an error. But when I try an add a feed I now get the following
> error.
>
> Fatal error: mysql 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 '('fr_categories_id_seq')' at line 1] in
> EXECUTE("select currval('fr_categories_id_seq')")
> Error performing database operation, Maybe you need to run the installer.
> in /var/www/fofredux_0.4-dev/lib/model/base.php on line 251
>

-- 
Andrew Turner
ajt...@hi...        42.4266N x 83.4931W
http://highearthorbit.com              Northville, Michigan, USA

Miles Beck wrote:
> Heh, the above error is I think happening due to my database being
> wiped out when I delete the category. I just tried deleting the
> category again with a restored version of my DB and I no longer have
> any feeds when I delete the category. So the error above comes after
> the DB is wiped out.

Hrm, I think that's odd. I hope when you delete a category normally it
doesn't delete the associated feeds. The feeds should just point to
"None". That will have to be tested.

Hopefully you have a saved OPML file or db backup?

-- 
Andrew Turner
ajt...@hi...        42.4266N x 83.4931W
http://highearthorbit.com              Northville, Michigan, USA

> Miles Beck wrote:
>> Heh, the above error is I think happening due to my database being
>> wiped out when I delete the category. I just tried deleting the
>> category again with a restored version of my DB and I no longer have
>> any feeds when I delete the category. So the error above comes after
>> the DB is wiped out.
>
> Hrm, I think that's odd. I hope when you delete a category normally it
> doesn't delete the associated feeds. The feeds should just point to
> "None". That will have to be tested.

The feeds don't get deleted, they are just *hidden* from the application.=
=20
In the SQL queries for feeds and items, an inner join is used to pull in
the category name.  If the category_id does not exist, that feed/item is
not included in the result.

I left a TODO in the category remove method to reset all feeds to the Non=
e
category when a category is deleted.  I haven't done it yet.

--=20
Kevin

On 7/19/06, Andrew Turner <ajt...@hi...> wrote:
> Miles Beck wrote:
> > Heh, the above error is I think happening due to my database being
> > wiped out when I delete the category. I just tried deleting the
> > category again with a restored version of my DB and I no longer have
> > any feeds when I delete the category. So the error above comes after
> > the DB is wiped out.

The error I am referring to is an error when I tried to add a feed
after I had deleted the category. Which would not work since the DB
was wiped out. The initial error I reported with adding a feed is
still a problem.

There is something definatly weird going on. Now with a restored DB
trying to add a category gives me the same error message I was talking
to Andrew about.

Fatal error: mysql 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 '('fr_categories_id_seq')' at line 1] in
EXECUTE("select currval('fr_categories_id_seq')")
Error performing database operation, Maybe you need to run the installer.
in /var/www/fofredux_0.4-dev/lib/model/base.php on line 251

So after you restore your DB - go to install.php and have it see if
your DB needs to be updated after some revision maybe?

On 7/19/06, Miles Beck <mil...@gm...> wrote:
> On 7/19/06, Andrew Turner <ajt...@hi...> wrote:
> > Miles Beck wrote:
> > > Heh, the above error is I think happening due to my database being
> > > wiped out when I delete the category. I just tried deleting the
> > > category again with a restored version of my DB and I no longer have
> > > any feeds when I delete the category. So the error above comes after
> > > the DB is wiped out.
>
> The error I am referring to is an error when I tried to add a feed
> after I had deleted the category. Which would not work since the DB
> was wiped out. The initial error I reported with adding a feed is
> still a problem.
>
> There is something definatly weird going on. Now with a restored DB
> trying to add a category gives me the same error message I was talking
> to Andrew about.
>
> Fatal error: mysql 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 '('fr_categories_id_seq')' at line 1] in
> EXECUTE("select currval('fr_categories_id_seq')")
> Error performing database operation, Maybe you need to run the installer.
> in /var/www/fofredux_0.4-dev/lib/model/base.php on line 251
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Fofredux-devel mailing list
> Fof...@li...
> https://lists.sourceforge.net/lists/listinfo/fofredux-devel
>

-- 
Andrew Turner
ajt...@hi...        42.4266N x 83.4931W
http://highearthorbit.com              Northville, Michigan, USA

On 7/19/06, Andrew Turner <ajt...@hi...> wrote:
> So after you restore your DB - go to install.php and have it see if
> your DB needs to be updated after some revision maybe?

I just ran install.php again and nothing changed. The error was still
there when adding a category and going to the 'add feeds' link.

Andrew, what snapshot are you using? Maybe I should try a a later one,
though I don't think anything has been updated since I installed the
0711 snapshot.

-Miles