I cannot order something..
So, when I go on the website I put in my email and mailing address and things but then when I hit secure checkout before I go to put my card information in, it says... 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USD' and order_total = '89.1' order by orders_id desc limit 0, 1' at line 2
in:
[select * from orders where orders_status='910' and payment_module_code = 'securepayment' and customers_email_address = 'my email address'' and currency = 'USD' and order_total = '89.1' order by orders_id desc limit 0, 1]
How do I fix this so I can finish my order???????
Sorry for the problem with completing the order because of the 1064 error. I am unfortunately not sure what website you're referring to. If you can provide us more information we may be able to try to look into the matter for you. If you are a customer, please provide us a URL, steps to produce the error, and more information about the ecommerce solution you're trying to use. If you're referring to a website that you're trying to order from, then you may need to communicate with the owner of that site to let them know you're having problems with an order.
Please provide us a little more information and we'd be happy to help! If you have any further questions, please let us know.
Kindest regards,
Arnel C.