File: validation_api.module Line: 350
Where it says:
$result = db_query('SELECT f.vafid AS vafid, f.form_id AS form_id, f.form_field AS form_field, f.vavid AS vavid, f.allow_empty AS allow_empty, f.message AS message, av.vaaid AS vaaid, av.value AS arg_value, a.delta AS arg_delta FROM {validation_api_fields} AS f LEFT JOIN {validation_api_arguments_values} AS av ON f.vafid = av.vafid LEFT JOIN {validation_api_arguments} AS a ON av.vaaid = a.vaaid WHERE f.form_id = "%s"', $form_id);
Should say:
$result = db_query("SELECT f.vafid AS vafid, f.form_id AS form_id, f.form_field AS form_field, f.vavid AS vavid, f.allow_empty AS allow_empty, f.message AS message, av.vaaid AS vaaid, av.value AS arg_value, a.delta AS arg_delta FROM {validation_api_fields} AS f LEFT JOIN {validation_api_arguments_values} AS av ON f.vafid = av.vafid LEFT JOIN {validation_api_arguments} AS a ON av.vaaid = a.vaaid WHERE f.form_id = '%s'", $form_id);
Attention to quotes!
Comments
Comment #1
TapocoL commentedSorry about the delayed response. Been busy. I fixed the queries in .module and .admin.inc to use apostrophes instead of quotations for string values. I have not tested in PostgreSQL, since I just don't have the time to set it up right now. Let me know if you have further problems.