Can't configure drutex input format. I'm getting folowing error message:

warning: pg_query() [function.pg-query]: Query failed: ERROR: column "drutex" does not exist in /var/www/localhost/htdocs/includes/database.pgsql.inc on line 125.

Apparently, column drutex is missing from database, but nothing is mentioned about database in the installation instructions.

Comments

steven jones’s picture

steven jones commented
Title: DruTeX with postgresql malfunction » Add Postgres support at install time
Assigned: nbulat » steven jones
Category: support » feature

I don't think that DruTeX has the Postgres create table statements in it's install file. I will look at adding this.

Gertje’s picture

Gertje commented

I wasn't even able to find an .install file...

Gertje’s picture

Gertje commented

I figured it out..
The in select statement on line 593 in drutex.module the double quotes on drutex isn't according to the SQL standard. MySQL doesn't matter though Postgres does... I simply changed it to:

$result = db_query('SELECT format from {filters} WHERE module = \'drutex\'');

Cheers

steven jones’s picture

steven jones commented
Title: Add Postgres support at install time » Incorrect use of " in sql query
Category: feature » bug
Priority: Normal » Critical
Status: Active » Fixed

Thank you.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)