Re: SQL error after upgrade to 4.5.2

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
--
[ Drupal support list | http://lists.drupal.org/ ]