Gerhard Killesreiter wrote:
On Mon, 7 Feb 2005, Erik Steffl wrote:
--------------- cut here -------------- user 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 '' at line 1 query: SELECT * FROM aggregator_item WHERE fid = 0 ORDER BY timestamp DESC, iid DESC LIMIT 0, in
^^^ There should be another number, like 20.$result = db_query_range('SELECT * FROM {aggregator_item} WHERE fid = %d ORDER BY timestamp DESC, iid DESC', $feed->fid, 0, $feed->block);
$feed->block does not seem to be set.
looks like it's zero in database, should it be something else? Or should I just delete and re-create the feeds?
mysql> select fid, block from aggregator_feed; +-----+-------+ | fid | block | +-----+-------+ | 1 | 0 | | 3 | 0 | +-----+-------+ 2 rows in set (0.00 sec)
erik