diff options
author | Dries Buytaert <dries@buytaert.net> | 2010-01-26 08:19:45 +0000 |
---|---|---|
committer | Dries Buytaert <dries@buytaert.net> | 2010-01-26 08:19:45 +0000 |
commit | 420c27c4892ab5a0a9009f0006786bd5e7c0a787 (patch) | |
tree | b479680662b6c017f0cd09291f030cbf06437698 /modules/statistics | |
parent | 6cb277926fbfbe2b7f0308710a8a9a5b18abb074 (diff) | |
download | brdo-420c27c4892ab5a0a9009f0006786bd5e7c0a787.tar.gz brdo-420c27c4892ab5a0a9009f0006786bd5e7c0a787.tar.bz2 |
- Patch #229051 by Josh Waihi, bellHead, ainigma32, Dave Reid, druido, ivanSB@drupal.org, jaydub: fixed 'Top visitor' page on PostgreSQL 8.3.
Diffstat (limited to 'modules/statistics')
-rw-r--r-- | modules/statistics/statistics.admin.inc | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/modules/statistics/statistics.admin.inc b/modules/statistics/statistics.admin.inc index 72485ab88..303eafa44 100644 --- a/modules/statistics/statistics.admin.inc +++ b/modules/statistics/statistics.admin.inc @@ -118,8 +118,10 @@ function statistics_top_visitors() { ->limit(30) ->orderByHeader($header); - $count_query = db_select('accesslog'); - $count_query->addExpression('COUNT(DISTINCT CONCAT(CAST(uid AS char), hostname))'); + $uniques_query = db_select('accesslog')->distinct(); + $uniques_query->fields('accesslog', array('uid', 'hostname')); + $count_query = db_select($uniques_query); + $count_query->addExpression('COUNT(*)'); $query->setCountQuery($count_query); $result = $query->execute(); |