ButikSalam Posted January 31, 2019 Share Posted January 31, 2019 (edited) Hello I'm having a critical issue that whenever a user places a new order, it does so with the wrong ID for address. That means if USER1 was ordering something, I would get USER2's information/delivery-address on my back office under "DELIVERY ADDRESS". The critical issue in this, is that when USER1 goes to check his Order History in his account, it shows USER2's information which is a serious violation of user information privacy. I have checked the database and the issue is that whenever a new order is made, it's generating OLD and USED ID's and not generating unique and new ones? I have tried running PS cleaner, and I have tried reinstalling everything and updating to 1.7 -- same error still occurs. There is over 10k+ orders and 12k+ customers, so I cannot go through the MySQL database and manually edit the USED ID's to some newly generated unique ID -- and I also need this to be fixed for future customers/orders being placed. See attached screenshots for further information/what it looks like. Critical information is blurred out for obvious reasons. Please, someone help me in the slightest direction. I have tried searching for the same errors, but I only found threads where there were no solution or threads where people said to use PS Cleaner, but I have tried this without luck. *EDIT: Added some other topics regarding the same issue. Thanks for reading & best regards, Butik Salam Edited January 31, 2019 by ButikSalam Added some other topics regarding the same issue. (see edit history) Link to comment Share on other sites More sharing options...
garciasanchezdani Posted April 23, 2019 Share Posted April 23, 2019 (edited) Hi, I have the same problem. Did you find any solution? I also read about the possibility that the causer is a social module login. Do you have any module like it installed? In our case, yes, we have installed and activated the free module Social Loginizer https://www.knowband.com/es/prestashop-social-loginizer We're in contact. Best regards, Edited April 23, 2019 by garciasanchezdani (see edit history) Link to comment Share on other sites More sharing options...
nomealternativo Posted May 13, 2019 Share Posted May 13, 2019 Did you guys found any solution? I have this problem too, it happens once in a while and my ps version is 1.6.1.4. The only thing can handle address other than ps is paypal, could it be his fault? Regards. Link to comment Share on other sites More sharing options...
Smiles Posted June 19, 2019 Share Posted June 19, 2019 Hi Guys I have this issue but then opposite, customer is logged in as another customer. With checkout he sees the right address but the order is basically placed under the wrong account. Did any of you had any luck with this? Link to comment Share on other sites More sharing options...
rancidio Posted October 23, 2019 Share Posted October 23, 2019 i have the same problem, did you find a solution? Link to comment Share on other sites More sharing options...
Smiles Posted October 23, 2019 Share Posted October 23, 2019 (edited) Yes seems to be the micro caching on the vps server. Don't know the details though.... Edited October 23, 2019 by Smiles (see edit history) Link to comment Share on other sites More sharing options...
Josip Posted November 29, 2019 Share Posted November 29, 2019 I have the same problem from time to time. Anybody? Solution? PS:1.7.4.4. Regards Link to comment Share on other sites More sharing options...
Statuesque Posted January 7, 2020 Share Posted January 7, 2020 Had this happen twice recently. The only reason it was spotted is that both times, the address has the name of the wrong customer included so it's easy to spot. I am expecting that the fix will be added as a purchasable module by prestashop as any form of utility nowadays for this platform needs to be purchased. Link to comment Share on other sites More sharing options...
kllif Posted April 15, 2020 Share Posted April 15, 2020 I have the same problem, did you find a solution? Link to comment Share on other sites More sharing options...
Smiles Posted April 15, 2020 Share Posted April 15, 2020 Ask host about micro caching 😉 Link to comment Share on other sites More sharing options...
kllif Posted April 15, 2020 Share Posted April 15, 2020 9 minutes ago, Smiles said: Ask host about micro caching 😉 should it be enabled or disabled? Link to comment Share on other sites More sharing options...
Smiles Posted April 16, 2020 Share Posted April 16, 2020 Well, for thirty bees it should be disabled. Link to comment Share on other sites More sharing options...
Statuesque Posted April 22, 2020 Share Posted April 22, 2020 On 4/15/2020 at 8:54 PM, kllif said: I have the same problem, did you find a solution? No, still does it randomly but it's maybe 1 in 500-1000 orders it happens on and it's easy to spot when it does. I am wondering though if the issue is linked to carts. Prestashop will every so often mess up the cart numbers so they do not match the order numbers and it requires a quick adjustment via going in to sql database. I wonder if the wrong customer name is maybe being caused by a customer taking another customers cart? Not sure it's possible but just a theory as I now check the cart number in the database auto increment every month or so and hardly see the name issue now. This was the correction I found for the cart issue. Link to comment Share on other sites More sharing options...
miguel_enigmo Posted December 13, 2021 Share Posted December 13, 2021 Hello everyone, 12/2021 and still having the same issue (randomly) Has anyone found a solution? Thanks in advance Link to comment Share on other sites More sharing options...
Statuesque Posted December 13, 2021 Share Posted December 13, 2021 [SOLVED] Messed up shopping cart ID's - Configuring and using PrestaShop - PrestaShop Forums https://www.prestashop.com/forums/topic/396061-solved-messed-up-shopping-cart-ids/ Link to comment Share on other sites More sharing options...
miguel_enigmo Posted December 13, 2021 Share Posted December 13, 2021 1 hour ago, Statuesque said: [SOLVED] Messed up shopping cart ID's - Configuring and using PrestaShop - PrestaShop Forums https://www.prestashop.com/forums/topic/396061-solved-messed-up-shopping-cart-ids/ So it finally has to do with cart id's? We might try this. Thanks mate Link to comment Share on other sites More sharing options...
Giordx Posted February 25, 2022 Share Posted February 25, 2022 Hi, same issue for me. I did try to understand what to do in phpMyAdmin, can someone explain better? go to ps_cart table in your database open table settings page check value of AUTO INCREMENT param compare it with last cart id in ps_orders then setup AUTO INCREMENT to last cart id from ps_orders +1 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