Log in to AnswerLog in to Follow
2020-03-13 12-09-25
Johan den Ouden
mvp_badge
MVP
20Views
1Comments
[DB Cleaner on Steroids] Error deleting emails (timer)
Question
Forge
Traditional Web
db-cleaner-on-steroids
Web icon
DB Cleaner on Steroids
Forge component by Miguel 'Kelter' Antunes
Application Type
Traditional Web

Hi,

In the logging we now get this error every day the timer runs.

Error executing query. Error in advanced query DeleteEmails in DeleteAllEmails in DBCleanerOnSteroids (DELETE       {Sent_Email}  FROM       {Sent_Email}        LEFT  JOIN {Email_Content}    ON {Email_Content}.[Id] = {Sent_Email}.[Id]  INNER JOIN {Email_Definition} ON {Sent_Email}.[Email_Definition_Id] = {Email_Definition}.[Id]  INNER JOIN {Espace}           ON {Email_Definition}.[Espace_Id] = {Espace}.[Id]    WHERE      {Sent_Email}.[Created] < @OlderThan): ORA-00933: SQL command not properly ended 

We use oracle.

Kind regards,

Johan den Ouden

0
0
25 May 2022

Hi Johan den Ouden,

Thanks for reporting that, I'll take a look and will inform about the fix.

Cheers.


0
0
25 May 2022
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.