MySQL 1064 error

Hi, according to my suitecrm.log this query fails:

SELECT aos_quotes.id AS id FROM aos_quotes WHERE aos_quotes.expiration = DATE_ADD(UTC_TIMESTAMP(), INTERVAL + ) AND aos_quotes.stage = ‘Delivered’ AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id=‘89059467-4293-5928-0209-5729ceb8ad52’ AND aow_processed.parent_id=aos_quotes.id AND aow_processed.status = ‘Complete’ AND aow_processed.deleted = 0) AND aos_quotes.deleted = 0

According to MySQL the DATE_ADD syntax should be ’ … INTERVAL number DAY’ instead of ‘… Interval +’
By changing the query to the suggested syntax it’s OK when I run directly to the database.

How/where to change in SuiteCRM?

the for the help,
Rob

Can you confirm that the specific workflow is correctly set up? That is where I would first look.

I then would suggest having a look about the AOW modules to find where / how the workflows store the Interval values/conditions and if there is an issue there.