By PMunn on

Hi folks, longtime PostgreSQL sufferer -er I mean user.

Attempting an upgrade from 6.20 to 7.0 I get the following errors on my PostgreSQL 9.0.2 database-based site:

user module
Update #7009
Failed: PDOException: SQLSTATE[42804]: Datatype mismatch: 7 ERROR: default for column "data" cannot be cast to type bytea: ALTER TABLE {users} ALTER "data" TYPE bytea USING "data"::bytea; Array ( ) in db_change_field() (line 2888 of /www/drupal/farbot-7.0/includes/database/database.inc).

system module
Update #7055
Failed: PDOException: SQLSTATE[42804]: Datatype mismatch: 7 ERROR: default for column "value" cannot be cast to type bytea: ALTER TABLE {variable} ALTER "value" TYPE bytea USING "value"::bytea; Array ( ) in db_change_field() (line 2888 of /www/drupal/farbot-7.0/includes/database/database.inc).

Any ideas on solutions for this one?

⋅ Categories: Drupal 7.x

Comments

borces’s picture

borces commented

Same problem and here.
Filed data in current user table is text type and value in variable table is varchar(128) type.
I try to change them to bytea type manually but again with out success.

dema502’s picture

dema502 commented

In modules/system/system.install

function system_update_7055() {

// db_change_field('variable', 'value', 'value', $spec);

db_add_field('variable', 'value1', $spec);
db_query("UPDATE {variable} SET value1=convert_to(value, 'UTF8');");
db_query("ALTER TABLE {variable} ALTER value1 SET NOT NULL;");
db_query("ALTER TABLE {variable} RENAME COLUMN value TO value2;");
db_query("ALTER TABLE {variable} RENAME COLUMN value1 TO value;");

greg.1.anderson’s picture

greg.1.anderson commented

http://drupal.org/node/1031122