| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | User manuals | Login |
Checkout Issues...not sure if this is right area...sorry balinor | |||
|
|
Thread Tools | Search this Thread |
#1
|
|||||||
|
|||||||
Checkout Issues...not sure if this is right area...sorry balinor
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
__________________
Tool Experts X-Cart DB Version: 4.1.12 GOLD |
|||||||
#2
|
|||||||
|
|||||||
Re: Checkout Issues...not sure if this is right area...sorry balinor
That looks like a leftover problem from your e-mail address as username deal.
__________________
Padraic Ryan Ryan Design Studio Professional E-Commerce Development |
|||||||
#3
|
|||||||
|
|||||||
Re: Checkout Issues...not sure if this is right area...sorry balinor
i think it may be an import issue...gah this product ghas a huge learning curve
__________________
Tool Experts X-Cart DB Version: 4.1.12 GOLD |
|||||||
#4
|
|||||||
|
|||||||
Re: Checkout Issues...not sure if this is right area...sorry balinor
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
__________________
Tool Experts X-Cart DB Version: 4.1.12 GOLD |
|||||||
#5
|
|||||||
|
|||||||
Re: Checkout Issues...not sure if this is right area...sorry balinor
Shawn, you have done so much editing to your store, I don't even know where to tell you to start
__________________
Padraic Ryan Ryan Design Studio Professional E-Commerce Development |
|||||||
#6
|
|||||||
|
|||||||
Re: Checkout Issues...not sure if this is right area...sorry balinor
i am thinking this cart issue may be due to the sql_database holding old info or may be full? is that possible?
__________________
Tool Experts X-Cart DB Version: 4.1.12 GOLD |
|||||||
#7
|
|||||||
|
|||||||
Re: Checkout Issues...not sure if this is right area...sorry balinor
this was fixed..removed all customers, reuploaded the file by xcart specs all is well...life is good
__________________
Tool Experts X-Cart DB Version: 4.1.12 GOLD |
|||||||
#8
|
|||||||||
|
|||||||||
Re: Checkout Issues...not sure if this is right area...sorry balinor
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.
__________________
Mary Lee ------------------- Dinner and a Murder Mystery Games http://www.dinnerandamurder.com x-cart version 4.7.5 / Mac OS 10.10.5 and Windows 8/10 sometimes - Ideal Responsive Template |
|||||||||
#9
|
|||||||||
|
|||||||||
Re: Checkout Issues...not sure if this is right area...sorry balinor
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???
__________________
Mary Lee ------------------- Dinner and a Murder Mystery Games http://www.dinnerandamurder.com x-cart version 4.7.5 / Mac OS 10.10.5 and Windows 8/10 sometimes - Ideal Responsive Template |
|||||||||
|
|||
X-Cart forums © 2001-2020
|