Checkout Issues...not sure if this is right area...sorry balinor

toolexperts · #1 04-08-2008, 06:22 AM

Upon trying to checkout (which was working yesterday) if a new customers signs up the get caught in an endless loop, and if you are existing and checkout you get

Your order is being placed. Please wait...

INVALID SQL: 1062 : Duplicate entry 'shawn@toolexperts.com' for key 2
SQL QUERY FAILURE:INSERT INTO xcart_orders (`login`, `membershipid`, `membership`, `total`, `giftcert_discount`, `giftcert_ids`, `subtotal`, `shipping_cost`, `shippingid`, `tax`, `taxes_applied`, `discount`, `coupon`, `coupon_discount`, `date`, `status`, `payment_method`, `paymentid`, `payment_surcharge`, `flag`, `details`, `customer_notes`, `clickid`, `language`, `extra`, `title`, `firstname`, `lastname`, `phone`, `fax`, `email`, `url`, `company`, `tax_number`, `tax_exempt`, `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`) VALUES ('xxxxxx@xxxx.com', '0', '', '14.28', '0', '', '2.78', '11.50', '23', '0.00', 'N;', '0.00', '', '0.00', '1207660542', 'Q', 'Phone Ordering', '4', '0', 'N', '', '', '', 'US', 'a:3:{s:10:\"Anti_Fraud\";a:1:{s:6:\"result\";s:10 :\"sk_invalid\";}s:17:\"additional_fields\";a:0:{} s:8:\"tax_info\";a:5:{s:26:\"display_taxed_order_t otals\";s:1:\"N\";s:31:\"display_cart_products_tax _rates\";b:0;s:14:\"taxed_subtotal\";s:4:\"2.78\"; s:25:\"taxed_discounted_subtotal\";s:4:\"2.78\";s: 14:\"taxed_shipping\";s:5:\"11.50\";}}', 'Mr.', 'shawn', 'hatfield', '888-888-8888', '', 'shawn@toolexperts.com', '', '', '', 'N', '', 'shawn', 'hatfield', '1xxx hughes rd ', 'xxxx', '', 'TN', 'US', 'xxxxxx', 'Mr.', 'shawn', 'hatfield', '1021 hughes rd ', 'kingston', '', 'TN', 'US', '37763')
INVALID SQL: 1062 : Duplicate entry '0-ip' for key 1
SQL QUERY FAILURE:INSERT INTO xcart_order_extras (orderid, khash, value) VALUES ('', 'ip', '70.88.83.58')

If the page is not updated in 2 seconds, please follow this link: continue >>

Then it goes to this

Access denied !

You are not allowed to access that resource!

Error ID: 59

balinor · #2 04-08-2008, 07:19 AM

That looks like a leftover problem from your e-mail address as username deal.

toolexperts · #3 04-08-2008, 07:29 AM

i think it may be an import issue...gah this product ghas a huge learning curve

toolexperts · #4 04-10-2008, 08:59 AM

Balinor, I replaced my cart.php and this fixed the error now the error is back and it's taking 45 seconds for the processing

balinor · #5 04-10-2008, 09:48 AM

Shawn, you have done so much editing to your store, I don't even know where to tell you to start

toolexperts · #6 04-10-2008, 09:56 AM

i am thinking this cart issue may be due to the sql_database holding old info or may be full? is that possible?

toolexperts · #7 05-06-2008, 09:01 AM

this was fixed..removed all customers, reuploaded the file by xcart specs all is well...life is good

2coolbaby · #8 05-07-2008, 11:54 AM

I am getting the same problem, but no longer the sql code, just the Access Denied Error: 59. Can you give me details of how your removed customers and replaced the file? I have an xcartdump.sql file, but it does not restore through x-cart and I am afraid of removing things and then not getting them back. I do not get an error when I try to restore, but there are orders in the restore which are not added, so I don't think the restore is working.

Help would be very appreciated.

2coolbaby · #9 05-07-2008, 01:51 PM

ALMOST SOLVED: I discovered that when the backup restored it took out the Auto Increment Settings in the Orders, Order_Details and the Order_Extras. Selecting Auto Increment in the Extra Field in Phpmyadmin for the Order ID in these 3 tables. I am still getting the error message for the User name, I think. Anonomous-0 is how this is coming up in the order, so I am not sure which field in what table I need to Auto Increment. Anyone have any ideas???