- Priority: 0
- Status: Closed
- Theme: Alysum
-
Assigned To:
Marek
- Private: No
- Open Date: 08.09.18, 22:58
- Opened by: Alessandro Borsani
- Closed by: Marek
- Closed on: 12.12.18, 15:53
- Reason: Closed
- Comment: Glad to help!
Ticket #12880 - huge problem with addresses of customers
Hi Marek,
Now that I’m online I have a very huge problem!!!
I have deleted all customers and addresses before to go online. And I make it some times before to chechek that all was ok.
PROBLEM:
If you try to make an order with Express Checkout after you have put a product in the cart, you can compile fields name, surname and mail address. Then if you compile also address’fields al go right. But after you delete all products in cart and re-make a new order like guest (checkout express). After you will compile name, surname and mail adress you will find “your address” already compile with an address that probably PS foundes in your database.
I see a very strange situation that you can see in BO–>customer—>adresses: you will see another address (with ID different from ID sequential correct that counts new customers)
I attached the file to explain better and I hope you can help me because now that I’m online I need to fix this important issue.
I test in a test site with PS 1.7.4.2 template base and all works good but I’m sure that before to go online all works good because I make a lot of test. I think that delete order, customer and cart make something wrong on my database.
I need your help, I hope you can give me a solution now that i have customers ready to buy.
Grazie!!!
Comments
Please Marek try to make a express checkout also without conclude the order and paymaent, after you remake order with express checkout and you would see the problem. I hope to explain, for any question pls contact me.
Thank you
I see in myPHPadmin databse table of address and I attached the file to explain and I hope to help you to understand
this is scrennshot of guest and customer in database
Hi, Alessandro.
Sorry for the delay. I was out these days on weekend. I’ll back to you tomorrow in the morning.
Hi Marek, no problem!
I only hope that you can advise me a solution because this is a problem for me now that I have to start with sales.
Someone in Prestashop’s comunity advises me to install PS cleaner module to verify that DB is not damage. But I prefer to know your idea before to make something wrong.
Thank you
Do you mean this? http://take.ms/ddn3u
Hi Marek, sorry for delay, I was busy for a meeting.
Yes, You have saw that addresses autocompile.
Honestly I have no idea what’s wrong. I see such issue first time.
First what we ned to do is to figure out what cause the problem, theme or prestashop core.
The best way to do that is to switch back to Classic prestashop theme and check out the issue there. But it could change some store settings what you configured, so would be better to make development version of your store and did it there to be safe.
Hi marek, but I have already a site that I can use like a test. But I am sure that during a development of the site I make a lot of test and this problem there isn’t. So I think that when I deleted all customers,cart,… data something goes wrong and generated the issue.
Prestashop community advises me to install PS cleaner module and I already installed this module but I have to be sure that it doesn’t delete my catalog.
Is it hard for you to make a copy of your store to make tests there?
I have a site to test at following address https://shop1.bitistudio.net What have I to do? because I have the backup file and database of my site but I think that I can’t copy this in my test site but i have to migrate.
Do you know a simply mode to make a copy of my site in other domain or subdomain?
Thank you
Is there such issue exists?
Yes also in PS.17.4.2 with Alysum theme installed like you find in https://shop1.bitistudio.net you find a issue
In attached file you can see the problem. I have not put address but I have just make a order like a guest and I find address already compile from previously data that I don’t know where prestashop brings.
If you make a order at https://shop1.bitistudio.net you can se the issue (remember to make order like a guest and after you delete your cart and remake an order with new guest and you will see the issue)
I hope to explain the problem
Try to switch to Classic theme and test it out
ok I try now and after I’ll write you
So:
I checked and I see this:
- in PS 1.7.4.2 with default theme if you compile a new guest (with express checkout) for the first time all ok but if you remake an order with guest (and you have not delete all navigation data) after you have put name, last name and mail you find the address already compile and I think this is a problem of core Prestashop or about cache of browser that you autocompile because you have not delete cache (or data navigation) beetween a guest order and next one.
- in my shop I also see that I have an ID adress not sequential. Please check the attached file. Do you think that If I delete all table in DB (guest,customer,address) is not a solution?
You don’t have to delete database tables, you can only delete table data. The table must be there and be empty. Please try.
OK I try now. Have you understand the problem what i mean?
I think that checkout express who memorized data with browser cache is not great solution… (about PS i mean)
Yes, I see, I also think so, but I have no idea hoe to change that
Marek, now it seems to go rights. Like in default template PS. Now I try to make a lot of test and after I tell you another time.
I have deleted all fielsd in DB.
But the problem with ID in guest now is not duplicated but ID doesn’t restart with number 1…
Ciao Marek…. I think to have fixed the problem. I have also installed PScleaner module of native Prestahop addons. With module you can delete all DB data like customer, guest, cart…. but main important function is: optimization and verify of functional integrity of your DB.
I advice to use this to give a optimization and now it seems to work good. I wanted to share solution because I think that is always important in support cases. Thank you
Hi, Alessandro.
I’m glad the problem is solved. I have long time experience with Prestashop and never see such issue. But ok, I’ll keep this ticket for future
Good luck
Ciao Marek, also me I use PS from 2006. But DB issue probably has been generated from delete some order and addresses from BO and not from PHP my admin directly in the table and this maybe the cause.
But the problem about browser cache that memorized address if you make 2 consequential order by guests is a problem in all PS version (have you tried?) and this is a issue that I think prestashop’s developper must fix.
Don’t you think?
Grazie
Yes, I agree with your conclusion