On Thursday, September 09, 2004 12:49 PM
Peter Gervai
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')
No. You have to take care of the references in article_plain, article_attachement, time_accounting, ticket_history, too, if present. Most probably you'll have one entry in article_plain and ticket_history, zero or more in article_attachement and zero or one in time_accounting, all per article. Well, see this matrix of IDs: SELECT a.id a, ap.id ap, aa.id aa, ta.id ta, th.id th FROM article a LEFT JOIN article_plain ap ON a.id = ap.article_id LEFT JOIN article_attachment aa ON a.id = aa.article_id LEFT JOIN time_accounting ta ON a.id = ta.article_id LEFT JOIN ticket_history th ON a.id = th.article_id WHERE a.a_from = 'GenericAgent' AND a.a_subject = 'stupid admin' ORDER BY a, ap, aa, ta, th ; hth, Robert Kehl -- Für mich gibt es nur "Entweder-Oder". Also entweder voll oder ganz! Toni Polster