Purge/Deleting deleted customers?

[Rob_West]

in 1.3 I have created some accounts for testing with the same email address and found that the second account cannot login through the customer portal.
I think this is because of the problem discussed here:

Duplicate Customers

Good day, I am having an issue with the customers section of splynx. it is a new installation and below is the problem i have created. i created a new customer (username: customer111 password: 1234) i set customer to inactive (in order to show delete button to remove customer from system) i created a new customer with a different sequential ID but the same username and password when customer tries to log into portal the are not able to login and the error message "login or password inco…

My users use email address for both login and email (they are the same and that’s the way we like it to be)

So given that there is a deleted user with the same login/email I don’t think setting the portal settings to login will help.

I need to know how I can manually delete the deleted user from the database and/or if this happens automatically after a certain time?

[fenixter]

1. No, there are no automatically cleaning deleted records.

2. You can delete it from server console:
   mysql -uroot -p
   enter mysql root password
   use splynx;
   delete from customers where email = ‘customer@domain.com’ and deleted = ‘1’;
   quit;

Today I will fix that problem and it will be available in our dev version.