I'm on acquia drupal (core 6.8) with PostgreSQL

Error:

When installing the module the following errors occur

# warning: pg_query() [function.pg-query]: Query failed: ERROR: type modifier is not allowed for type "int_unsigned" at character 38 in /path/to/drupal/includes/database.pgsql.inc on line 139.
# user warning: query: CREATE TABLE ac_role_expire_4 ( uid int_unsigned(11) NOT NULL, expiry_timestamp varchar(255) NOT NULL ) in /path/to/drupal/includes/database.inc on line 515.
# warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "ac_role_expire_4" does not exist in /path/to/drupal/includes/database.pgsql.inc on line 139.
# user warning: query: CREATE INDEX ac_role_expire_4_uid_idx ON ac_role_expire_4 (uid) in /path/to/drupal/includes/database.inc on line 515.
# warning: pg_query() [function.pg-query]: Query failed: ERROR: type modifier is not allowed for type "int_unsigned" at character 38 in /path/to/drupal/includes/database.pgsql.inc on line 139.
# user warning: query: CREATE TABLE ac_role_expire_3 ( uid int_unsigned(11) NOT NULL, expiry_timestamp varchar(255) NOT NULL ) in /path/to/drupal/includes/database.inc on line 515.
# warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "ac_role_expire_3" does not exist in /path/to/drupal/includes/database.pgsql.inc on line 139.
# user warning: query: CREATE INDEX ac_role_expire_3_uid_idx ON ac_role_expire_3 (uid) in /path/to/drupal/includes/database.inc on line 515.
# warning: pg_query() [function.pg-query]: Query failed: ERROR: type modifier is not allowed for type "int_unsigned" at character 38 in /path/to/drupal/includes/database.pgsql.inc on line 139.
# user warning: query: CREATE TABLE ac_role_expire_5 ( uid int_unsigned(11) NOT NULL, expiry_timestamp varchar(255) NOT NULL ) in /path/to/drupal/includes/database.inc on line 515.
# warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "ac_role_expire_5" does not exist in /path/to/drupal/includes/database.pgsql.inc on line 139.
# user warning: query: CREATE INDEX ac_role_expire_5_uid_idx ON ac_role_expire_5 (uid) in /path/to/drupal/includes/database.inc on line 515.

Solution:

role_expire.install line 24
comment out // 'length' => 11,

role_expire.install line 70
comment out // 'length' => 11,

Reason is that unsigned int data type in postgreSQL does not allow type modifier to specify length.

It would still work in mySQL

CommentFileSizeAuthor
#1 role_expire-455406.patch643 bytesmikeryan

Comments

mikeryan’s picture

StatusFileSize
new643 bytes

It looks like the install hook was fixed, there's just one spot in an update function with the bogus int length.

stewsnooze’s picture

Status: Needs review » Fixed

Committed to CVS HEAD

Status: Fixed » Closed (fixed)

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