The statistics module seems to be relying on the MySQL facility whereby a column in a SELECT list, not referenced in a GROUP BY clause outputs the last value seen for that column within the groupings of the other fields. Postgres does not have this facility and instead rejects the query as invalid SQL.

Therefore, the select clauses which are retrieving the data for the individual sub pages under admin/log/hits all fail in Postgres.

CommentFileSizeAuthor
#1 statistics.patch02.98 KBAlanChandler
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

AlanChandler’s picture

FileSize
2.98 KB

I have included a patch to solve the problem - although it changes the functionality a bit (hence the new titles to the columns).

I can't easily see how to do the original functionality with valid SQL - but then I am no expert.

adrian’s picture

Assigned: Unassigned » vertice@www.drop.org

I havent had time to look at this properly, but i am assigning this to myself.

Dries’s picture

I committed this to HEAD. Thanks Alan.

Adrian: if the fix isn't right, please re-open this bug report and attach a proper patch.

Anonymous’s picture