I tried to install this module with a Postgres DB and it fails to create the table faq_weights

I think the reason is that in faq.install in the sql expression that creates the table the part "DEFAULT 0" should be written as "DEFAULT '0' ", I compared this install file with others and there it was written like this. You have to replace the single quotes around the sql expression by double quotes in order to do this.

HTH

Comments

jensKhmerOS’s picture

jensKhmerOS commented
Title: installation with postgres db fails » installation with postgres db fails, correction

sorry my report was wrong.
The real reason why the creation fails is the word UNSIGNED in the sql statement. After I removed this it worked well.

But reading the code I wonder why for mysql for the field wight a small integer is used but for postgres not?

stella’s picture

stella commented
Assigned: Unassigned » stella

fixed in CVS, will be included in the next release.

stella’s picture

stella commented
Status: Active » Closed (fixed)

released in faq 5.x-2.2