Issue with an old address that can't be modified or deleted (PS8.1)

[DARKF3D3]

Hi everyone,
recently a customer contacted me saying that he was having problems modifying his delivery address.
When he tries to change it, an error 500 it's showed.
From the server log i see this:

2025-02-25 09:53:31
Error 93.xxx.xxx.xxx 500 POST
/ordine?id_address=1792
HTTP/2.0
https://www.website.it/ordine?id_address=1792&editAddress=delivery&token=xxxxxxxxxxxxxxxxxxxxxxxx
Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Mobile Safari/537.36 4.24 K
Accesso SSL/TLS Apache

When I try to save this address from the back end this error it's showed:
The address fields contain invalid values

So I replace all the data with some other. And whn saving this error it's showed:
Internal error #An error occurred when updating address object with id "1792"

The same if i try to delete it:
Internal error #An error occurred when deleting address object with id "1792"

The problem it's only with this address, the customer it's able to add new addressed and edit them.

Atually I have not been able to replicate the problem on other address/customers.
This is an old account (and address too), I think about 10 years old.
So I think it might be something related to the PS updates made over all these years (started with PS1.4).

Any idea what can cause this and how to fix it?

 

[Daresh]

Maybe some field of the address is null, while it should be an empty string instead? Try to edit this address directly in the database or compare the fields with some correct address.

[DARKF3D3]

@Daresh
I haven't yet try to edit it from the database (I will check soon), but it's strange because I tried also to fill all the fields with some random valid value, so there should be no empty or null fields.

[Knowband Plugins]

Yes, it's due to some empty fields saved in the DB. 

Firstname, lastname, address1, city & id_country are the mandatory fields & these should not be empty. 

[DARKF3D3]

@Knowband Plugins
I just checked into database and all the fields seem to be filled correctly.
I also noticed that esch time editing the address from back end, after the the error "Internal error #An error occurred when updating address object with id "1792".
Into the address list, a new address it's saved.

 

Edited February 25 by DARKF3D3 (see edit history)