There's four queries in spaces.module that have bad quoting, which may work in mysql, but certainly does not in Postgres (double quotes being used to escape column names).

      $result = db_query('SELECT id, value FROM {spaces_features} WHERE sid = %d AND type = "%s" ORDER BY weight ASC', $sid, $type);
      $result = db_query('SELECT id, value FROM {spaces_settings} WHERE sid = %d AND type = "%s"', $sid, $type);
        db_query('INSERT INTO {spaces_features} (sid, type, id, value, weight) VALUES (%d, "%s", "%s", "%s", %d)', $values);
        db_query('INSERT INTO {spaces_settings} (sid, type, id, value) VALUES (%d, "%s", "%s", "%s")', $values);

In all cases, those single and double quotes should be swapped. The other queries in the module are fine. This appears in the 1.x branch as well, which is where I originally noticed it.

I'd roll a patch, but I quickly went down a rabbit hole trying to sync up the dev versions of context and spaces.

Comments

yhahn’s picture

Assigned: Unassigned » yhahn

Thanks! I've committed fixes to both branches -- let me know if this works for you on Postgres.

http://drupal.org/cvs?commit=193684

stormsweeper’s picture

I've made manual edits to the 1.0-alpha4 release and it seems to be working fine. I unfortunately don't have the time to try to muck about with the 2.0 alphas just now.

yhahn’s picture

Status: Active » Fixed

Closing for now.

Status: Fixed » Closed (fixed)

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