Posted by elyobo on November 1, 2009 at 1:51am
| Project: | Community Tags |
| Version: | 6.x-1.0-beta2 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
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.
| Attachment | Size |
|---|---|
| join-clause-fix.patch | 2.17 KB |
Comments
#1
Sorry, badly formatted patch the first time... This patch is in the correct format.
#2
Bump. This is a pretty simple SQL fix, the patch is already attached, any takers?
#3
This will not change the query functionality at all?
#4
committed
#5
#6
No, it doesn't change the query functionality, Postgres just requires that all SELECTed fields be GROUPed as well. Thanks for getting this sorted :)
#7
Automatically closed -- issue fixed for 2 weeks with no activity.