Incorrect use of " in sql query
nbulat - February 28, 2007 - 14:13
| Project: | DruTeX |
| Version: | HEAD |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Steven Jones |
| Status: | closed |
Jump to:
Description
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.
#1
I don't think that DruTeX has the Postgres create table statements in it's install file. I will look at adding this.
#2
I wasn't even able to find an .install file...
#3
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
#4
Thank you.
#5