Ron,
I'm aware of the tools you mentioned and they were properly used.
Please let us focus on the question I asked - how do we delete messages of a particular date if there are too many of them so using Hyperkitty UI isn't an option?
Thank you.
On Wed, Jul 10, 2024 at 10:18 PM Ron <admin@bclug.ca> wrote:
On 2024-07-10 12:05, Danil Smirnov via Mailman-users wrote:
After importing from Mailman 2, thousands of badly compiled messages from the past appeared with empty content on the same date (date of import).
Is there a safe way to delete them all? If we delete them from the database - hyperkitty_email table - do we need to do some clean-up of hyperkitty_thread table as well?
Per https://docs.mailman3.org/en/latest/migration.html, there's a tool with mailman2 that can clean messages *prior* to import:
all mailboxes should be checked for defects before importing. Certain defects such as missing Message-ID: headers or missing or unparseable Date: headers will be corrected or ignored by the import process. The one defect that will definitely cause problems is lines beginning with From in message bodies. These will be seen as the start of a new message. There is a Mailman 2 script at $prefix/bin/cleanarch.
I'd try deleting the corrupt list, running
cleanarchon the old list, and re-importing.If the new list has messages that are not in the old list (i.e. it's in live production), then I'm not sure of how to proceed.
Note the linked page also mentions a tool called check_hk_import script in hyperkitty/contrib folder.
Mailman-users mailing list -- mailman-users@mailman3.org To unsubscribe send an email to mailman-users-leave@mailman3.org https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/ Archived at: https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/message/...
This message sent to danil@smirnov.la