On Wed, 8 Sep 2004 08:26:01 +0200, Martin Edenhofer 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/
