Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Duplicate Order Error When Placing Order Rate Topic   - - - - -

 
  • bigjmart
  • Senior Member
  • Members
  • Join Date: 29-Jan 10
  • 192 posts

Posted 21 September 2012 - 03:04 AM #1

If I place an order It will go through fine,

As soon as I duplicate the order with the SAME item, same account, same credit card, I get this error:




Database error: Duplicate entry '3021097418-16777215' for key 'PRIMARY' (1062)
Invalid query: INSERT INTO cscart_order_details (`item_id`, `order_id`, `product_id`, `product_code`, `price`, `amount`, `extra`) VALUES ('3021097418', '16777227', '29812', '1EN5.019.02', '134.96', '1', 'a:7:{s:15:\"product_options\";a:0:{}s:13:\"return_period\";s:2:\"10\";s:7:\"product\";s:59:\"TomTom VIA 1505T 5-Inch GPS Navigator with Lifetime Traffic\";s:10:\"company_id\";s:1:\"0\";s:6:\"is_edp\";s:1:\"N\";s:12:\"edp_shipping\";s:1:\"N\";s:10:\"base_price\";d:134.960000000000007958078640513122081756591796875;}')

Backtrace:
File: /home/bigjmart/public_html/core/fn.database.php Line: 296 Function: db_error File: /home/bigjmart/public_html/core/fn.cart.php Line: 543 Function: db_query File: /home/bigjmart/public_html/controllers/customer/checkout.php Line: 367 Function: fn_place_order File: /home/bigjmart/public_html/core/fn.control.php Line: 555 Function: include File: /home/bigjmart/public_html/core/fn.control.php Line: 410 Function: fn_run_controller File: /home/bigjmart/public_html/index.php Line: 14 Function: fn_dispatch


Any info would be great. Does it have something to do with my MYSQL setup??
Seems like their is a value in the database that doesn't like duplicates (being the product ID or name)