Changeset 7063

Timestamp:

May 9, 2008, 2:41:20 PM (15 years ago)

Author:

ebihara

Message:

#2377:キーワード指定のないトピック検索のトピック総数が取得できていなかったのを修正

File:

• OpenPNE/trunk/webapp/lib/db/commu.php (modified) (1 diff)

OpenPNE/trunk/webapp/lib/db/commu.php

@@ -3052 +3052 @@
     }
 
-    $sql = 'SELECT COUNT(c_commu_topic_id) FROM c_commu'
-         . ' AS c INNER JOIN c_commu_topic USING(c_commu_id)' . $where;
+    $sql = 'SELECT COUNT(ct.c_commu_topic_id) FROM c_commu'
+         . ' INNER JOIN c_commu_topic AS ct USING(c_commu_id)' . $where;
     $total_num = db_get_one($sql, $params);