Hello

We are trying to tidy up portal that up to now has allowed more than one account for one email address. To do this I first need to remove all the duplicate email addresses that currently exist.

If I just delete the extra account then when I search for duplicate email addresses in the users table it still shows as a duplicate - I guess because I haven't hard deleted it, - this has thrown up 2 questions

1. Will it cause a problem when I switch to unique email addresses if I leave these soft deleted accounts in the database ?

2. Assuming it doesn't cause a problem to leave them there, does anyone have a SQL Script that identifies soft deleted users in DNN 5.6 - I can't find where the flag is (doesn't seem to be IsDeleted anymore ?)

The SQL I am using to find duplicate addresses is:

SELECT email, 
 COUNT(email) AS NumOccurrences
FROM users
GROUP BY email
HAVING ( COUNT(email) > 1 )

Thanks for any help

Vicky

Thank you for the reply - does using the 'remove deleted users' feature in 5.6.3 delete the users in all these tables or do I need to do this via SQL ?

Thank you

 

 

Hi Sebastian,
Is there a way (script) to check table users, ASPNET_users and ASPNET_membership?
I have some users in aspnet_Membership and not in the others table (wrong deletion).
thanks

---

Www.Informatori.Info