Re: [Fofredux-devel] Error after deleting a feed

[Evan R. <eva...@gm...>]

that SQL is good on my side when i run it in phpmyadmin.  returning no
results (nothing unread) but not dying on me at least.

what version of mysql are you on?
obviously the error is getting thrown, since the recordset is not
created...thus no object.  in other words, we could beef up error handling
here as well.

/evan

On 5/18/06, Miles Beck <mil...@gm...> wrote:
>
> On 5/18/06, Kevin <ke...@dr...> wrote:
> > Okay, so this is the queries that happen on the panel/index page.  Try
> > hitting a link for unread items on a feed.  What are the queries/errors
> > when view.php is run.
>
> This was all before the links box.
>
> (mysql): SELECT name, value FROM fr_config
> Error (0):
>
> (mysql): select url, title, link, id, category_id, latitude,
> longitude, auto_tag, update_enabled, last_update from fr_feeds where
> id =3D '2'
> Error (0):
>
> Warning: Cannot modify header information - headers already sent by
> (output started at
> /var/www/fofredux_0.4-dev/adodb_lite/adodb.inc.php:307) in
> /var/www/fofredux_0.4-dev/header.php on line 83
>
> Between the search dialog and the Old to New link was the following error=
:
> (mysql): SELECT i.flag as item_read, f.title as feed_title, f.link as
> feed_link, i.id as item_id, i.link as item_link, i.title as
> item_title, i.cache_time, i.content as item_content, i.publish_time,
> i.dccreator as dccreator, i.dcsubject as dcsubject, i.latitude as
> latitude, i.longitude as longitude, cat.id as category_id, cat.title
> as category_title, i.enclosure_link as enclosure_link,
> i.enclosure_type as enclosure_type, f.url as feed_url FROM fr_feeds f
> JOIN fr_categories cat ON (f.category_id =3D cat.id) JOIN fr_items i ON
> (i.feed_id =3D f.id) WHERE 1 =3D 1 AND f.id =3D '2' AND (i.flag is NULL O=
R
> i.flag =3D 0) order by i.publish_time desc, i.id desc LIMIT 0,
> Error (1064): 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 '' at line 1
>
> And lastly the following error:
> Fatal error: Call to a member function on a non-object in
> /var/www/fofredux_0.4-dev/view.php on line 83
>
>
> -------------------------------------------------------
> 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 Geronim=
o
> http://sel.as-us.falkag.net/sel?cmdlnk&kid=120709&bid&3057&dat=121642
> _______________________________________________
> Fofredux-devel mailing list
> Fof...@li...
> https://lists.sourceforge.net/lists/listinfo/fofredux-devel
>