On installation of the quotes module (Drupal 6.19, Postgresql 8.1.21) I get the following error, and the quotes_author table is not created:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "Array" at character 157 in /var/www/drupal-6.19/includes/database.pgsql.inc on line 139.
* user warning: query: CREATE TABLE quotes_authors ( aid serial CHECK (aid >= 0), name text NOT NULL, bio text, PRIMARY KEY (aid), CONSTRAINT quotes_authors_name_key UNIQUE (Array) ) in /var/www/drupal-6.19/includes/database.inc on line 555.

I believe the problem arises in quotes.install, line 218

'unique keys' => array(
'name' => array(array('name', 255)),
),

Changing this to

'unique keys' => array(
'unique_name' => array('name'),
),

seems to work.

Comments

nancydru’s picture

Status: Active » Fixed

Thanks. Committed to 6.1-1.x-dev.

Status: Fixed » Closed (fixed)

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