diff options
| author | Dries Buytaert <dries@buytaert.net> | 2007-02-28 20:42:50 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2007-02-28 20:42:50 +0000 |
| commit | 7f4e49016ab35afc0fa27a495b395c67507ada74 (patch) | |
| tree | 981ad635bdf9316abda987cc712081e4cc76aabc | |
| parent | 972d4f8de7d4725d405a2ca4f4d32a56dc4f26e9 (diff) | |
| download | brdo-7f4e49016ab35afc0fa27a495b395c67507ada74.tar.gz brdo-7f4e49016ab35afc0fa27a495b395c67507ada74.tar.bz2 | |
- Patch #122824 by PMunn: fixed SQL query to be compatible with PostgreSQL.
| -rw-r--r-- | modules/forum/forum.module | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/modules/forum/forum.module b/modules/forum/forum.module index 15da94ece..09e0242bd 100644 --- a/modules/forum/forum.module +++ b/modules/forum/forum.module @@ -263,7 +263,7 @@ function forum_block($op = 'list', $delta = 0, $edit = array()) { switch ($delta) { case 0: $title = t('Active forum topics'); - $sql = db_rewrite_sql("SELECT n.nid, n.title, l.comment_count FROM {node} n INNER JOIN {node_comment_statistics} l ON n.nid = l.nid WHERE n.status = 1 AND n.type = 'forum' ORDER BY l.last_comment_timestamp DESC"); + $sql = db_rewrite_sql("SELECT n.nid, n.title, l.comment_count, l.last_comment_timestamp FROM {node} n INNER JOIN {node_comment_statistics} l ON n.nid = l.nid WHERE n.status = 1 AND n.type = 'forum' ORDER BY l.last_comment_timestamp DESC"); $result = db_query_range($sql, 0, variable_get('forum_block_num_0', '5')); if (db_num_rows($result)) { $content = node_title_list($result); |