On Mon, Aug 4, 2025 at 4:53 AM Mark Sapiro <mark@msapiro.net> wrote:
On 8/3/25 00:09, Odhiambo Washington via Mailman-users wrote:
I wonder what this means and whether it's fatal.
How do I fix it?
ERROR OCCURED IN JOB: sync_mailman (APP: hyperkitty) ... *allauth.account.models.EmailAddress.MultipleObjectsReturned: get() returned more than one EmailAddress -- it returned 2!*It appears you created a new list, and that list' owner email address has two Django user records with emails differing only in case.
I did not create a new list actually. I was working on an existing list.
See https://www.msapiro.net/scripts/UC_fix for a script to fix this or you
can just go to the Django web UI and delete the mixed case user.
The script did not work for me as-is because I use MySQL on this site.
I suspect it's something to do with my action yesterday while attempting to reply to a thread from HyperKitty.
Possibly, if hyperkitty was looking at a mixed case email address that it didn't recognize as a list member and subscribed it.
Happens to not have been the case either. No mixed case address.
The superuser account uses my address - odhiambo at gmail dot com.I am also the listowner for most lists. I tried unsuccessfully to create an account on Postorious using the same email address. I kept getting sent links to verify the account, over and over. Finally, I was able to verify the account, but cannot login with it.
This too is probably because there are two accounts with email addresses differing only in case.
With assistance from ChatGpt, I went digging into the DB and what I found (as I expected) turned out to be slightly different: [email slightly obfuscated!]
MariaDB [mailmansuite]> SELECT id, user_id, email, verified, `primary` FROM
account_emailaddress WHERE LOWER(email) = 'odhiambo__gmail.com';
+------+---------+--------------------+----------+---------+
| id | user_id | email | verified | primary |
+------+---------+--------------------+----------+---------+
| 1844 | 1823 | odhiambo__gmail.com | 1 | 0 |
| 2548 | 4 | odhiambo__gmail.com | 0 | 0 |
+------+---------+--------------------+----------+---------+
2 rows in set (0.002 sec)
MariaDB [mailmansuite]> SELECT id, username, email, is_active FROM auth_user WHERE id IN (SELECT user_id FROM account_emailaddress WHERE LOWER(email) = 'odhiambo__gmail.com' ); +------+----------+-------------------------+-----------+ | id | username | email | is_active | +------+----------+-------------------------+-----------+ | 4 | odhiambo | odhiambo__gmail.com | 1 | | 1823 | admin | odhiambo__kictanet.or.ke | 1 | +------+----------+-------------------------+-----------+ 2 rows in set (0.011 sec)
So I resolved it by deleting the duplicate: MariaDB [mailmansuite]> DELETE FROM account_emailaddress WHERE id = 1844;
Now I need to find a way for me to subscribe my email address as an ordinary user for starters. This is refusing.
-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]