How to find multiple account same email ?

[netcommander]

Hello
how can I find to multiple accounts using to same email address.
BEst Regards

[sulasno]

I don't have a solution but I can offer a suggestion;

run a query for user and their email addresses

does your board allow mutilpe accounts with the same email addy?

[netcommander]

no we dont allow it but before a few time its open i've see same emails for different user.
what's a query ? do you have test any query ?
best regards

[ctweb]

Firstly,

Settings ? Options ? User Registration Options

Require Unique Email Addresses - Set to YES!

And then, if you want users who have registered with the same email..

SELECT userid, username, email, count(email) FROM user GROUP BY username HAVING count(email) > 1

Execute that in phpMyAdmin, and you should get your results..

[netcommander]

Hello
thanks for help
i've run this query but it's not find any user ?
Best Regards

[ctweb]

Originally Posted by netcommander

Hello
thanks for help
i've run this query but it's not find any user ?
Best Regards

Are you sure, try this then..

SELECT email, COUNT(email) AS Duplicates FROM user GROUP BY email HAVING ( COUNT(email) > 1 )

[netcommander]

Hello
its give a this error message
error desc: Table 'xxxx_xxx.users' doesn't exist.
thanks

[sulasno]

what's your version of vBulletin ?

ACP> Maintenance >Execute SQL Query >Manual Query

select username,email from user;

[netcommander]

my version is 4.06
select username,email from user
its not good for me i've got a lot user they give me 20.000 page

[akademikper]

Originally Posted by ctweb

Are you sure, try this then..

SELECT email, COUNT(email) AS Duplicates FROM user GROUP BY email HAVING ( COUNT(email) > 1 )

This is worked for me, but i want to delete all multiple mail users. Any solution?