On 1/14/26 10:28 AM, Dennis Putnam via Mailman-users wrote:
The table account_emailaddress has 3 entries:
mysql> select * from account_emailaddress; +----+-----------------------+----------+---------+---------+ | id | email | verified | primary | user_id | +----+-----------------------+----------+---------+---------+ | 1 | uuuu@ddddddddd.net | 1 | 1 | 2 | | 2 | uuuu@ddddddddd.net | 0 | 0 | 3 | | 3 | xxxxxxxx@gmail.com | 1 | 1 | 4 | +----+-----------------------+----------+---------+---------+ 3 rows in set (0.00 sec)
Yes, id 1 and 2 are the same email address.
As a superuser, go to https://whatever/admin/account/emailaddress/ and find the uuuu@ddddddddd.net address that is not primary and get its user name. Then go to https://whatever/django/auth/user/ and delete that user. I thing this will delete the associated address, but go back to the addresses and if it's still there, delete it.
You might instead try
DELETE FROM account_emailaddress WHERE id = 2; DELETE FROM auth_user WHERE id = 3;
But those may fail due to foreign key constraints.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan