On Mon, Aug 4, 2025 at 4:53 AM Mark Sapiro <[email protected]> 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] _______________________________________________ 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/P3OWI6KUQHJGJ3ZOKEHC6ANJMIRIKB6O/ This message sent to [email protected]
