Spaces_og's save() function uses an UPDATE query incompatible with postgresql (patch attached)
halcyonCorsair - October 1, 2009 - 03:48
| Project: | Spaces |
| Version: | 6.x-2.0-beta6 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
| Issue tags: | PostgeSQL |
Description
When you update a features public/private status in an og space, the UPDATE query uses INNER JOINs that fail with Postgresql.
| Attachment | Size |
|---|---|
| spaces_save_og2x_update_public.patch | 1.2 KB |
#1
Oops, add {}'s around table names.
also is their a reason you changed the form of the query so much?
from joins to a subquery?
miccolis: postgres doesn't like INNER JOINs in update queries
miccolis: hmm, i think i can rewrite it to use a FROM instead of the subselect to be in a similar form, but i don't think that would work with mysql
Ok, subselect is fine.
#2
Committed. I reimplemented the same query for OG 1.0 removing INNER JOINs and using a subselect as well.
http://drupal.org/cvs?commit=270346
#3
Automatically closed -- issue fixed for 2 weeks with no activity.