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/[EMAIL PROTECTED]/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 _______________________________________________ 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
