diff options
| author | Dries Buytaert <dries@buytaert.net> | 2007-05-31 11:56:12 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2007-05-31 11:56:12 +0000 |
| commit | 95a84de389d16ed68d360b86600f5f36d577affc (patch) | |
| tree | cdf61cb5e55f2336b4c4adc79563d8c31464bc65 /modules/dblog | |
| parent | 97a09cb9980cb4247dd9c339e8c7819a00093e61 (diff) | |
| download | brdo-95a84de389d16ed68d360b86600f5f36d577affc.tar.gz brdo-95a84de389d16ed68d360b86600f5f36d577affc.tar.bz2 | |
- Patch #147761 by ChrisKennedy: SQL bugfix.
Diffstat (limited to 'modules/dblog')
| -rw-r--r-- | modules/dblog/dblog.module | 2 |
1 files changed, 1 insertions, 1 deletions
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)) { |