Hi Anders H, Anders Hinding wrote:
Hi all,
Due to the new virus (sobig) slamming our OTRS system, we have archieved to have our queues filled up with mail containing virus (including attachments).
The amount is so huge that it will take several hours to delete each mail manually by closing them down from OTRS.
We tried to delete them directly from the database by first selecting and then deleting the entries from the following tables : article, article_plain, article_attachment and ticket_history. But even thou the messages seems to have been deleted, they still show up in the system, but when clicking on them, we get the error "Invalid ticket" or "Ticket does not exist".
Does anyone know how we can get around this so we wont have to manually close down all the mails from otrs.
I guess they still show up because of the entry in table ticket. See this page as a reference: http://www.mail-archive.com/otrs@otrs.org/msg01122.html The problem might be that it's not easy to select and delete the entries in table ticket. Hope this helps, Yong Li
Any information on this is most welcome.
Best Regards Anders H
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs