[MM3-users] Re: Adding user - Error 409 Subscription request already pending

On 6/16/22 15:46, Dan Caballero wrote:

Which database table contains these pending subscriptions? I checked the "members" and "address" tables but no luck yet.

I'm trying to help someone clear a few hundred of these. I can try writing a Python script to use the "hex_token" values in the Python dict. But maybe doing something via MySQL would be easier.

The tables are pended, pendedkeyvalue and workflowstate, but don't do it via MySQL.

A mailman shell interaction like this is better.

$ ./mailman shell -l list.example.com
Welcome to the GNU Mailman shell
Use commit() to commit changes.
Use abort() to discard changes since the last commit.
Exit with ctrl+D does an implicit commit() but exit() does not.
The variable 'm' is the list.example.com mailing list
 >>> util = getUtility(IPendings)
 >>> for token, data in util.find(mlist=m, pend_type='subscription'):
...     if data.token_owner == 'subscriber':
...         util.confirm(token, expunge=True)
...
 >>> commit()
 >>>

-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan