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
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.
Maybe you db update didn't work out.
Cheers, Gerhard
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
On Tue, 8 Feb 2005, Erik Steffl wrote:
Gerhard Killesreiter wrote:
$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
Probably.
should I just delete and re-create the feeds?
That is what I'd try.
Cheers, Gerhard
Gerhard Killesreiter wrote:
On Tue, 8 Feb 2005, Erik Steffl wrote:
Gerhard Killesreiter wrote:
$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
Probably.
should I just delete and re-create the feeds?
That is what I'd try.
wow, deleted them and now I have 3 same error messages on the top, while there are no record in any of the aggregator_* tables.
I added slashot.org again and I still get three error messages on the top and also three block on the right, each empty with 'More' link which goes to slashdot aggregator.
after that I went to block configuration and that seems to have fixed the problem, no more error messages and the news aggregator block is displayed properly (the aggregator_* tables content is unchanged so I guess that wasn't a problem, looks like it had something to do with blocks).
erik
-
Erik Steffl -
Gerhard Killesreiter