new user creation error

[jvpandian]

When trying to create a new user at the time of checkout the following error occurs. Please help me to fix this

1062 - Duplicate entry '7' for key 1

insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('7', '0', now())

[TEP STOP]

[michael_s]

There is a problem with the test customer in the database. Using phpmyadmin, empty the customer, order, and address tables. That should fix the issue.

[sila]

Ok, i'm getting the same error with a fresh install. I prefer to take this error out before actual customers create accounts. I'm new and feel unsure about the php admin: When i try to "empty" the table it says "are you sure you want to truncate..." ?

Please confirm that this is correct. I have the feeling that if do something wrong here it will take a lot of doing to fix it again.

Thanks for helping...

[michael_s]

This problem is no longer in the latest download from this site. You must be using an older install. Yes, you want to empty the table. Truncate means that you will remove all records from the table. This is what you want to do...

Also, you should already have a backup of your database. If you don't, I am telling you now, make a backup of your database before doing anything you are unsure of.

[sila]

1. Thanks a million for your reply. I can proceed now with less trepidation. Yes i saved the database, even if at this time I would not yet know how to put it back

2. For your info: i downloaded my version two weeks ago, January 14, see also my forum registration date here. In fact there were a few small errors in it that needed (and need) to be corrected. The latest files (readme files) in the zip file root directory are dated September 17, 2004 and so are all directories (after a quick browse through). So unless somewhere there are newer files, this version is most probably from that time.

Thanks again for the quick confirmation on emptying those database tables.

[michael_s]

You do not have the latest archive. Late last week, an updated archive was upped that fixes a few of the more common errors errors in the package.