SQL error on PostgreSQL

[David Mudrák]

After the cron has been executed, I am getting the SQL error on PostgreSQL:

ERROR: column "-" does not exist
LINE 1: SELECT CONCAT(a.id, "-", o.id) AS id, a.formid, a.userid, o....

Please use $DB->sql_concat() instead of hardcoding the SQL for this. IIRC, double quotes have special meaning in PostgreSQL which the $DB wrapper should deal with. Alternatively, avoid the string concatenation at the DB level, if possible.

[Barry O]

Thanks for spotting this David. I've fixed it now.