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/taxonomy.module | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'modules/taxonomy.module') diff --git a/modules/taxonomy.module b/modules/taxonomy.module index a358814f0..5ed419e3a 100644 --- a/modules/taxonomy.module +++ b/modules/taxonomy.module @@ -77,7 +77,7 @@ function taxonomy_block($op = 'list', $delta = 0) { return $blocks; } else if (user_access('access content')) { - $result = db_query("SELECT d.tid, d.name, MAX(n.created) AS updated, COUNT(*) AS count FROM {term_data} d INNER JOIN {term_node} USING (tid) INNER JOIN {node} n USING (nid) WHERE n.status = 1 GROUP BY d.tid ORDER BY updated DESC, d.name"); + $result = db_query("SELECT d.tid, d.name, MAX(n.created) AS updated, COUNT(*) AS count FROM {term_data} d INNER JOIN {term_node} USING (tid) INNER JOIN {node} n USING (nid) WHERE n.status = 1 GROUP BY d.tid, d.name ORDER BY updated DESC, d.name"); $items = array(); while ($category = db_fetch_object($result)) { $items[] = l("$category->name ($category->count)", 'taxonomy/term/'. $category->tid) .'
'. format_interval(time() - $category->updated) .' '. t('ago'); -- cgit v1.2.3