diff options
author | Dries Buytaert <dries@buytaert.net> | 2004-09-08 15:38:26 +0000 |
---|---|---|
committer | Dries Buytaert <dries@buytaert.net> | 2004-09-08 15:38:26 +0000 |
commit | 7b716e8e770faa6c85a4123db729505bb251df27 (patch) | |
tree | c82f8a297bf8a76172e1d71892c4507c3606bad2 /modules/archive.module | |
parent | e1d7609710db3bd984ab8c8b1e78469e07f4f135 (diff) | |
download | brdo-7b716e8e770faa6c85a4123db729505bb251df27.tar.gz brdo-7b716e8e770faa6c85a4123db729505bb251df27.tar.bz2 |
- 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).
Diffstat (limited to 'modules/archive.module')
-rw-r--r-- | modules/archive.module | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/modules/archive.module b/modules/archive.module index 57bea3419..abc8148ad 100644 --- a/modules/archive.module +++ b/modules/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); |