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

[navyhost]

Hello

 

I just noticed today that when customers opt to use paypal for there payment they receive the following order on the confirmation page and are not able to complete their order. I had to remove the latter part of the error message because it contained personal info.

 

Any help with the database issues is appreciated.

 

thanks

 

1062 - Duplicate entry '0' 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)

[Guest]

re read the readme in the addon that you installed or one you last put on your site

 

you miss one of the sql upload and did not read the error you got

 

Duplicate entry