Menu
▾
▴
fofredux-devel — Developers discussion, bug fixing, and coding of fofredux
You can subscribe to this list here.
| 2005 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(92) |
Dec
(142) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2006 |
Jan
(33) |
Feb
(65) |
Mar
(76) |
Apr
(172) |
May
(124) |
Jun
(45) |
Jul
(76) |
Aug
(78) |
Sep
(1) |
Oct
(20) |
Nov
(6) |
Dec
(2) |
| 2007 |
Jan
(12) |
Feb
(7) |
Mar
(17) |
Apr
(3) |
May
|
Jun
(2) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
|
From: Kevin <ke...@dr...> - 2006-07-19 19:47:03
|
> 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 |
|
From: Miles B. <mil...@gm...> - 2006-07-19 18:27:22
|
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 |
|
From: Andrew T. <ajt...@hi...> - 2006-07-19 18:19:15
|
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
|
|
From: Miles B. <mil...@gm...> - 2006-07-19 18:12:04
|
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
|
|
From: Andrew T. <ajt...@hi...> - 2006-07-19 17:59:08
|
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 |
|
From: Andrew T. <ajt...@hi...> - 2006-07-19 17:55:14
|
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
|
|
From: Kevin <ke...@dr...> - 2006-07-18 22:58:59
|
> I've seen this too recently (after moving to the SVN head myself). > THerefore, I'm led to believe it's a bug in the FoFRedux parser link > builder. Well, not all the blame goes to FOFR. The feed is a bit broken. The gui= d tag is supposed to be a "global" unique id for the item.(a.k.a permalink)= =20 A simple number doesn't cut it. > Also, has anyone noticed that displaying the panel has gotten slow? It > takes minutes to render my panel list of approx 100 feeds. I tweaked a few things in the feed model code to speed up the panel, but it is still slower then 0.3. I'll look into it. -Kevin > > On 7/18/06, Miles Beck <mil...@gm...> wrote: >> I have a feed that is pointing to my local machine when mousing over >> the links. Below is an example rss entry for the article and then the >> link that FoFRedux is pointing to. Is this a problem with FoFRedux or >> the rss feed? >> >> <item> >> <title>Ex-doctor gets six months in Glendale meth case</title> >> <pubDate>Tue, 18 Jul 2006 14:15:00 MST</pubDate> >> <link>http://www.azcentral.com/rsslinks/173807</link> >> <guid>173807</guid> >> =1B$B!]=1B(B >> <description> >> A former Glendale doctor, the target of a methamphetamine raid last >> year, has been sentenced to six months in jail. He entered into a plea >> agreement that called for the dismissal of charges against his wife, a >> ballet teacher who also was arrested in the case. >> </description> >> </item> >> >> >> http://xx.xx.xx.xxx/fofredux_0.4-dev/173807 >> >> ----------------------------------------------------------------------= --- >> Take Surveys. Earn Cash. Influence the Future of IT >> Join SourceForge.net's Techsay panel and you'll get the chance to shar= e >> your >> opinions on IT & business topics through brief surveys -- and earn cas= h >> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID= =3DDEVDEV >> _______________________________________________ >> 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 > > -----------------------------------------------------------------------= -- > 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=3Djoin.php&p=3Dsourceforge&CID=3D= DEVDEV > _______________________________________________ > Fofredux-devel mailing list > Fof...@li... > https://lists.sourceforge.net/lists/listinfo/fofredux-devel > --=20 Kevin |
|
From: Andrew T. <ajt...@hi...> - 2006-07-18 22:49:40
|
On 7/18/06, Miles Beck <mil...@gm...> wrote: > On 7/18/06, Andrew Turner <ajt...@hi...> wrote: > > Also, has anyone noticed that displaying the panel has gotten slow? It > > takes minutes to render my panel list of approx 100 feeds. > > I've not see this happen. So your panel comes up quickly? I think I'll turn on debug to find out if there is a problem with my tables or something that is throwing errors. > I posted the rss link issue in the bug tracker so we do not forget about it. Awesome - > -Miles > > ------------------------------------------------------------------------- > 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 |
|
From: Miles B. <mil...@gm...> - 2006-07-18 22:47:29
|
On 7/18/06, Andrew Turner <ajt...@hi...> wrote: > Also, has anyone noticed that displaying the panel has gotten slow? It > takes minutes to render my panel list of approx 100 feeds. I've not see this happen. I posted the rss link issue in the bug tracker so we do not forget about it. -Miles |
|
From: Andrew T. <ajt...@hi...> - 2006-07-18 22:37:57
|
I've seen this too recently (after moving to the SVN head myself). THerefore, I'm led to believe it's a bug in the FoFRedux parser link builder. Also, has anyone noticed that displaying the panel has gotten slow? It takes minutes to render my panel list of approx 100 feeds. Andrew On 7/18/06, Miles Beck <mil...@gm...> wrote: > I have a feed that is pointing to my local machine when mousing over > the links. Below is an example rss entry for the article and then the > link that FoFRedux is pointing to. Is this a problem with FoFRedux or > the rss feed? > > <item> > <title>Ex-doctor gets six months in Glendale meth case</title> > <pubDate>Tue, 18 Jul 2006 14:15:00 MST</pubDate> > <link>http://www.azcentral.com/rsslinks/173807</link> > <guid>173807</guid> > − > <description> > A former Glendale doctor, the target of a methamphetamine raid last > year, has been sentenced to six months in jail. He entered into a plea > agreement that called for the dismissal of charges against his wife, a > ballet teacher who also was arrested in the case. > </description> > </item> > > > http://xx.xx.xx.xxx/fofredux_0.4-dev/173807 > > ------------------------------------------------------------------------- > 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 |
|
From: Miles B. <mil...@gm...> - 2006-07-18 21:19:42
|
I have a feed that is pointing to my local machine when mousing over the links. Below is an example rss entry for the article and then the link that FoFRedux is pointing to. Is this a problem with FoFRedux or the rss feed? <item> <title>Ex-doctor gets six months in Glendale meth case</title> <pubDate>Tue, 18 Jul 2006 14:15:00 MST</pubDate> <link>http://www.azcentral.com/rsslinks/173807</link> <guid>173807</guid> − <description> A former Glendale doctor, the target of a methamphetamine raid last year, has been sentenced to six months in jail. He entered into a plea agreement that called for the dismissal of charges against his wife, a ballet teacher who also was arrested in the case. </description> </item> http://xx.xx.xx.xxx/fofredux_0.4-dev/173807 |
|
From: Miles B. <mil...@gm...> - 2006-07-17 16:24:25
|
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 |
|
From: Miles B. <mil...@gm...> - 2006-07-17 15:06:24
|
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 |
|
From: Miles B. <mil...@gm...> - 2006-07-17 14:58:06
|
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 |
|
From: Kevin <ke...@dr...> - 2006-07-14 16:39:48
|
Please add bugs to the tracker. I don't have the cycles to fix them righ= t now, but will soon. > I think Kevin was looking at them - however, when in doubt, add a bug > to the tracker. Worst case is that it's a duplicate or already taken > care of and will be marked as such. Filing it may not guarantee it > gets done quickly, but will definitely get addressed before a release. > > Thanks, > Andrew > > On 7/12/06, Miles Beck <mil...@gm...> wrote: >> Should I input the two bugs to the bug tracker that I have noticed >> lately? >> >> One is with variable feed updates and the other is with editing a >> feed. These have been posted to the list but I was not sure if someone >> would be able to check them out soon. >> >> -Miles >> >> >> ----------------------------------------------------------------------= --- >> Using Tomcat but need to do more? Need to support web services, >> security? >> Get stuff done quickly with pre-integrated technology to make your job >> easier >> Download IBM WebSphere Application Server v.1.0.1 based on Apache >> Geronimo >> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&da= t=3D121642 >> _______________________________________________ >> 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 > > > -----------------------------------------------------------------------= -- > Using Tomcat but need to do more? Need to support web services, securit= y? > Get stuff done quickly with pre-integrated technology to make your job > easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geron= imo > http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat= =3D121642 > _______________________________________________ > Fofredux-devel mailing list > Fof...@li... > https://lists.sourceforge.net/lists/listinfo/fofredux-devel > --=20 Kevin |
|
From: Andrew T. <ajt...@hi...> - 2006-07-14 12:58:56
|
I think Kevin was looking at them - however, when in doubt, add a bug to the tracker. Worst case is that it's a duplicate or already taken care of and will be marked as such. Filing it may not guarantee it gets done quickly, but will definitely get addressed before a release. Thanks, Andrew On 7/12/06, Miles Beck <mil...@gm...> wrote: > Should I input the two bugs to the bug tracker that I have noticed lately? > > One is with variable feed updates and the other is with editing a > feed. These have been posted to the list but I was not sure if someone > would be able to check them out soon. > > -Miles > > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > 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 |
|
From: Miles B. <mil...@gm...> - 2006-07-12 22:08:30
|
Should I input the two bugs to the bug tracker that I have noticed lately? One is with variable feed updates and the other is with editing a feed. These have been posted to the list but I was not sure if someone would be able to check them out soon. -Miles |
|
From: Miles B. <mil...@gm...> - 2006-07-12 17:21:41
|
A little more information on this. My feeds had not been updated for a little over an hour. I then tried running update-quiet.php and it worked. So it appears something is not being disabled when the "variable feed updates" is not checked. -Miles |
|
From: Miles B. <mil...@gm...> - 2006-07-12 16:39:49
|
On 7/12/06, Kevin <ke...@dr...> wrote: > What happens when you run update-quiet.php? try turning on debug and see > if it gives any errors. Running update-quiet.php from my web browser did not return any errors with just PHP_DEBUG on. It looks like nothing at all is happening and the php script is not being run at all. With DB_DEBUG turned on as well it returned this; which does not look like a problem. (mysql): SELECT name, value FROM fr_config Error (0): (mysql): SELECT feed.id, feed.url, feed.title, feed.link, feed.category_id, cat.title as category_title, feed.latitude, feed.longitude, feed.update_enabled, feed.auto_tag, feed.last_update, feed.update_interval FROM fr_feeds feed JOIN fr_categories cat ON (feed.category_id = cat.id)ORDER BY title ASC Error (0): |
|
From: Kevin <ke...@dr...> - 2006-07-12 16:28:19
|
> On 7/11/06, Kevin <ke...@dr...> wrote: >> Miles Beck wrote: >> > update.php and update-quiet.php are no longer working for me in this >> snapshot. >> > >> > When I try and use them the screen just refreshes. Is anyone else >> seeing this? >> > >> This is probably related to variable feed updates. The default is to >> update a feed every hour, no matter how often you run update all. It >> will only update the feeds that have last_update column value older th= an >> one hour. You can turn this feature off with by unchecking the optio= n >> "variable feed updates". > > Update all from the panel now works again with this option turned off. > However my cron job using update-quiet.php is not being run > successfully. When I run it from the command line it is not run. I ram > it from the command line to see if it was running correctly. What happens when you run update-quiet.php? try turning on debug and see if it gives any errors. --=20 Kevin |
|
From: Miles B. <mil...@gm...> - 2006-07-12 16:17:33
|
On 7/11/06, Kevin <ke...@dr...> wrote: > Miles Beck wrote: > > update.php and update-quiet.php are no longer working for me in this snapshot. > > > > When I try and use them the screen just refreshes. Is anyone else seeing this? > > > This is probably related to variable feed updates. The default is to > update a feed every hour, no matter how often you run update all. It > will only update the feeds that have last_update column value older than > one hour. You can turn this feature off with by unchecking the option > "variable feed updates". Update all from the panel now works again with this option turned off. However my cron job using update-quiet.php is not being run successfully. When I run it from the command line it is not run. I ram it from the command line to see if it was running correctly. -Miles |
|
From: Kevin <ke...@dr...> - 2006-07-12 03:12:53
|
Miles Beck wrote: > update.php and update-quiet.php are no longer working for me in this snapshot. > > When I try and use them the screen just refreshes. Is anyone else seeing this? > This is probably related to variable feed updates. The default is to update a feed every hour, no matter how often you run update all. It will only update the feeds that have last_update column value older than one hour. You can turn this feature off with by unchecking the option "variable feed updates". I'm using this option on my personal feed and it seems to work well. I run update-quiet.php via cron every 1/2 hour and only a small subset of my feeds update because I've configured their update interval to be anywhere between 2 and 24 hours. -Kevin |
|
From: Miles B. <mil...@gm...> - 2006-07-11 23:41:20
|
update.php and update-quiet.php are no longer working for me in this snapshot. When I try and use them the screen just refreshes. Is anyone else seeing this? -Miles |
|
From: Miles B. <mil...@gm...> - 2006-07-11 21:13:18
|
When trying to edit a feed 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 after the "Category" label in the edit feed screen. I noticed this when saw that update-quiet.php was not working. I have two feeds that are not parsing correctly and this is causing update-quiet to fail. So I wanted to change the option for those two and then came across the fatal error. -Miles |
|
From: Andrew T. <ajt...@hi...> - 2006-07-11 14:50:33
|
No, this is running on MySQL 4.something.
On 7/11/06, Kevin <ke...@dr...> wrote:
> Andrew Turner wrote:
> > So I finally migrated by daily FoFRedux to the newest SVN release (I
> > was old skool and just testing out the new releases on simple sets).
> > So I'm starting to run into some bugs:
> >
> >
> > When adding a category:
> >
> > 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 '('px_categories_id_seq')' at line 1] in
> > EXECUTE("select currval('px_categories_id_seq')")
> > Error performing database operation, Maybe you need to run the installer.
> > in /home/.parable/highearth/code.highearthorbit.com/public/fofredux/fofredux/lib/model/base.php
> > on line 251
> >
> >
> >
> What db type did you use? It's only supposed to execute that code for
> postgresql.
>
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> 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
|
5 messages has been excluded from this view by a project administrator.
