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

Reply via email to