1062 - Duplicate entry '0' for key 'PRIMARY'

[redefin]

Hello,

 

I am running OSC 2.3.3 with several addons. When I install the PayPal Standard module, at the checkout_confirmation.php page when making an order with a test client, under the PayPal logo I get:

............................................

1062 - Duplicate entry '0' for key 'PRIMARY'

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 ('625917', 'Test Amaze', '', 'Somewhere 1', '', 'Someplace', '121212', 'Sameplace', 'Virgin Islands (U.S.)', '1212121212', '[email protected]', '1', 'Test Amaze', '', 'Somewhere 1', '', 'Someplace', '121212', 'Sameplace', 'Virgin Islands (U.S.)', '1', 'Test Amaze', '', 'Somewhere 1', '', 'Someplace', '121212', 'Sameplace', 'Virgin Islands (U.S.)', '1', 'PayPal (including Credit and Debit Cards)', '', '', '', '', now(), '31', 'EUR', '1.00000000')

[TEP STOP]

....................................................

 

I have added the same module in other OSC 2.3.3 I have at other site but did not get that issue. Anyone can help?

 

Thank you

[BrockleyJohn]

Check in phpmyadmin that your orders table has orders_id defined as auto increment

 

[redefin]

37 minutes ago, BrockleyJohn said:

Check in phpmyadmin that your orders table has orders_id defined as auto increment

 

Hi John, that did the trick. Now it works perfectly. Thanx!