From 1cd3b7a01fb7cce8c7969affc941c35c3ee33e4f Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Mon, 23 Apr 2007 17:04:34 +0000 Subject: - Patch #128600 by scott.mclewin and spatz4000: ambigious field use in SQL query. --- modules/blog/blog.module | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/modules/blog/blog.module b/modules/blog/blog.module index ff61ba998..ca6ffb0d3 100644 --- a/modules/blog/blog.module +++ b/modules/blog/blog.module @@ -150,7 +150,7 @@ function blog_page_user($uid) { $output = ''; } - $result = pager_query(db_rewrite_sql("SELECT n.nid, n.sticky, n.created FROM {node} n WHERE type = 'blog' AND n.uid = %d AND n.status = 1 ORDER BY n.sticky DESC, n.created DESC"), variable_get('default_nodes_main', 10), 0, NULL, $account->uid); + $result = pager_query(db_rewrite_sql("SELECT n.nid, n.sticky, n.created FROM {node} n WHERE n.type = 'blog' AND n.uid = %d AND n.status = 1 ORDER BY n.sticky DESC, n.created DESC"), variable_get('default_nodes_main', 10), 0, NULL, $account->uid); while ($node = db_fetch_object($result)) { $output .= node_view(node_load($node->nid), 1); } -- cgit v1.2.3