![]() |
Help fixing Duplicate entry error
Apparently I butchered something up pretty good.
In placing orders I receive the following two SQL error messages are sent to the admin email: Code:
Date : 10-Jun-2005 21:35:12 Site : http://www.mysite.com/xcart Script : /xcart/payment/payment_offline.php Remote IP : 10.101.10.1 Logged as : user SQL query : INSERT INTO xcart_orders (login, membership, total, giftcert_discount, giftcert_ids, subtotal, shipping_cost, shippingid, tax, taxes_applied, discount, coupon, coupon_discount, date, status, payment_method, flag, details, title, firstname, lastname, company, b_title, b_firstname, b_lastname, b_address, b_city, b_county, b_state, b_country, b_zipcode, s_title, s_firstname, s_lastname, s_address, s_city, s_county, s_state, s_country, s_zipcode, phone, fax, email, url, clickid, extra) VALUES ('user', '', '269.95', '0', '', '269.95','0.00', '0', '0.00', 'N;', '0.00', '', '0.00', '1118735712', 'Q', 'Personal Check', 'N', '', 'Mr.', 'Timothy', 'Bender', '', 'Mr.', 'Timothy', 'Bender', '123 Sesame Street ', 'My-City', '', 'AL', 'US', '0000', 'Mr.', 'Timothy', 'Bender', '123 Sesame Street', 'My-City', '', 'AL', 'US', '00000', '123-456-7890', '', 'myemail@mydomain.com', '', '', 'a:2:{s:17:\"additional_fields\";b:0;s:8:\"tax_info\";a:5:{s:26:\"display_taxed_order_totals\";s:1:\"N\";s:31:\"display_cart_products_tax_rates\";b:0;s:14:\"taxed_subtotal\";s:6:\"269.95\";s:25:\"taxed_discounted_subtotal\";s:6:\"269.95\";s:14:\"taxed_shipping\";s:4:\"0.00\";}}') Error code : 1062 Description : Duplicate entry 'myemail@mydomain.com' for key 2 Backtrace : /home/mysite/public_html/xcart/include/func.php:120 /home/mysite/public_html/xcart/include/func.php:80 /home/mysite/public_html/xcart/include/func.php:2807 /home/cfisher/public_html/western_shop/payment/payment_offline.php:63 and Code:
Date : 10-Jun-2005 21:35:12 Site : http://www.mydomain.com/xcart Script : /xcart/payment/payment_offline.php Remote IP : 10.101.10.1 Logged as : user SQL query : INSERT INTO xcart_order_extras (orderid, khash, value) VALUES ('0', 'add_to_cart_time', '428') Error code : 1062 Description : Duplicate entry '0-add_to_cart_time' for key 1 Backtrace : /home/mysite/public_html/xcart/include/func.php:120 /home/mysite/public_html/xcart/include/func.php:80 /home/mysite/public_html/xcart/include/func.php:2814 /home/mysite/public_html/xcart/payment/payment_offline.php:63 ...and the user is directed to a page "http://www.mydomain.com/xcart/payment/error_message.php?page_not_found" which does not exist. Any ideas? xcart - 4.1.3 |
SQL Duplicate entry error
I'm lost here... I skimmed through the code a few times... still not sure what's preventing orders to go through... Any ideas?
What would cause duplicate entries SQL error? |
All times are GMT -8. The time now is 02:52 PM. |
Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.