I'm getting the following warnings upon enabling. And though I'm able to create validators and assign fields to them, it produces even more warnings when I go to delete a field (and fails to delete it).

Upon Enabling the module I get...

warning: pg_query() [function.pg-query]: Query failed: ERROR: column "validation_api" does not exist LINE 1: UPDATE drupal_system SET weight = 50 WHERE name = "validatio... ^ in /home/www/mySite/html/includes/database.pgsql.inc on line 139.
user warning: query: UPDATE drupal_system SET weight = 50 WHERE name = "validation_api" AND type = "module" in /home/www/mySite/html/modules/validation_api/validation_api.install on line 162.
warning: pg_query() [function.pg-query]: Query failed: ERROR: column "url" does not exist LINE 1: ...pi_validators (name, type, rule, message) VALUES ("url", "ph... ^ in /home/www/mySite/html/includes/database.pgsql.inc on line 139.
user warning: query: INSERT INTO drupal_validation_api_validators (name, type, rule, message) VALUES ("url", "php", "return valid_url($value, $arguments[0]);", "%field must be an absolute url address"), ("email", "php", "return valid_email_address($value);", "%field must be in an email format.") in /home/www/mySite/html/modules/validation_api/validation_api.install on line 167.
warning: pg_query() [function.pg-query]: Query failed: ERROR: currval of sequence "drupal_validation_api_validators_vavid_seq" is not yet defined in this session in /home/www/mySite/html/includes/database.pgsql.inc on line 139.
user warning: query: SELECT CURRVAL('drupal_validation_api_validators_vavid_seq') in /home/www/mySite/html/includes/database.pgsql.inc on line 232.
warning: pg_query() [function.pg-query]: Query failed: ERROR: column "Absolute" does not exist LINE 1: ...s (vavid, delta, name, description) VALUES (0, 0, "Absolute"... ^ in /home/www/mySite/html/includes/database.pgsql.inc on line 139.
user warning: query: INSERT INTO drupal_validation_api_arguments (vavid, delta, name, description) VALUES (0, 0, "Absolute", "Enter TRUE for an absolute URL and FALSE for a relative path.") in /home/www/mySite/html/modules/validation_api/validation_api.install on line 169.

and when trying to delete a field that I've attached to a validator, I get...

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "," LINE 1: DELETE FROM f, av USING drupal_validation_api_fields AS f LE... ^ in /home/www/dev.merchant/html/includes/database.pgsql.inc on line 139.
    * user warning: query: DELETE FROM f, av USING drupal_validation_api_fields AS f LEFT JOIN drupal_validation_api_arguments_values AS av ON f.vafid = av.vafid WHERE f.vafid = 2 in /home/www/dev.merchant/html/modules/validation_api/validation_api.admin.inc on line 681.

Any suggestions, please?

Comments

work77’s picture

bump

work77’s picture

ahhah. Some of the queries are not postgres-friendly. Is there a patch for this?