From 88490f6413ea2cfc667eb634c8a29478b89aa94e Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Thu, 9 Feb 2006 08:52:03 +0000
Subject: - Patch #47691 by Cvbge: quickfix postgresql

---
 modules/forum.module | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'modules/forum.module')

diff --git a/modules/forum.module b/modules/forum.module
index 1909a6e93..8e957fe74 100644
--- a/modules/forum.module
+++ b/modules/forum.module
@@ -708,7 +708,7 @@ function forum_get_forums($tid = 0) {
  * than NODE_NEW_LIMIT.
  */
 function _forum_topics_unread($term, $uid) {
-  $sql = 'SELECT COUNT(n.nid) FROM {node} n INNER JOIN {term_node} tn ON n.nid = tn.nid AND tn.tid = %d LEFT JOIN {history} h ON n.nid = h.nid AND h.uid = %d WHERE n.status = 1 AND n.type = "forum" AND n.created > %d AND h.nid IS NULL';
+  $sql = "SELECT COUNT(n.nid) FROM {node} n INNER JOIN {term_node} tn ON n.nid = tn.nid AND tn.tid = %d LEFT JOIN {history} h ON n.nid = h.nid AND h.uid = %d WHERE n.status = 1 AND n.type = 'forum' AND n.created > %d AND h.nid IS NULL";
   $sql = db_rewrite_sql($sql);
   return db_result(db_query($sql, $term, $uid, NODE_NEW_LIMIT));
 }
-- 
cgit v1.2.3