Duplicate entry '12' for key 'PRIMARY'

Fairly new to the PHP language, but searched all the threads on this for ecart 4. I'm throwing this error at the confirmation page, but only when i have more than one item in the cart. Everything shows up nicely in the cart, but once we're past the login and to the confirmation screen, it throws the error. single items work just fine. The primary key(OrderID) is set to Autoincrement, i have dumped the whole DB and started from scratch, and still get the error. not sure why. Any help would be very much appreciated.

this error would happen if you set the Store Order Summary or Store Order Details server behaviors to store a value to the primary key column of the either the orders or order details tables.

since it works if you only have one item, My guess is that you are storing the Order ID value to the DetailsID column of the of the OrderDetails table in the store order details behavior.


on the confirm page, open the Server Behaviors panel, and double click the Store Order Details behavior, make sure that the DetailID column is not set to receive a value.

Thanks.
I have started the checkout wizard again, just to make a clean install. i found 2 of the same server behaviors attached to the page. So, if i am storing an order summary in the db, which table should i be pulling the data from? I'm not sure where the fields are related between tables. I used the e commerce db kit for this, but i want to make sure i get this right so i don't have to keep bothering people. Thanks again.

For the order summary, you will not be pulling information from a table, the order summary will use the information posted by the checkout form on the confirm page.

Year 2013,
I was making a download centre and I struck with this problem "primary key duplicates".
I took auto-increment value out from 'orderdetailID' and record insertion is working perfectly.

the last post in this thread was made on 09-16-2011 09:33 PM, that is not 7 years.

glad to hear you found the cause of the problem and fixed it by not storing a value in the auto increment ID field.

You should never force a value to the auto increment field, let the database manage that field for you.