I have a contract renewal report that runs fine when manually running from
When running from schedule system log shows the following
[FATAL] Query Failed: SELECT aos_contracts.id AS id FROM aos_contracts WHERE aos_contracts.renewal_reminder_date = DATE_ADD(UTC_TIMESTAMP(), INTERVAL - ) AND aos_contracts.deleted = 0 : MySQL error 1064: 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 ‘) AND aos_contracts.deleted = 0’ at line 1
Also when I change the report, delete and remove the schedule this message remains the same. I no longer use renewal reminder date.