[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?