Duplicate Entry Errors

[kalukee]

I've search the forums for this answer only to find the question asked and asked but no answers.

 

So I try again

 

I can enter one order and thats it. I log in as a different customer and get the same error.

 

AND

 

this order does not get updated in OsAdmin but its there thru phpAdmin.

 

I've tried to reset the tables, didnt help.

 

to answer the question of "what snapshot are you using?''

 

I dunno, whats the easist way to figure trhis out??

 

Any takers???

thanks

 

using

PHP 4.3.1

Apache 1.3.20

 

 

 

DELETE FROM orders;

ALTER TABLE orders AUTO_INCREMENT = 1;

DELETE FROM orders_products;

ALTER TABLE orders_products AUTO_INCREMENT = 1;

DELETE FROM orders_products_attributes;

ALTER TABLE orders_products_attributes AUTO_INCREMENT = 1;

DELETE FROM orders_products_download;

ALTER TABLE orders_products_download AUTO_INCREMENT = 1;

DELETE FROM orders_status;

DELETE FROM orders_status_history;

ALTER TABLE orders_status_history AUTO_INCREMENT = 1;

DELETE FROM orders_total;

ALTER TABLE orders_total AUTO_INCREMENT = 1;

 

1062 - Duplicate entry '' for key 5

 

insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value) values (..........................

[OceanRanch]

Looks like you might have some additional indexes defined as unique for the orders table. (key 5).

 

Look at your orders table under phpmyadmin and check the indexes making sure they allow duplicates if you really need those indexes.

 

HTH

[kalukee]

Thanks Tom

 

Thats what it was.