Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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 CreditAttribution: vectoroc commentedcommited