OK; so I have an old mailman instance where I can't confirm unsubscribe moderation requests. mailman3 core is still sending me daily notices about that moderation requests; I want to get rid of them. (By now, I unsubscribed this test subscriber, so these messages are garbage anyhow.)

First: I assume that all information about moderation is in the database mailman3. If that's not the case, please tell me.

Second: I tried to determine what DB records are involved in a moderation, so I can delete them. I found the following records: -- workflowstate: records about pending confirmations; with a token as primary key. -- pended: records that references that key, with an id. -- pendedkeyvalue: records with additional information about the request, referenced by the id of table record `pended'.

In addition, there is a record in table member' for that mailing list, with an UUID in _member_id' that isn't stored in any other record in the database elsewhere. (This is a test mailing list that currently has *no* members; thus this record might be relevant.) Where is this `_member_id' UUID used?

My question is: Which records do I have to delete to get rid of the daily pending unsubscribe moderation notices?

Cheers, Joachim

--

Joachim Schrod Email: joachim@schrod.org Roedermark, Germany

``How do we persuade new users that spreading fonts across the page
like peanut butter across hot toast is not necessarily the route to
typographic excellence?''			-- Peter Flynn