From cadd9bd54ca9b3e5a95661c616d35a1a0045ab46 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Wed, 3 Dec 2008 16:32:22 +0000
Subject: - Patch #335086 by recidive: rename node, filter and comment module
 tables to singular for consistency.  Oh my.

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

(limited to 'modules/blogapi/blogapi.module')

diff --git a/modules/blogapi/blogapi.module b/modules/blogapi/blogapi.module
index db7f01ddc..6ada341c3 100644
--- a/modules/blogapi/blogapi.module
+++ b/modules/blogapi/blogapi.module
@@ -379,7 +379,7 @@ function blogapi_blogger_get_recent_posts($appkey, $blogid, $username, $password
   }
 
   if ($bodies) {
-    $result = db_query_range("SELECT n.nid, n.title, r.body, r.format, n.comment, n.created, u.name FROM {node} n, {node_revisions} r, {users} u WHERE n.uid = u.uid AND n.vid = r.vid AND n.type = :type AND n.uid = :uid ORDER BY n.created DESC",  array(
+    $result = db_query_range("SELECT n.nid, n.title, r.body, r.format, n.comment, n.created, u.name FROM {node} n, {node_revision} r, {users} u WHERE n.uid = u.uid AND n.vid = r.vid AND n.type = :type AND n.uid = :uid ORDER BY n.created DESC",  array(
       ':type' => $blogid,
       ':uid' => $user->uid
     ), 0, $number_of_posts);
-- 
cgit v1.2.3