Hi

I am unable to install this module using Postgres 8.3 with Drupal 6

The problem is using double quotes for alphanumerical values in the WHERE clause in SQL statements, see http://drupal.org/node/555548.

Please find all errors in the attached file.

CommentFileSizeAuthor
errors.txt209.71 KBgmh04

Comments

tpfeiffer’s picture

tpfeiffer commented

AFAIK, evoc has a dependency on the SPARQL module, which in turn has a dependency on the ARC2 library, which does not work with postgresql. I'd be interested to hear how you managed to deal with that.

Independent of that, installation of this module also results in problems that have nothing to do with quoting at my site, e.g.

WD php: pg_query(): Query failed: ERROR:  missing FROM-clause entry for table "n"
LINE 1: SELECT * FROM evoc_rdf_properties   WHERE (n.language ='de' ...
                                                   ^ in /var/www/dev/includes/database.pgsql.inc on line 139.
query: SELECT * FROM evoc_rdf_properties   WHERE (n.language ='de' OR n.language ='' OR n.language IS NULL) AND (  prefix="dc" AND id = "publisher") in /var/www/dev/sites/all/modules/evoc/evoc.module on line 302.

And consequently, the following fails as well:

WD php: pg_query(): Query failed: ERROR:  duplicate key value violates unique constraint "evoc_rdf_properties_pkey" in /var/www/dev/includes/database.pgsql.inc on line 139.
query: INSERT INTO evoc_rdf_properties (prefix, id, label, comment, domain, range) VALUES ('dc', 'publisher', 'Publisher', 'An entity responsible for making the resource available.', '', '') in /var/www/dev/includes/common.inc on line 3477.