MattWeb Posted January 23, 2011 Share Posted January 23, 2011 I have run into a particular problem whilst testing my installation.When I delete an email address that has previously been used to register an account I'm unable to register an account again with the same email address as it states that the email is in the system despite being the previous account being deleted.Any solutions appreciated. Link to comment Share on other sites More sharing options...
pmfjoe Posted January 23, 2011 Share Posted January 23, 2011 The reason is when you delete the customer the complete account is never deleted because it still has orders tied to it. The only way to fix this is to manually go into the database and set the email address for the old account to something else. Link to comment Share on other sites More sharing options...
noobhacker101 Posted January 26, 2011 Share Posted January 26, 2011 Go into your sql DB and go to pshop_customer, on ine i select browse, not sure how your will be and select the customer (test) that you want to reuse... delete from your DB and you will be able to use the email again. Link to comment Share on other sites More sharing options...
inveostore.com Posted January 27, 2011 Share Posted January 27, 2011 Never delete complete customer record from database. Only remove email if you want to reuse it. Link to comment Share on other sites More sharing options...
noobhacker101 Posted January 27, 2011 Share Posted January 27, 2011 if its only a test user why would it matter??? i have deleted multiple test users completly from my db and havent had a problem.... will i run into one once the site goes live Link to comment Share on other sites More sharing options...
inveostore.com Posted January 27, 2011 Share Posted January 27, 2011 if its only a test user why would it matter??? No matter it is test or live site it breaks the database integrity and then all tests you do can not be classified as PASSED (because you did it under circumstances which will never happen at live site...). Link to comment Share on other sites More sharing options...
noobhacker101 Posted January 27, 2011 Share Posted January 27, 2011 I agree. I accept that my solution was wrong. thank younot personal i understand. i just admit i was wrong. i thought i had fund away around it since i had the same problem.good incite. ;-) thanx Link to comment Share on other sites More sharing options...
inveostore.com Posted January 27, 2011 Share Posted January 27, 2011 Sorry if it sounded personal from me.I just wanted to avoid problems, because not all users/devs know that it may break some functions. Link to comment Share on other sites More sharing options...
pmfjoe Posted January 27, 2011 Share Posted January 27, 2011 But you can still go and change the email address to something else, without affecting the integrity of the database. Link to comment Share on other sites More sharing options...
Matje Posted February 21, 2011 Share Posted February 21, 2011 There is a simpler work around.I ran in the same problem.But it appears that you can still access a "deleted" account via the search function.Then you can edit the account. So I change the mailaddress in an unvalid one.Result: you or the customer can create a new account with the desired mailaddress.I think (but did not check) that any history is only related to the old account, thus will be lost for the customer.gr. Matje Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now