On Wed, 8 Sep 2004 08:20:00 +0200, Martin Edenhofer <[EMAIL PROTECTED]> 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/
_______________________________________________ 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 Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/
