Jump to content

Other product in cart


prestaisrael
 Share

Recommended Posts

Other product in cart.
When customers add a product to the shopping cart when they move to the shopping basket, they appear to have other products that appear to be from another customer, and sometimes the name of the customer with whom the cart is replaced appears.
I'll be happy to solve it urgently, customers are at a loss

Sorry for the English sad.gif

Share this post


Link to post
Share on other sites

This problem is most likely known as a problem when the referential integrity of your database is broken. This can happen when doing a server move or manually manipulating tables or deleting test orders. It might not be quite easy to fix. We have done this several times for different customers but the tables which trigger the error with wrong products can be different.

Edited by Scully (see edit history)

Share this post


Link to post
Share on other sites

Server problem is a very general term. I understand it as a server setting from outside of prestashop like PHP settings, database configurations et cetera. And with this understanding I would say is very likely NOT a server problem. We run PS 1.6.1.15 on many installations and have never faced such a problem with the exception of the causes mentionned in my first post.


But if you want to rule out a server problem. Check your webservers error log. If it show errors related to carts or order processing this would be the next step to evaluate.

Share this post


Link to post
Share on other sites

There was no error in ERROR_LOG

I matched the ID in PS_CART - if you mean this error, the problem still exists

 


It seemed to be passing cookies among the customers.

You can check it out in a normal window and open the shopping cart in an incognito window and see it happen

Edited by prestaisrael (see edit history)

Share this post


Link to post
Share on other sites

Ok, if you don't have errors logged in your logfile this lets me think there is no server configuration mismatch. I come back to my initial post and still heavily assume some kind of referential problems in your database. And id cart is way not enough to check. Think it over: what did you change in your system before you first saw the issue of wrong products. It doesn't get wrong if there weren't impacts to cause it.

 

However it would probably get endless to solve your issue in the forum since you might not be able to upload your complete database here.

Share this post


Link to post
Share on other sites

Thanks for the help :)

I can not remember what caused the problem.

What solution, where and what should I check more?

 

What I say is that I have reinstalled a clean installation of Presto Shop, which means that the DataBase is also new, and that there were no orders or carts deleted, and there, too, there is the problem (on the same server)

Edited by prestaisrael (see edit history)

Share this post


Link to post
Share on other sites

The solution is to check the  integrity of the whole database. In very short it means to check table keys against all tables related to those keys. But even with a small shop it wouldn't be doable by hand because of the amout of data. As per experience I can also say that these checks usually result in several key mismatches, not only one.

 

You can send me a PM if you want me to solve the issue within reasonable time. We needed a backoffice account as well as a direct access to the database to fix the problem. SSH would be good if available because it saves some time.

Edited by Scully (see edit history)

Share this post


Link to post
Share on other sites

Ok, very good. Thanks for this update.

 

Sounds like you have a quite non - typical setup for your installation. We always make sure no server-side caching takes place at cart and order processing steps. Having turned it off for these steps it does not compromise the servers data integrity even if there would exist a faulty chaching mechanism.

 

Good luck !!

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More