Get the following warnings after installing the module.

* warning: pg_query() [function.pg-query]: Query failed: ERROR: column "admin/build/modules/list" does not exist LINE 1: ...FROM feed_path_publisher WHERE path_prefix = LEFT("admin/bui... ^ in /var/blahblah/trunk/www/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT title, feed, fppid FROM feed_path_publisher WHERE path_prefix = LEFT("admin/build/modules/list", LENGTH(path_prefix)) OR path_prefix = LEFT("admin/build/modules/list", LENGTH(path_prefix)) OR path_prefix = LEFT("admin/build/modules/list", LENGTH(path_prefix)) ORDER BY weight, path_prefix in /var/blahblah/trunk/modules/feed_path_publisher/feed_path_publisher.module on line 55.

Running Drupal6 with Postgres 8.3.7

Comments

todd nienkerk’s picture

todd nienkerk commented

@emackn: Unfortunately, I don't know much at all about Postgres. Cany ou advise?

beasley’s picture

beasley commented

I get the same on Postgres and D6.

mradcliffe’s picture

mradcliffe
he/him
Primary language English
commented

"Left" is not a valid function in PostgreSQL. PostgreSQL has the standard substr function. SQLite also has the substr function. MySQL also has the substr function.

However it might not be wise to rely on any function as you don't know how different database drivers (chx and his mongodb) might use it syntax-wise.