[drupal-support] SQL error after upgrade to 4.5.2

[Erik Steffl]

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