error when checking out

[Guest]

Ive seen this error posted in a lot of places but Ic ant find any answers... no one seems to put in a solution...any help is apriciated.

 

1. I did a series of tests. the first went through fine, email came and everything.

 

2. the second time through I baught the same product at a different color. this time I hit the back button and added another item then tried to check out completely, It returns this error when clicking the confrimation...

 

3. no emails are sent to anyone on the second error.

 

I am running tep_snapshot-20030225

i disabled pay pal and money order modules and still get the error

 

I have only the manual cc enables.

 

1062 - Duplicate entry '0' for key 1

 

insert into orders_products_attributes (orders_id, orders_products_id, products_options, products_options_values, options_values_price, price_prefix) values ('1041', '44', 'color', 'black', '0.0000', '+')

 

 

thanks..zippy

[wizardsandwars]

Did you delete all of the products that came with the default setup?

[Guest]

yes, I only have only my current products in the data base and have just recently started getting this error... I find that it is usually when you are at check out and then use the back button to change a qty in the shopping cart and then checkout again... I "think" this is what causes the problem... I am not too familiar with php, Ive had the site running for almost 3 months now...

 

What would deleting the default products have to do with it... can you help me fix it??? oh i am hoping... I just started an ad campaign and am getting quite alot of traffic , I dont want to loose sales - Im not sure if it is losing orders or just always capturing it everytime, duplicating it and just not sending the email.

 

oh also, did I mention the orders are not sent via email and it creates 2 duplicate orders but have sequential order numbers: ei, 10034, 10035.... but the orders are duplicate as far as the product ordered.

 

one customer ordered 4 items and the script created 4 orders, each order created by the cart had one of the items but the total on each order was calculated as all 4 items' grand total... wacky!

 

thanks so much in advance for any help

[wizardsandwars]

Well, it seems to be trying to insert an order into the 'orders' using a primary key that is already in use.

 

Which means that when you got to the confirm page, and clicked on confirm, you're not supposed to click back again to change the quantity.

 

And it shouldn't be entering the order into that table until the confirm button is clicked.

 

Tell me, have you recnetly added any contributions to your shop?

[Guest]

I have installed the OS Wrapper, but I was getting this error off and on before that,,

 

I installed the paypalipn_v0971_for_milestone_1 after I read anther post that maybe this could be it, I did have pay pal enabled untill the first error I got was from a pay pal customer... that was the 4 order duplicate incident, So I uninstalled the pay pal ipn contribution and disabled pay pal from admin section since I still got the error after I uninstalled.

 

And the money order module I disabled in admin because I was still having the error, then I got the error still after turning off the money order module, (that was already installed in my default setup though.)

 

i have recently installed the header tags controller contrib, But I was already having the error off and on meaning I would try to recreate the error and couldnt get it myself and then my customers would get it..

 

a while ago I installed the shipping rate per prod-prodrate contrib. ( changes the weight to shipping amount per item) Im not sure if that could be causing it..

 

but yesterday- remember I did do a test and hit the back button and got the error..

 

I think this is what happened to my pay pal customer with the 4 duplicate orders that were created. She had 4 customer baskets in the database..

( I had seen another post by "Yikes" member that said to fix the order numbers and clear out any customer baskets that were left. I did those changes) but still the error

 

Do you think it could be something to do with the order numbers?when I look into the Table customers_basket_attributes in the data base right now there are 12 baskets stored for one customer id 1010 who is my customer that got the last error and the order was duplicated in the admin..

 

I may be wrong but Im thinking its the hitting the back button and adding or not adding but going through the check out another time its creating a new basket. or something to do with the order numbers... Just thinking logically, I really dont know the php works of the cart.

 

thanks so much for taking the time to help me... I am forever grateful... just hope we can solve this..

 

I saw over 6 posts with this same 1062 error and no one is getting any answers. I think that this is a big deal, since you really can't control the customer from hitting the back button or maybe then want to add products to the order, I really encourage that! lol

[Guest]

I talked to the last customer today that received this 1062 error and she says nope, she went through the process from start to finish with out hitting back button...

 

Something is duplicating the orders.

 

I did install a contribution that puts the order number in the email and sends a duplicate email ... could this be it?

 

something is causing this error and it needs fixing big time... so many people have gotten it and no solution has been given for this.

 

thanks for your help in advance.

[Guest]

I think I figured it out. with your help....thanks! :D

 

I found that after some testing and more testing, I was getting the orders sometimes and not allways, so I narrowed it down.

 

I changed the primary key in the table that was getting the error to auto increment...

 

I'll post again if I get it again,, but i think I found the solution. I am getting the emails now and it is not duplicating it in admin.

 

Praise God!