Invalid address #12115 - [PrestaShopException] - in classes/Address.php (line 529)

[annadumi]

 

Hello,

I have this issue with a customer. I checked in the database; he updated his address a few minutes before his order. I saw that a solution is to delete ps_cart content, but my question is: will it affect the BO orders section? The orders will be still there?

Thank you

 

[Rhobur]

I would say to not delete the cart but to check the customer's address for special characters and replace them if possible.

[annadumi]

Hello, 

Thank you for your answer.

Hmm, the problem is that the user updated his address, and in ps_address I don't have the row with the old address (the one with id 12115 in ps). It will be ok if I duplicate a row and add the 12115 id manually?

Thank you

 

 

[Rhobur]

No, do not add it manually as it is likely to break the relationship with the other tables.
Try to correct all addresses of this customer, the usual cause for issues like this is they include some characters PS doesn't like.

[annadumi]

The problem is that after updating the address the row doesn't exist in the database. 

Initially, the user has id 12115; he makes an update and adds 12117 row. After 3 months he made another update and now he has 16555 row. The 12117 row still exists, but the first one 12115 is not in the database anymore. 

I checked for special characters or something like that and the text is fine.

[Rhobur]

Does the address have all fields filled with data? If not try fill them.

[annadumi]

Yes, the address has all fields filled. But if I try to see more info about this customer his account refers to the old address which is not in the database anymore (I can't understand what he did but the row is missing)

[Rhobur]

It is normal the address is recreated with the new id what should happen though is for the other address ids to be removed form the other tables where they are referenced.

[annadumi]

Ok, thank you for the explication, but in this situation (all the rows are filled and don't have special characters) what should I do?

[Rhobur]

well, you could try as described in this older post, https://www.prestashop.com/forums/topic/396061-solved-messed-up-shopping-cart-ids/# but make sure you do a full DB backup first.

[annadumi]

Hello, thank you for your recommendation, but in the older post the problem is with the cart, not with the user address. In my situation the problem is with the address id allocated to this user. 
In my opinion, the user made an order and after he sent the order he changed the address, so, now, the sistem doesn't know what address is correct.  

 

Thank you

[Rhobur]

The issue is similar, you had to read the Solved message where it described how to solve the extra cart ids.
But of course feel free to look for other solutions as well.

[c64girl]

I fixed with this if someone interested:

https://prestamaniacs.com/free-modules/92-fix-invalid-address.html

[jisas7]

perfecto si! yo tenia el mismo problema y el modulo este parece que lo ha solucionado

[edoluz]

  On 11/16/2023 at 8:10 AM, c64girl said:

I fixed with this if someone interested:

https://prestamaniacs.com/free-modules/92-fix-invalid-address.html

Expand  

Thank you so much. This page helped me solving the problem: I didn't download the module but (can be a little risky because you are using Phpmyadmin and Mysql, so you should make a backup first to stay safe)

1. I went into the ps_cart table and found the customer's carts
2. Then I found the cart that was broken (it contained an address id that doesn't exist anymore, maybe after a PS upgrade made by an external agency who cleaned some data)
3. and I replaced the old address id with an existing one of the same customer

Now I cann access the customer's page in BO and edit it.

Thank you all!