[SOLVED] Can't add new customer after clearing customer database

[kesit]

----QUOTE-------------
Bruno Lévêque - 16 December 2008 12:46 PM
Hi,

You can delete customers via your admin panel, you can also truncate MySQL tables:


TRUNCATE TABLE `ps_customer`;

TRUNCATE TABLE `ps_address`;

TRUNCATE TABLE `ps_orders`;

TRUNCATE TABLE `ps_order_detail`;

TRUNCATE TABLE `ps_order_discount`;

TRUNCATE TABLE `ps_order_history`;

TRUNCATE TABLE `ps_message`;

TRUNCATE TABLE `ps_cart`;

TRUNCATE TABLE `ps_cart_product`;

TRUNCATE TABLE `ps_cart_discount`;

-------- /QUOTE-----------------------------------
After I run this SQL command, all my data is succesfully deleted. But somehow, I can’t create any customer again.

Anybody can help?

the message is:
There is 1 error :
1. an error occurred while creating your account

ps: I still run for my test site, so the customer was created by myself.

[kesit]

Ok, finally I found the solution of my problem.

TRUNCATE TABLE `ps_customer`;
TRUNCATE TABLE `ps_address`;
TRUNCATE TABLE `ps_orders`;
TRUNCATE TABLE `ps_order_detail`;
TRUNCATE TABLE `ps_order_discount`;
TRUNCATE TABLE `ps_order_history`;
TRUNCATE TABLE `ps_message`;
TRUNCATE TABLE `ps_cart`;
TRUNCATE TABLE `ps_cart_product`;
TRUNCATE TABLE `ps_cart_discount`;

I have to add 1 more sql:
TRUNCATE TABLE `ps_customer_group`;

Thanks a lot for reading!

[catch]

Hi.

 

After running this, I can not login in onepage checkout. But I can login when I using account login.

 

Any adia how to fix that please?