diff options
| author | Dries Buytaert <dries@buytaert.net> | 2005-04-14 19:37:11 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2005-04-14 19:37:11 +0000 |
| commit | 1c83d517410a013aba23bb44e4620cff7d9e9824 (patch) | |
| tree | a2390c9798675bbc7be2a88e693e1108b93bc527 /modules/statistics | |
| parent | fa40f2446091575454de700024aa95aaad058d2c (diff) | |
| download | brdo-1c83d517410a013aba23bb44e4620cff7d9e9824.tar.gz brdo-1c83d517410a013aba23bb44e4620cff7d9e9824.tar.bz2 | |
- Patch by Adrian: postgresql fixes
Diffstat (limited to 'modules/statistics')
| -rw-r--r-- | modules/statistics/statistics.module | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/modules/statistics/statistics.module b/modules/statistics/statistics.module index 8261758bc..158d9f8fa 100644 --- a/modules/statistics/statistics.module +++ b/modules/statistics/statistics.module @@ -283,7 +283,7 @@ function statistics_top_users() { array('data' => t('User'), 'field' => 'u.name'), ); - $sql = "SELECT COUNT(a.uid) AS hits, a.uid, u.name FROM {accesslog} a LEFT JOIN {users} u ON a.uid = u.uid GROUP BY a.uid". tablesort_sql($header); + $sql = "SELECT COUNT(a.uid) AS hits, a.uid, u.name FROM {accesslog} a LEFT JOIN {users} u ON a.uid = u.uid GROUP BY a.uid, u.name". tablesort_sql($header); $sql_cnt = "SELECT COUNT(DISTINCT(uid)) FROM {accesslog}"; $result = pager_query($sql, 30, 0, $sql_cnt); |