Hi,

I just installed Drupal with a PostgreSQL 8.1 backend, and was trying to install Tagadelic with it.

There is a fairly straightforward SQL validation that is failing with the error:

ERROR: column "d.vid" must appear in the GROUP BY clause or be used in an aggregate function

I have attached a patch, but you will need to review whether I have added d.vid into the correct place in the GROUP BY clause. It WFM for the moment, but without a lot of data in my site I can't be sure if it's correct :-)

Thanks,
Andrew McMillan.

CommentFileSizeAuthor
tagadelic.patch.txt774 byteskarora

Comments

Bèr Kessels’s picture

Bèr Kessels commented
Version: 4.7.x-1.x-dev » master

I am not PgSQL savvy enough to review this.

I would love people to test and review this patch.

Bèr Kessels’s picture

Bèr Kessels commented
Status: Needs review » Fixed

No feedback, but I investigated the issue and it breaks nothing in MySQL and seems to work on postgre. Hence I committed it to HEAD.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)