From 45f4bcaa7d379df9c6b4ee748f8ebdb8a49478bd Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Tue, 27 Sep 2005 18:34:59 +0000 Subject: - Patch #26031 by leafish_dylan: fixed comment pager (broken SQL query). --- modules/comment/comment.module | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'modules/comment/comment.module') diff --git a/modules/comment/comment.module b/modules/comment/comment.module index 3e26e24a7..854a9bf59 100644 --- a/modules/comment/comment.module +++ b/modules/comment/comment.module @@ -906,7 +906,7 @@ function comment_render($node, $cid = 0) { } // Start a form, for use with comment control and moderation. - $result = pager_query($query, $comments_per_page, 0, "SELECT COUNT(*) FROM {comments} WHERE status = %d AND nid = %d", $nid, COMMENT_PUBLISHED); + $result = pager_query($query, $comments_per_page, 0, "SELECT COUNT(*) FROM {comments} WHERE nid = %d AND status = %d" , $nid, COMMENT_PUBLISHED); if (db_num_rows($result) && (variable_get('comment_controls', 3) == 0 || variable_get('comment_controls', 3) == 2)) { $output .= '
\n"; $output .= theme('comment_controls', $threshold, $mode, $order, $comments_per_page); -- cgit v1.2.3