[Question]: SQL

[ElectricMediaUK]

I'm trying to install Open DMARC Analyzer however I'm getting the error below, can anyone advise how to resolve this?

connecting to database... success
opening file... success
→ CREATE VIEW IF NOT EXISTS report_stats AS (
→ SELECT
→ report.serial, domain, rcount, disposition, reason,
→ policy_p, policy_pct, dkimdomain, dkimresult, dkim_align,
→ spfdomain, spfresult, spf_align, mindate, maxdate
→ FROM report RIGHT JOIN rptrecord
→ ON report.serial=rptrecord.serial
→ );
performing query... failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS report_stats AS ( SELECT report.serial, domain, rcount, disposi' at line 1

Thanks in advance!

[MatthewHana]

Are you running MySQL or MariaDB?

[pheonix-devapps]

connecting to database... success
opening file... success
→ CREATE VIEW report_stats AS (
→ SELECT
→ report.serial, domain, rcount, disposition, reason,
→ policy_p, policy_pct, dkimdomain, dkimresult, dkim_align,
→ spfdomain, spfresult, spf_align, mindate, maxdate,
→ FROM report RIGHT JOIN rptrecord
→ ON report.serial=rptrecord.serial
→ );
performing query... failed: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM report RIGHT JOIN rptrecord ON report.serial=rptrecord.serial )' at line 6

[cweiske]

Duplicate of #104