From 7b716e8e770faa6c85a4123db729505bb251df27 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Wed, 8 Sep 2004 15:38:26 +0000 Subject: - Patch #10622 by Adrian: fixes various PostgreSQL related problems. 1) Menu problems with Postgres (this is a highly critical 1 line fix) 2) Archive module fails with Postgres 3) Postgres setup problems - changes to database.pgsql (although i made these changes myself before finding this patch) 4) Book module fails with Postgres 5) Postgres problems following creation of a new type of user - which is actually about a taxonomy.module bug. 6) Creating accregator_item_table in PostgreSQL 7) Postgres - Polls not displayed on Poll Page 8) Blog module has sql errors with postgres This should not affect MySQL users (hopefully). --- modules/archive/archive.module | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'modules/archive/archive.module') diff --git a/modules/archive/archive.module b/modules/archive/archive.module index 57bea3419..abc8148ad 100644 --- a/modules/archive/archive.module +++ b/modules/archive/archive.module @@ -253,7 +253,7 @@ function archive_page($year = 0, $month = 0, $day = 0) { if ($year && $month && $day) { // Fetch nodes for the selected date, if one was specified. - $result = db_query_range('SELECT DISTINCT(n.nid) FROM {node} n '. node_access_join_sql() .' WHERE n.status = 1 AND n.created > %d AND n.created < %d AND '. node_access_where_sql() .' ORDER BY n.created', $date, $date_end, 0, 20); + $result = db_query_range('SELECT DISTINCT(n.nid), n.created FROM {node} n '. node_access_join_sql() .' WHERE n.status = 1 AND n.created > %d AND n.created < %d AND '. node_access_where_sql() .' ORDER BY n.created', $date, $date_end, 0, 20); while ($nid = db_fetch_object($result)) { $output .= node_view(node_load(array('nid' => $nid->nid)), 1); -- cgit v1.2.3