pat.motsumi Posted March 15, 2021 Share Posted March 15, 2021 I am constantly getting this error "Cart cannot be placed" after payment has been made. Which means its failing to convert the cart to order. I have observed in the database that more than 1 can be assigned the same cart_id, which means when the last order is placed it will fail since the first one has been placed using that cart Id. Kindly assist where i can fix because the error pops up regardless of the method of payment chosen Link to comment Share on other sites More sharing options...
musicmaster Posted March 15, 2021 Share Posted March 15, 2021 12 hours ago, pat.motsumi said: I am constantly getting this error "Cart cannot be placed" after payment has been made. Which means its failing to convert the cart to order. I have observed in the database that more than 1 can be assigned the same cart_id, which means when the last order is placed it will fail since the first one has been placed using that cart Id. Kindly assist where i can fix because the error pops up regardless of the method of payment chosen Sounds like the indexes or the auto-increase of the database table are missing. So compare those values with similar values of a fresh installation of the same PS version. 1 Link to comment Share on other sites More sharing options...
pat.motsumi Posted March 15, 2021 Author Share Posted March 15, 2021 3 hours ago, musicmaster said: Sounds like the indexes or the auto-increase of the database table are missing. So compare those values with similar values of a fresh installation of the same PS version. Where do i check please. because even if when someone has started adding to cart and he pause, then the second person adds to cart and proceed they get to be assigned the same cart_Id Link to comment Share on other sites More sharing options...
musicmaster Posted March 15, 2021 Share Posted March 15, 2021 This is database work. So phpmyadmin. Link to comment Share on other sites More sharing options...
pat.motsumi Posted March 15, 2021 Author Share Posted March 15, 2021 4 minutes ago, musicmaster said: This is database work. So phpmyadmin. yes i have access to phpM yadmin . find the structure of the cart table attached Link to comment Share on other sites More sharing options...
musicmaster Posted March 15, 2021 Share Posted March 15, 2021 id_cart has auto_increment so that is ok. For the keys you need to scroll down: Link to comment Share on other sites More sharing options...
pat.motsumi Posted March 15, 2021 Author Share Posted March 15, 2021 1 hour ago, musicmaster said: id_cart has auto_increment so that is ok. For the keys you need to scroll down: Link to comment Share on other sites More sharing options...
musicmaster Posted March 15, 2021 Share Posted March 15, 2021 41 minutes ago, pat.motsumi said: Ok, so the problem isn't there. I have some problem with your "Cart cannot be placed" text. I cannot find it anywhere in the PS 1.7.7.1 sourcecode. Yet finding where this comes from is important for solving the problem. Is it some module in your shop? Link to comment Share on other sites More sharing options...
pat.motsumi Posted March 15, 2021 Author Share Posted March 15, 2021 1 minute ago, musicmaster said: Ok, so the problem isn't there. I have some problem with your "Cart cannot be placed" text. I cannot find it anywhere in the PS 1.7.7.1 source code. Yet finding where this comes from is important for solving the problem. Is it some module in your shop? It comes from the FrontInitcontroller and paymentmodule Link to comment Share on other sites More sharing options...
musicmaster Posted March 15, 2021 Share Posted March 15, 2021 1 hour ago, pat.motsumi said: It comes from the FrontInitcontroller and paymentmodule Can you provide screendumps? Link to comment Share on other sites More sharing options...
pat.motsumi Posted March 15, 2021 Author Share Posted March 15, 2021 1 hour ago, musicmaster said: Can you provide screendumps? PaymentModule class frontController Link to comment Share on other sites More sharing options...
musicmaster Posted March 15, 2021 Share Posted March 15, 2021 1 hour ago, pat.motsumi said: PaymentModule class frontController I meant screendumps of the error message Link to comment Share on other sites More sharing options...
pat.motsumi Posted March 16, 2021 Author Share Posted March 16, 2021 21 hours ago, musicmaster said: I meant screendumps of the error message Link to comment Share on other sites More sharing options...
musicmaster Posted March 16, 2021 Share Posted March 16, 2021 16 minutes ago, pat.motsumi said: Please provide next time an exact copy of the error message. With your summary "cart cannot be placed" you wasted both my and your time. What is the "rave" module doing? Link to comment Share on other sites More sharing options...
pat.motsumi Posted March 16, 2021 Author Share Posted March 16, 2021 1 hour ago, musicmaster said: Please provide next time an exact copy of the error message. With your summary "cart cannot be placed" you wasted both my and your time. What is the "rave" module doing? Rave is a payment module.The error still occurs when you pay with the Rave(flutterwave card payments) and Cash On Delivery. The carts are assigned same cart_id which then conflict when you convert cart to order. Unfortunately after "cart cannot be placed", that cart is deleted and the user is redirected back to the login page which means the user will have to re-order. At this stage they wont be any cart summary but only that error. And the unfortunate part is when it log the cart cannot be placed , the money will have been deducted from the customer with no cart to order conversion which will make it hard to trace the order that was being paid because the order does not exist Link to comment Share on other sites More sharing options...
pat.motsumi Posted March 17, 2021 Author Share Posted March 17, 2021 On 3/16/2021 at 10:18 PM, musicmaster said: Please provide next time an exact copy of the error message. With your summary "cart cannot be placed" you wasted both my and your time. What is the "rave" module doing? Is the information provided on the previous post sufficient enough to assist me? 1 Link to comment Share on other sites More sharing options...
musicmaster Posted March 18, 2021 Share Posted March 18, 2021 Can you check whether any overrides are active? Prestools has a function for that and you can also look directly under the override directory. Link to comment Share on other sites More sharing options...
pat.motsumi Posted March 18, 2021 Author Share Posted March 18, 2021 4 hours ago, musicmaster said: Can you check whether any overrides are active? Prestools has a function for that and you can also look directly under the override directory. Link to comment Share on other sites More sharing options...
musicmaster Posted March 18, 2021 Share Posted March 18, 2021 59 minutes ago, pat.motsumi said: That doesn't answer my question. Link to comment Share on other sites More sharing options...
pat.motsumi Posted March 18, 2021 Author Share Posted March 18, 2021 How do i check if overrides are enabled. the only screen i came across was under performance. so i screenshoted so that you can guide where to look to Link to comment Share on other sites More sharing options...
musicmaster Posted March 18, 2021 Share Posted March 18, 2021 As I said: you cannot do that with the Prestashop backoffice. You should either to use Prestools or you can have a look yourself. This is hard work. You need to make a real effort. Link to comment Share on other sites More sharing options...
pat.motsumi Posted March 18, 2021 Author Share Posted March 18, 2021 9 minutes ago, musicmaster said: As I said: you cannot do that with the Prestashop backoffice. You should either to use Prestools or you can have a look yourself. This is hard work. You need to make a real effort. Ok. i will i just wanted guidance on where to go or to check. Link to comment Share on other sites More sharing options...
pat.motsumi Posted March 19, 2021 Author Share Posted March 19, 2021 20 hours ago, musicmaster said: As I said: you cannot do that with the Prestashop backoffice. You should either to use Prestools or you can have a look yourself. This is hard work. You need to make a real effort. Hei.. I also have realized that the "re-display cart at login" doesn't work. So i was wondering if its maybe one of the contributing factor to the "Cart cannot be placed"error Link to comment Share on other sites More sharing options...
musicmaster Posted March 19, 2021 Share Posted March 19, 2021 1 hour ago, pat.motsumi said: Hei.. I also have realized that the "re-display cart at login" doesn't work. So i was wondering if its maybe one of the contributing factor to the "Cart cannot be placed"error You can try setting "re-display cart at login" to No Link to comment Share on other sites More sharing options...
pat.motsumi Posted March 19, 2021 Author Share Posted March 19, 2021 (edited) 32 minutes ago, musicmaster said: You can try setting "re-display cart at login" to No yes i did. But i still have mutliple Cart assigned to 1 cartId Edited March 19, 2021 by pat.motsumi wrong spelling (see edit history) Link to comment Share on other sites More sharing options...
musicmaster Posted March 19, 2021 Share Posted March 19, 2021 I would need to have a look myself to analyse this. For that I would need to have access to the backoffice and the database. If you want that you can pm me with the access data. Link to comment Share on other sites More sharing options...
musicmaster Posted March 20, 2021 Share Posted March 20, 2021 On 3/19/2021 at 12:19 PM, pat.motsumi said: yes i did. But i still have mutliple Cart assigned to 1 cartId I also need more details. you write that "I am constantly getting this error "Cart cannot be placed" after payment has been made. Which means its failing to convert the cart to order. I have observed in the database that more than 1 can be assigned the same cart_id" That is very puzzling. Given that the index is there you should never see the same id more than once - at least not in the ps_cart table. So this could also be some problem with cookies. But to know more you should describe the problem in much more detail. Link to comment Share on other sites More sharing options...
pat.motsumi Posted March 21, 2021 Author Share Posted March 21, 2021 23 hours ago, musicmaster said: I also need more details. you write that "I am constantly getting this error "Cart cannot be placed" after payment has been made. Which means its failing to convert the cart to order. I have observed in the database that more than 1 can be assigned the same cart_id" That is very puzzling. Given that the index is there you should never see the same id more than once - at least not in the ps_cart table. So this could also be some problem with cookies. But to know more you should describe the problem in much more detail. Let me try explain it more. So when a user add products to cart a cartID is assigned. e.g 86.. When another user adds to cart also he can be assigned 86. So this behavior i have observed it in the admin panel under shopping carts. Then if 1 of the 2 customers process the order it will go through.Then when the second one process an order it will fail because already that cart ID has been used with the previous order.Then it will write cart cannot be placed. In the database everything is Ok and it doesnt allow 2 orders to be submitted with the same ID. Like u said i suspect that its an issue with cookies. The picture attached are all the orders that failed, the status was non ordered after sometime the status turn to abandoned cart. Issue 2: The shop doesnt re-display cart on login.Rather when the user logs out it automatically treat the cart as abandoned cart.When next time when the user order it will issue a new cartID Link to comment Share on other sites More sharing options...
pat.motsumi Posted March 21, 2021 Author Share Posted March 21, 2021 On 3/19/2021 at 6:05 PM, musicmaster said: I would need to have a look myself to analyse this. For that I would need to have access to the backoffice and the database. If you want that you can pm me with the access data. Ok. Sorry we have different timezones hence the delays in reponse. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now