On Wed, 8 Sep 2004 08:26:01 +0200, Martin Edenhofer <[EMAIL PROTECTED]> wrote:
A misconfigured GenericAgent created 130000 notes in the tickets. (One note every closed ticket every 10 minutes :-). Stupid me.) As I see these are in "article" table. Since there are no foreign keys defined I cannot really tell whether it's okay to delete these notes or they are referenced from other tables. Can I simply delete them from the table? (Manually using SQL I mean, like DELETE FROM article WHERE a_from='GenericAgent' AND a_subject='stupid admin')
(I do not want to delete closed tickets, just their genericagent notes.)
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/
