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 | [email protected]    |        1 |       1 |       2 |
|  2 | [email protected]    |        0 |       0 |       3 |
|  3 | [email protected] |        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 [email protected] 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 <[email protected]>        The highway is for gamblers,
San Francisco Bay Area, California    better use your sense - B. Dylan
_______________________________________________
Mailman-users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/
Archived at: 
https://lists.mailman3.org/archives/list/[email protected]/message/AKIMP46QHPB5AQCEXD3ILEUHB24C2U75/

This message sent to [email protected]

Reply via email to