Contrib.social

Conflicting user emails

Open on Drupal.org →
Created on 24 February 2025, 8 months ago

Problem/Motivation

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.

Steps to reproduce

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.

Proposed resolution

See pictures. I have no idea how to change this.

Remaining tasks

Maybe somebody can help. Thanks

Release notes snippet

Drupal 10.4.3 php 8.3.16

📌 Task
Status

Active

Version

10.4 ✨

Component

user system

Created by

🇨🇭Switzerland lomale@bluewin.ch Switzerland

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024