Update: I've been able to get Forms to submit successfully by
1. translating the two files in "CIForms/sql/" from mysql to postgres
2. making some minor changes to "CIForms/includes/specials/CIFormsSubmit.php" & "CIForms/includes/specials/CIFormsManage.php" (changing any references to the "CIForms..." tables to lower case i.e. "ciforms...")
But now i get a new database error when trying to view the results at Special:CIFormsManage:
Error 42803: ERROR: column "ciforms_submissions.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT /* CIFormsManage::reallyDoQuery */ ciforms_submissio...
Function: CIFormsManage::reallyDoQuery
Query: SELECT ciforms_submissions.*,
COUNT(*) as submissions,
(SELECT MAX(created_at)
FROM ciforms_submissions as b
WHERE b.title = ciforms_submissions.title
) as last_submission_date,
SUM(CASE WHEN shown IS NULL THEN 1 ELSE 0 END) as new
FROM ciforms_submissions
GROUP BY ciforms_submissions.page_id, ciforms_submissions.title
ORDER BY last_submission_date DESC LIMIT 51 OFFSET 0
It seems to originate from the database query that results from line 413 in "CIForms/includes/specials/CIFormsManage.php"
Im afraid i've reached the limits of my troubleshooting capabilities. Do you have any ideas to help me view the results in given our Postgres database?
Thanks again!