Postgres is a little more strict when it comes to joins than MySQL is and the community tags module has some queries which are not valid in Postgres. The alterations are very simple; you just need to include all fields SELECTed in the JOIN clause.

I have attached a patch which changes the joins in the specified release; I think this is the standard syntax, so should work correctly under MySQL as well.

CommentFileSizeAuthor
#1 community_tags_postgres_group_by_fix.patch2.75 KBelyobo
join-clause-fix.patch2.17 KBelyobo

Comments

elyobo’s picture

elyobo commented
StatusFileSize
new community_tags_postgres_group_by_fix.patch2.75 KB

Sorry, badly formatted patch the first time... This patch is in the correct format.

elyobo’s picture

elyobo commented

Bump. This is a pretty simple SQL fix, the patch is already attached, any takers?

entrigan’s picture

entrigan commented

This will not change the query functionality at all?

entrigan’s picture

entrigan commented

committed

entrigan’s picture

entrigan commented
Status: Active » Fixed
elyobo’s picture

elyobo commented

No, it doesn't change the query functionality, Postgres just requires that all SELECTed fields be GROUPed as well. Thanks for getting this sorted :)

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.