Download & Extend

Bug: column "pubdlcnt.nid" must appear in the GROUP BY

Project:Public Download Count
Version:6.x-1.0-beta5
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active

Issue Summary

just installed the module (beta-5) to a Drupal 6.18 site and got this:

warning: pg_query(): Query failed: ERROR: column "pubdlcnt.nid" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT name, nid, SUM(count) AS total, MAX(date) AS last FRO... ^ in /usr/share/drupal6/includes/database.pgsql.inc on line 139.
user warning: query: SELECT name, nid, SUM(count) AS total, MAX(date) AS last FROM pubdlcnt GROUP BY name ORDER BY total DESC LIMIT 100 OFFSET 0 in /etc/drupal/6/sites/all/modules/pubdlcnt/pubdlcnt.module on line 327.

nobody click here