diff options
| author | Dries Buytaert <dries@buytaert.net> | 2005-05-07 21:53:20 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2005-05-07 21:53:20 +0000 |
| commit | 74d614c9f009899086184d3e363ffa6bd22c0470 (patch) | |
| tree | b41cb256698ea352d1e2c0d3d1f46b110ea434cb /modules/statistics | |
| parent | 39d0fe9a3882f26ff1abe2bca2c28f94b0a8cec0 (diff) | |
| download | brdo-74d614c9f009899086184d3e363ffa6bd22c0470.tar.gz brdo-74d614c9f009899086184d3e363ffa6bd22c0470.tar.bz2 | |
- Patch #22264 by patryk: made a SQL query PostgreSQL compliant. Thanks Patryk.
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 6161b6cb9..60991eff8 100644 --- a/modules/statistics/statistics.module +++ b/modules/statistics/statistics.module @@ -252,7 +252,7 @@ function statistics_recent_hits($type = 'all', $id = 0) { * Menu callback; presents the "Top pages" page. */ function statistics_top_pages() { - $sql = "SELECT COUNT(path) AS hits, path, title FROM {accesslog} GROUP BY path"; + $sql = "SELECT COUNT(path) AS hits, path, title FROM {accesslog} GROUP BY path, title"; $sql_cnt = "SELECT COUNT(DISTINCT(path)) FROM {accesslog}"; $header = array( |