Installing Brilliant Gallery version 6.x-3.0 on Drupal 6.10 with PHP 5.2.6, Postgresql 8.3.6, on Fedora Core 10 (using tarfile install rather than RPM install of drupal).

During installation of the Brilliant Gallery module, I noticed a query failed:

Message query: CREATE TABLE brilliant_gallery_checklist ( nid int_unsigned NOT NULL default 0, user int_unsigned NOT NULL default 0, qid text NOT NULL, state int_unsigned NOT NULL default 0, PRIMARY KEY (nid, user, Array) ) in /var/www/html/includes/database.inc on line 515.

I ran psql as my drupal user to re-run the query and noticed it was complaining about the user column. It turns out, this is a reserved word in postgresql. A list of postgreql reserved words is here:
http://www.postgresql.org/docs/current/static/sql-keywords-appendix.html

Assistance and advice on this is much appreciated. Thank you.

Comments

szeder’s picture

szeder CreditAttribution: szeder commented
Version: 6.x-3.0 » 6.x-3.4
Assigned: Unassigned » szeder
Priority: Normal » Critical

I have the same trouble on version 6.x-3.4

And, it must be PRIMARY KEY (nid, user )
instead of PRIMARY KEY (nid, user, Array)
i guess.

Thanks.

c0mputerking’s picture

c0mputerking CreditAttribution: c0mputerking commented

I have similar problem but I am using mysql and drupal version 6.13 also created an issue here http://drupal.org/node/529402