From 20295998e7a14ff708a33572e860e0587aaa82c3 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Tue, 2 Dec 2008 21:24:34 +0000 Subject: - Patch #296624 by Damien Tournoud: made search work on PostgreSQL. --- 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 d3f327bbc..a72100743 100644 --- a/modules/comment/comment.module +++ b/modules/comment/comment.module @@ -2117,7 +2117,7 @@ function comment_ranking() { 'title' => t('Number of comments'), 'join' => 'LEFT JOIN {node_comment_statistics} node_comment_statistics ON node_comment_statistics.nid = i.sid', // Inverse law that maps the highest reply count on the site to 1 and 0 to 0. - 'score' => '2.0 - 2.0 / (1.0 + node_comment_statistics.comment_count * %f)', + 'score' => '2.0 - 2.0 / (1.0 + node_comment_statistics.comment_count * CAST(%f AS DECIMAL))', 'arguments' => array(variable_get('node_cron_comments_scale', 0)), ), ); -- cgit v1.2.3