Database Error: Duplicate Entry

I have users getting this error:



[color=#000000][font=Courier][size=3]Database error:[/size][/font][/color] Duplicate entry '0-2907' for key 'PRIMARY' b[/b]

[color=#000000][font=Courier][size=3]Invalid query:[/size][/font][/color] INSERT INTO cscart_order_details



I have narrowed it down to a required item for some products. Anyone ever seen this or have any ideas?

FSVS_Error_Capture.PNG

Item ID is not calculated correctly. It should not be negative. Please contact CS-Cart support team

[quote name='eComLabs' timestamp='1430148548' post='212748']

Item ID is not calculated correctly. It should not be negative. Please contact CS-Cart support team

[/quote]



Wouldn't that give an “out of range” error. Error is pointing to the OrderID.



If you don't want to wait for support and can going into the database check the order ID - search for that number in that field and see how many the are. If the are two adding one to the last ID.

Your item id is zero and it be (probably) a large integer. You apparently have something that is modifying the cart and not properly getting the item_id.

[quote name='tbirnseth' timestamp='1430179957' post='212787']

Your item id is zero and it be (probably) a large integer. You apparently have something that is modifying the cart and not properly getting the item_id.

[/quote]



Not large integer but negative number. Please check screenshot. If I remember correctly, it is well known issue for CS-Cart support team.

Okay, same point. The value is being created incorrectly. Possibly the 'generate_cart_id' is being used incorrectly by an addon (or someone is creating the id witout using the fn_generate_cart_id() function Sure would help if there was actually a way to lookup bugs and find solutions. But oops, that would take a real bug tracking system.