[otrs] Re: Totally empty tickets in my queue

On Wed, 8 Sep 2004 08:20:00 +0200, Martin Edenhofer wrote:

...

Message: No article found for TicketID 815!

However, a ticket needs min. one article. If there is no article, then you have a problem. You need to delete this "empty" tickets from the database:

mysql> DELETE FROM ticket WHERE id = 815;

Maybe helps (at least in postgresql 4.xx): -- tickets with no articles: select id from ticket except \ select ticket.id from ticket, article where article.ticket_id=ticket.id; Peter -- Now using M2, Opera's e-mail client: http://www.opera.com/m2/