When running the status report on Drupal 10.4.3 php 8.3.16
I get the warning
Conflicting user emails
Some user accounts have email addresses that differ only by case. For example, one account might have alice@example.com and another might have Alice@Example.com.
I ran See Conflicting User Emails for more information.
This SQL query will find any such problems in the database:
SELECT ufd.uid, ufd.name, ufd.mail, ufd.status
FROM users_field_data ufd
JOIN (
SELECT LOWER(mail) AS lower_mail
FROM users_field_data
GROUP BY LOWER(mail), langcode
HAVING COUNT(uid) > 1
) duplicates ON LOWER(ufd.mail) = duplicates.lower_mail
ORDER BY LOWER(ufd.mail), ufd.uid;
and got the answer: Mysql returned an empty result set.
See pictures. I have no idea how to change this.
Maybe somebody can help. Thanks
Drupal 10.4.3 php 8.3.16
Active
10.4 ✨
user system
Sorry! I mean 🐛 User names uniqueness is no longer accent-sensitive Active .
Can you determine if this may be the same as 🐛 User names uniqueness is no longer accent-sensitive Active ?
Look for users with empty e-mail, that was the reason this was reported on our sites.
I've had this happen on a multilingual site because the user had been translated.