Spyros Posted April 16, 2005 Share Posted April 16, 2005 1062 - Duplicate entry '0-29' 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 ('dsfdsfds', 'sdfdsfsd', 'dsfdsfsd 5', '11111', 'Here City', '84', 'f', '', '', '182', '', '29') [TEP STOP] I got this error while trying to add an address as a customer I use OSC 2.2 updated from 2.1. Any help will be really appriciated Spyros Link to comment Share on other sites More sharing options...
Spyros Posted April 28, 2005 Author Share Posted April 28, 2005 Anyone knowing anything about it? I know it an sql problem assigning the same number in a column... should I put it on auto increment? Spyros Link to comment Share on other sites More sharing options...
boxtel Posted April 28, 2005 Share Posted April 28, 2005 Anyone knowing anything about it?I know it an sql problem assigning the same number in a column... should I put it on auto increment? <{POST_SNAPBACK}> check you table definition, the only key value should be the address_book_id. Treasurer MFC Link to comment Share on other sites More sharing options...
Spyros Posted April 28, 2005 Author Share Posted April 28, 2005 check you table definition, the only key value should be the address_book_id. <{POST_SNAPBACK}> where do I check the table if it's key value or not? the structure of the table is like this: Spyros Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.