Attempting to update to the latest version fails on PostgreSQL based systems because the SQL uses double-quotes where it should use single-quotes and place quotes around a varchar constant. The error produced is:
Executing fbconnect_update_6200 [success]
WD php: pg_query(): Query failed: ERROR: column "fbconnect_invite" does [error]
not exist
LINE 1: UPDATE blocks SET module = "fbconnect_invite" WHERE module =...
^ in
/usr/share/drupal6/includes/database.pgsql.inc on line 139.
WD php: [error]
query: UPDATE blocks SET module = "fbconnect_invite" WHERE module =
"fbconnect" AND delta = 0 in
/etc/drupal/6/sites/example.org/modules/fbconnect/fbconnect.install
on line 162.
UPDATE {variable} SET name = 'fbconnect_appid' WHERE name = [success]
'fbconnect_key'
UPDATE {blocks} SET module = "fbconnect_invite" WHERE module = [error]
"fbconnect" AND delta = 0
pg_query(): Query failed: ERROR: column "fbconnect_invite" does not exist [warning]
LINE 1: UPDATE blocks SET module = "fbconnect_invite" WHERE module =...
^ in
/usr/share/drupal6/includes/database.pgsql.inc on line 139.
[error]
query: UPDATE blocks SET module = "fbconnect_invite" WHERE module
= "fbconnect" AND delta = 0 in
/etc/drupal/6/sites/example.org/modules/fbconnect/fbconnect.install
on line 162.
Apply the attached patch to fix the errors.
| Comment | File | Size | Author |
|---|---|---|---|
| fbconnect-update-6200-pgsql.patch | 1008 bytes | john franklin |
Comments
Comment #1
vectoroc commentedcommited