We got incoming spam emails with virus in them that were not filtered by the email server.
how can we delete them from the sugar mysql database?
We got incoming spam emails with virus in them that were not filtered by the email server.
how can we delete them from the sugar mysql database?
Do cross-check with your hostinng provider, they might be having some spam checkers.Originally Posted by Victor Rosillo
Regards,
The queswtion is:
how can we delete emails that have virus once they are inside the mysql sugarcrm database?
Try running this query:
DELETE * FROM `emails` WHERE 'type' = 'out' ;
HTH.
Regards,
Will this sql to delete email will also delete the Note associated to it, to the email?; for instance, I see that each incoming email that has graphics on it, or an attachment, gets automatically a Note that contains the attachement or graphic, I want to delete both the email and the note and the graphic or attachment. Please post sql to do this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks