CE Phoenix Cart Forum

burt wrote: ↑Sun Aug 03, 2025 1:35 pm This for all customers?
Just one customer?

Can you rewrite this:

> I checked database though fields are not filled in customer and address book but there is no wrong value in any column, only the defaults for the ones that are empty.

As I can't understand if you have customer fields or if they are blank.

burt wrote: ↑Sun Aug 03, 2025 2:06 pm All customers?
One customer?

ecartz wrote: ↑Sun Aug 03, 2025 3:12 pm It's telling you that some of your customers have no valid default address. If you go through the database and set the customers_default_address_id (on the customers table) to one of the addresses in the address_book for that customer, it should fix it.

Start with

Code: Select all

SELECT customers_id, customers_default_address_id FROM customers WHERE customers_default_address_id = 0

then

Code: Select all

SELECT customers_id, customers_default_address_id FROM customers WHERE customers_default_address_id IS NULL

then

Code: Select all

SELECT c.customers_id, c.customers_default_address_id FROM customers c LEFT JOIN address_book ab ON c.customers_id = ab.customers_id AND c.customers_default_address_id = ab.address_book_id WHERE ab.address_book_id IS NULL

That will tell you which customers have the problem.

For each of those, you can do

Code: Select all

SELECT * FROM address_book WHERE customers_id = 

and add the customer ID at the end. That will tell you what addresses they have available. If you do this in another window, you can update the customers_default_address_id directly in the search results from the previous queries.

If you want to try to hack around it, you can change line 52 of from

Code: Select all

      $this->data[$to] = array_filter($address_query->fetch_assoc(), function ($v) { return !Text::is_empty($v); });

to

Code: Select all

      $this->data[$to] = array_filter($address_query->fetch_assoc() ?? [], function ($v) { return !Text::is_empty($v); });

which will at least quiet that error.

The reason why core does not do that is that that error is telling you that something is wrong with the customers_default_address_id. It would be better to fix that problem, as it will cascade out to other problems.