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