PrestaShopException Invalid address # SHOP DOWN

[flowers_ph]

Ive keep getting this issue which completely stops my customer buying products (see image). I apply this fix that solves the problem:

 

does anyone know how to solve the issue permanently? The fix is only temporary as it leaves me to constantly check if the error has happened again and again.

Any help is much appreciated..

 

thanks
 

[Rhobur]

you probably deleted some directly in the DB tables and as such the indexes are bad and not correlated anymore; it would require someone with DB skills to correct such issues.

[flowers_ph]

Thanks for the help. It seems to only happen when a customer deletes an address. The shop works fine for some orders until a deletion happens then I have to add the row in Ps.address

 

[flowers_ph]

17 hours ago, Rhobur said:

you probably deleted some directly in the DB tables and as such the indexes are bad and not correlated anymore; it would require someone with DB skills to correct such issues.

can you give me an idea about where in the db i might look. I'll rebuild my shop locally and test

[Rhobur]

there are only two tables having an id_address field, ps_address and ps_warehouse; I think you should check ps_address where both id_address and id_customer are indexes; id_customer is then used in ps_cart, ps_cart_rule,  ps_customer, ps_customer_group. ps_customer_thread, ps_orders, ps_order_slip, ps_order_return.

So everything related to a customer is linked to him/her having an id_address and of course these two indexes id_address and id_customer must be correlated.