[drupal-support] SQL error after upgrade to 4.5.2

[Erik Steffl]

just upgraded to 4.5.2 (debian unstable package), mostly using 
update.php script (I upgraded some stuff by hand, comparing my db 
structure to database.mysql), the db structure seems OK now (I checked 
it against database.mysql.

it seems to be mostly working, only see one problem, there's an error 
message on the top of the page (and no RSS feeds are working):

--------------- 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 
/usr/share/drupal/includes/database.mysql.inc on line 125.
--------------- cut here --------------

this is in the grey rectanlge on the top of the page (I don't think 
there wasany grey rectangle there befreo upgrade), I checked the SQL 
query and it seems to be OK, I tried it in mysql and it worked (got zero 
results but no complains about syntax).

mysql> desc aggregator_item;
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| iid         | int(10)      |      | PRI | NULL    | auto_increment |
| fid         | int(10)      |      |     | 0       |                |
| title       | varchar(255) |      |     |         |                |
| link        | varchar(255) |      |     |         |                |
| author      | varchar(255) |      |     |         |                |
| description | longtext     | YES  |     | NULL    |                |
| timestamp   | int(11)      | YES  |     | NULL    |                |
+-------------+--------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

   this is what I get in the log (I get one for each access, no matter 
which page/link):

Type	error
Date	Monday, 2005, February 7 - 4:45pm
User	admin
Location	/drupal/?q=admin&from=2650
Message	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 
/usr/share/drupal/includes/database.mysql.inc on line 125.
Hostname	207.126.234.69

   any ideas what went wrong or at least how to debug this further?

	erik