Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

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


Recommended Posts



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')




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

Link to comment
Share on other sites

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


Contact me for work on updating existing stores - whether to Phoenix or the new osC when it's released.

Looking for a payment or shipping module? Maybe I've already done it.

Working on generalising bespoke solutions for Quickbooks integration, Easify integration and pay4later (DEKO) integration at 2.3.x

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...