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.
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | community_tags_postgres_group_by_fix.patch | 2.75 KB | elyobo |
| join-clause-fix.patch | 2.17 KB | elyobo |
Comments
Comment #1
elyobo commentedSorry, badly formatted patch the first time... This patch is in the correct format.
Comment #2
elyobo commentedBump. This is a pretty simple SQL fix, the patch is already attached, any takers?
Comment #3
entrigan commentedThis will not change the query functionality at all?
Comment #4
entrigan commentedcommitted
Comment #5
entrigan commentedComment #6
elyobo commentedNo, it doesn't change the query functionality, Postgres just requires that all SELECTed fields be GROUPed as well. Thanks for getting this sorted :)