diff options
| author | Angie Byron <webchick@24967.no-reply.drupal.org> | 2008-12-30 03:53:35 +0000 |
|---|---|---|
| committer | Angie Byron <webchick@24967.no-reply.drupal.org> | 2008-12-30 03:53:35 +0000 |
| commit | 0f3d0f2693fffe2f5904564b789100845117566f (patch) | |
| tree | bd030b6de82f3e8b6bc09fa862a8c02d3bf4a612 /modules/statistics/statistics.admin.inc | |
| parent | 5339dccdaadbc347da17beb5da188c5f57281a48 (diff) | |
| download | drupal-0f3d0f2693fffe2f5904564b789100845117566f.tar.gz drupal-0f3d0f2693fffe2f5904564b789100845117566f.zip | |
#229051 follow-up by anigma32: Committing rest of fix for statistics under pgsql.
Diffstat (limited to 'modules/statistics/statistics.admin.inc')
| -rw-r--r-- | modules/statistics/statistics.admin.inc | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/modules/statistics/statistics.admin.inc b/modules/statistics/statistics.admin.inc index 38733c1f5a9..7d359d616e9 100644 --- a/modules/statistics/statistics.admin.inc +++ b/modules/statistics/statistics.admin.inc @@ -83,7 +83,7 @@ function statistics_top_visitors() { ); $sql = "SELECT COUNT(a.uid) AS hits, a.uid, u.name, a.hostname, SUM(a.timer) AS total, bl.iid FROM {accesslog} a LEFT JOIN {blocked_ips} bl ON a.hostname = bl.ip LEFT JOIN {users} u ON a.uid = u.uid GROUP BY a.hostname, a.uid, u.name, bl.iid" . tablesort_sql($header); - $sql_cnt = "SELECT COUNT(DISTINCT(CONCAT(uid, hostname))) FROM {accesslog}"; + $sql_cnt = "SELECT COUNT(DISTINCT(CONCAT(CAST(uid AS char), hostname))) FROM {accesslog}"; $result = pager_query($sql, 30, 0, $sql_cnt); $rows = array(); |