Guest The Shadow Posted May 15, 2005 Share Posted May 15, 2005 Hi, I haven't been able to get the confirmed.php url to work at all. After a customer returns back from the gateway when making a payment they get this error: MySQL Error Occured 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 'Shipping, `subTotal`= 1.00, `tax`= 0.00, `shipCost`= 0.00, `gra QUERY = UPDATE CubeCart_sessions SET `conts`=Array, `delInf`= Array, `shipMethod`= Free Shipping, `subTotal`= 1.00, `tax`= 0.00, `shipCost`= 0.00, `grandTotal`= 1.00, `gateway`= PicPay, `cart_order_id`= 050515-143704-7556, `counted`= 1, `customer_comments`= , `basket`= '' WHERE basket LIKE '%050515-143704-7556%' It works ok if the customer cancels the gateway though. This error is only when a payment is made. Does anyone know what is causing this? I am using the latest version 3. Thanks, Matt Quote Link to comment Share on other sites More sharing options...
Guest Posted May 16, 2005 Share Posted May 16, 2005 customer??? are you using cc3 on a live store :innocent: Quote Link to comment Share on other sites More sharing options...
Guest rocketero Posted May 16, 2005 Share Posted May 16, 2005 that seems like an error in the code, I hope it gets fixed so the purchase get confirmed and client gets returned to the store site after purchase is made by paying the picpay shopping cart. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.