Address problem in shipping module?

[nitro7]

Hello,

 

We are having an interesting problem. That I am hoping we can get some help with.

 

Anytime any users trys to add a new address in the shipping module it gives the below error.

 

1062 - Duplicate entry '0-64' for key 1

 

insert into address_book (customers_id, entry_firstname, entry_lastname, entry_street_address, entry_postcode, entry_city, entry_country_id, entry_gender, entry_company, entry_suburb, entry_zone_id, entry_state) values ('64', 'Clint', 'Wilson', '714 E Winona Ave', '46580', 'Warsaw', '223', 'm', '', '', '24', '')

 

[TEP STOP]

 

However, the customer can go in to My Account and add addresses with out any problems.

 

We are using 2.2 MS2.

 

Thanks in advance for any help.

 

Clint

[nitro7]

Anybody have any ideas?

 

 

Thanks,

Clint Wilson

[nitro7]

If you need more information please let me know what you need. This store is live and we are having customers complaining.

 

Thanks,

Clint Wilson

[justdave]

Try this:

 

mysql> alter table address_book change column address_book_id

-> address_book_id int(5) not null auto_increment;