Re: [Fofredux-devel] Problem with my database and 0.4-dev

[Kevin <ke...@dr...>]

This was fixed quite a while ago. (see log below)   Is upgrading to a 
newer snapshot an option?.

-Kevin

------------------------------------------------------------------------
r514 | kevbob | 2006-08-29 09:58:27 -0600 (Tue, 29 Aug 2006) | 2 lines
Changed paths:
   M /fofredux/trunk/init.php

fix sql error during item purge when item id exclusion list is empty
------------------------------------------------------------------------




Miles Beck wrote:
> I'm having a problem with my installation of FoFRedux. I noticed quite
> a few feeds had not been updated in hours. So I did a manual Update
> All from the panel view and then I got 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 ') AND cache_time < '2006-12-13 17:40:23' AND
> i.flag = 1 ) ORDER BY i.id , i.i' at line 17] in EXECUTE("SELECT i.id,
> i.flag as item_read, f.title as feed_title, f.link as feed_link, f.id
> as feed_id, i.link as item_link, i.title as item_title, i.flag,
> i.cache_time, i.content, i.publish_time, i.dccreator, i.latitude,
> i.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 = cat.id) JOIN fr_items i ON (i.feed_id = f.id)
> WHERE ( feed_id = 79 AND i.id NOT IN ( ) AND cache_time < '2006-12-13
> 17:40:23' AND i.flag = 1 ) ORDER BY i.id , i.id ")
> Error performing database operation,
> /fofredux_0.4-dev/lib/model/base.php on line 251
>
> Anyone have an idea how I can fix this?
>
> -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
>