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.

CommentFileSizeAuthor
fbconnect-update-6200-pgsql.patch1008 bytesJohn Franklin
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

vectoroc’s picture

Issue tags: +6.x-2.1

commited