Closed (fixed)
Project:
Role Expire
Version:
6.x-1.1
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
6 May 2009 at 15:58 UTC
Updated:
8 Oct 2009 at 09:30 UTC
Jump to comment: Most recent file
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
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | role_expire-455406.patch | 643 bytes | mikeryan |
Comments
Comment #1
mikeryanIt looks like the install hook was fixed, there's just one spot in an update function with the bogus int length.
Comment #2
stewsnoozeCommitted to CVS HEAD