Customer address not appearing in admin>customers - all of a sudden!

[DaxtheMan]

Hi

Can anyone help please?

Running 1.5.8a with PHP8.2

All of a sudden I have a weird problem. Started 7th Dec but site working just fine before that!

In admin>customers (index.php?cmd=customers) the customers list correctly. However, when Edit is pressed the page loads perfectly except for the customer's address. Refresh that page and the address loads.

Meanwhile, in the logs, this error is repeated:

[13-Dec-2023 15:27:13 Europe/London] Request URI: /admin/index.php?cmd=customers&page=1, IP address: 51.185.139.30, Language id 1
#0 /var/www/vhosts/xxxxxxx.co.uk/httpdocs/includes/classes/Customer.php(282): zen_debug_error_handler()
#1 /var/www/vhosts/xxxxxxx.co.uk/httpdocs/includes/classes/Customer.php(29): Customer->load()
#2 /var/www/vhosts/xxxxxxx.co.uk/httpdocs/admin/customers.php(1622): Customer->__construct()
#3 /var/www/vhosts/xxxxxxx.co.uk/httpdocs/admin/index.php(11): require('...')
--> PHP Warning: Undefined array key "address_book_id" in /var/www/vhosts/xxxxxxxco.uk/httpdocs/includes/classes/Customer.php on line 282.

[13-Dec-2023 15:27:13 Europe/London] Request URI: /admin/index.php?cmd=customers&page=1, IP address: 51.185.139.30, Language id 1
#0 /var/www/vhosts/xxxxxxx.co.uk/httpdocs/includes/classes/Customer.php(282): zen_debug_error_handler()
#1 /var/www/vhosts/xxxxxxx.co.uk/httpdocs/includes/classes/Customer.php(29): Customer->load()
#2 /var/www/vhosts/xxxxxxx.co.uk/httpdocs/admin/customers.php(1622): Customer->__construct()
#3 /var/www/vhosts/xxxxxxx.co.uk/httpdocs/admin/index.php(11): require('...')
--> PHP Warning: Undefined array key "zone_id" in /var/www/vhosts/xxxxxx.co.uk/httpdocs/includes/classes/Customer.php on line 282.

[13-Dec-2023 15:27:13 Europe/London] Request URI: /admin/index.php?cmd=customers&page=1, IP address: 51.185.139.30, Language id 1
#0 /var/www/vhosts/xxxxxxx.co.uk/httpdocs/includes/classes/Customer.php(282): zen_debug_error_handler()
#1 /var/www/vhosts/xxxxxxx.co.uk/httpdocs/includes/classes/Customer.php(29): Customer->load()
#2 /var/www/vhosts/xxxxxxx.co.uk/httpdocs/admin/customers.php(1622): Customer->__construct()
#3 /var/www/vhosts/xxxxxxx.co.uk/httpdocs/admin/index.php(11): require('...')
--> PHP Warning: Undefined array key "country_id" in /var/www/vhosts/xxxxxxx.co.uk/httpdocs/includes/classes/Customer.php on line 282.

[13-Dec-2023 15:27:13 Europe/London] Request URI: /admin/index.php?cmd=customers&page=1, IP address: 51.185.139.30, Language id 1
#0 /var/www/vhosts/xxxxxxco.uk/httpdocs/admin/customers.php(1668): zen_debug_error_handler()
#1 /var/www/vhosts/xxxxxxx.co.uk/httpdocs/admin/index.php(11): require('...')
--> PHP Warning: Undefined array key "company" in /var/www/vhosts/xxxxxx.co.uk/httpdocs/admin/customers.php on line 1668.

includes/classes/Customer.php is unaltered from virgin 1.5.8a version.

I am at a loss where to search to see what is triggering this response. There doesn't appear to be any activity in the database on the 6-7th Dec to have caused this change and no site alterations were made (actually on vacation at the time)...

Would appreciate any pointers to solve this one!

[DaxtheMan]

Me Again!

Okay, so I have noticed something that may be the cause. In the table 'Customers' the 'customers_default_address_id' column has the same for every customer!

I feel that the number there should match the address_book_ id in the address_book table but doesn't.

Can anyone confirm that the assumption above is correct?

If so, can anyone suggest a way to re-connect the two tables so they tally?

Thanks

Dax

[swguy]

Write a script that for each record in the customers table, finds a record in the address book table (with address_book_id >= customers_id) where customers_firstname = entry_firstname and customers_lastname = entry_lastname. This will hopefully fix most of them.

[DaxtheMan]

Thanks SWGUY

So I'm thinking:

INSERT INTO customers (customers_default_address_id)
SELECT address_book_id
FROM address_book
WHERE customers_id = customers_id and
customers_firstname = entry_firstname and
customers_lastname = entry_lastname

Since there are 20000 names I don't want to mess this up!

Can anyone confirm the above or suggest better script?

Thanks

[DaxtheMan]

This is the SQL I finally used.

UPDATE customers INNER JOIN address_book ON customers.customers_id = address_book.customers_id SET customers.customers_default_address_id = address_book.address_book_id
WHERE customers.customers_firstname = address_book.entry_firstname and customers.customers_lastname = address_book.entry_lastname

Hopefully that will be an end to it!

[mc12345678]

Well perhaps for existing customers, but what about new ones? Further, figured out why the above was necessary?

[swguy]

Good point - it would be worth creating a new (test) storefront account and being sure the customers_default_address_id is set correctly.

[gothstone]

following, I suddenly have the same issue and no clue why

[gothstone]

For my site the issue happened sometime between Nov 26th and Dec 13th. The last real change I made was switching from PayPal Pro to the paid version of the Square module, but it can't have been the installation of Square because I did that to my dev site first, and my dev site didn't have the messed up default addresses. I also installed lat's access blocker, but that shouldn't come close to touching the addresses...
just trying to throw out info here in hopes someone figures this out.

[jjone]

This is a zen cart 1.5.8a bug
------------------------------------
This is how to test it: first change all customer default address id to a same number with following sql.

UPDATE customers set customers_default_address_id = 10

-------------------------------------------------------------------------------------
Now, login to your zen cart admin and goto Customers and click on any customer

after that, open phpMyAdmin and refresh the customers tables

all rows of customers_default_address_id are set to a same wrong address id.

something is wrong with the customers.php, customers_default_address_id should only update only 1 customer.

Thank you