Hi,

Just trying out this module, and it doesn't work very well with Postgres 8.3.

In much of the SQL, the queries have double-quotes in them. Postgres uses double-quotes for field names, so results in errors like:

warning: pg_query() [function.pg-query]: Query failed: ERROR: column "08e92c62-6a07-7c84-d970-2b67a5a00bf9" does not exist at character 46 in /var/vhost/drupal/drupal-6.19/includes/database.pgsql.inc on line 139.
user warning: query: SELECT vid FROM uuid_vocabulary WHERE uuid = "08e92c62-6a07-7c84-d970-2b67a5a00bf9" in modules/uuid_features/uuid_features.module on line 100.

Errors like the above were appearing whenever I clicked a term to include in my feature. It also resulted it no terms being included in the example.features.uuid_term.inc file.

The solution I think would be to enclose the queries in double-quotes and then use single quotes for strings. I don't think that'll affect mysql.

CommentFileSizeAuthor
#1 uuid_features.1281006.patch3.27 KBmaikeru

Comments

maikeru’s picture

StatusFileSize
new3.27 KB

Attached a diff patch against alpha1.

acbramley’s picture

Status: Active » Reviewed & tested by the community

Patch applies cleanly and successfully gets rid of all errors. This should get committed!