Duplicate entry

[edpierre]

Attention!

This revised request was first posted at an inappropriate forum (Contribution).

I repost it here. Sorry for the error.

Here is the problem!

When clicking on the confirmation button, I'm getting the following error at the checkout_process.php:  

 

1062 - Duplicate entry '' for key 1  

 

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 ('19', 'Califou Califa', '', '9, Calif street', '', 'CalifVille', 'calif', 'Alberta', 'Canada', '654-9807', '[email protected]', '1', 'Califou Califa', '', '9, Calif street', '', 'CalifVille', 'calif', 'Alberta', 'Canada', '1', 'Califou Califa', '', '9, Calif street', '', 'CalifVille', 'calif', 'Alberta', 'Canada', '1', 'Cash on Delivery', '', '', '', '', now(), '1', 'USD', '1.00000000');

 

win 32 dev site, win98, 2.2MS1.

I don't know how to fix it.

Some help, please!!!

 

Ed

[Guest]

Check to see if customer id is set to auto increment in the database.

 

If you search for *1062 - Duplicate entry* (remember to include the * wildcards, the search can be tempramental without) you should find serveral threads with the same error & solutions for it.

 

hth

[edpierre]

You're my saviour, Linda!

 

I 'auto-increment' order_id and all works fine now!

 

A lot of tanks

 

Ed

[alexs]

I thought it was caused by a seperate contribution. Spent hours on this thing, maybe that contribution should be taken off the list or some warnings posted?