Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Address Book Hell


Guest

Recommended Posts

Hi there,

 

I'm using the most recent milestone. It's a fresh install, but I did take a bunch of my MS 1 tables (*orders, *products, and address book and brought them into the new database...)

 

Ok, so if I add an address to my address book, I get this:

 

1062 - Duplicate entry '1-73' for key 1

 

insert into address_book (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, customers_id) values ('Ted', 'Koppel', '123 Flaloyl Drive', '12345', 'Federstained', '223', 'f', '', '', '51', '', '73')

 

[TEP STOP]

 

Also, when I put the state in, I get no dropdown, (manual input) and then it tells me I forgot the state and it gives me a dropdown...what's up with that?

Link to comment
Share on other sites

I did a new install too (but I didn't have a site to upgrade from) and i'm having the same problems.

 

1062 - Duplicate entry '1-2' for key 1

 

insert into address_book (entry_firstname, entry_lastname, entry_street_address, entry_postcode, entry_city, entry_country_id, customers_id) values ('Andy', 'Bolstridge', '7 Ancona Close', 'SN5 5NR', 'Swindon', '222', '2')

 

New customers, everything is fresh and clean. Why would this be happening?

Link to comment
Share on other sites

  • 3 months later...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...