From 95a84de389d16ed68d360b86600f5f36d577affc Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Thu, 31 May 2007 11:56:12 +0000 Subject: - Patch #147761 by ChrisKennedy: SQL bugfix. --- modules/dblog/dblog.module | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'modules') diff --git a/modules/dblog/dblog.module b/modules/dblog/dblog.module index f2a369709..f9e918154 100644 --- a/modules/dblog/dblog.module +++ b/modules/dblog/dblog.module @@ -196,7 +196,7 @@ function dblog_top($type) { array('data' => t('Message'), 'field' => 'message') ); - $result = pager_query("SELECT COUNT(wid) AS count, message, variables FROM {watchdog} WHERE type = '%s' GROUP BY (message, variables) ". tablesort_sql($header), 30, 0, "SELECT COUNT(DISTINCT(message)) FROM {watchdog} WHERE type = '%s'", $type); + $result = pager_query("SELECT COUNT(wid) AS count, message, variables FROM {watchdog} WHERE type = '%s' GROUP BY message, variables ". tablesort_sql($header), 30, 0, "SELECT COUNT(DISTINCT(message)) FROM {watchdog} WHERE type = '%s'", $type); $rows = array(); while ($dblog = db_fetch_object($result)) { -- cgit v1.2.3