Jump to content
Sign in to follow this  
kesit

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

Recommended Posts

----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.

Share this post


Link to post
Share on other sites

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!

  • Like 1

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More