Customer details lost afetr upgrade from 1.3.8a to 1.3.9b

I upgraded yesterday to 1.3.9b (and today to 1.3.9c !) and have noticed that the customer details have vanished. The orders are ok, names, addresses emails etc. but returning customers details have disappeared ! How can I retrieve the details from the old database (and without deleting new customers details) ?

This is weird, I've looked in the database and the "customers" and "address_book" tables show the customers details. But they aren't being picked up by the back office. Why ?

I should perhaps be more specific. When in Admin > Customers > Customers, I get the list of the customers but if I click on "edit" of a particular one, all the fields are empty. However, customers added since the upgrade have all their fields filled in. I hope this will help someone to identify the problem.

I had a call from a returning customer this morning who couldn't order because according to the database, he lives in the Aaland Islands (!) so I told him to create a new account, which he couldn't because his email address already existed in the database. So the info is there, its just not getting as far as my store !

What was your upgrade process?
ie: what have you done since the time when it worked vs when it suddenly no longer worked as expected.

It sounds like you've done something to damage the database somehow, but without knowing what you've done to get to where you're at, its hard to help you sort it out.

DrByte:

What was your upgrade process?
ie: what have you done since the time when it worked vs when it suddenly no longer worked as expected.

It sounds like you've done something to damage the database somehow, but without knowing what you've done to get to where you're at, its hard to help you sort it out.

I simply followed the upgrade instructions : created a new database, copied the old database into the new one and then used the update option in zc_install. I only noticed the customer details were empty this morning after the upgrade to 1.3.9c (I didn't look after the upgrade to 1.3.9b yesterday). Should I create a new database and reinstall from 1.3.8a ? If so, how to recover new orders and customers ?

The customer details are still there - if I login to my test account and click on "my account", my address, email etc. are still there. But if I attempt to place a new order, its as if the store had no info, apart from the fact that I apparently live in the Aaland Islands !

Check your database tables to be sure they all contain valid data, esp the address_book, customers, and customers_info tables.
Maybe your database copying process damaged something.

DrByte:

Check your database tables to be sure they all contain valid data, esp the address_book, customers, and customers_info tables.
Maybe your database copying process damaged something.

All 3 tables contain valid data - I've compared the old base to the new one and the info both contain appears to be the same.

I should add that I used PHPMyAdmin to create a new database and then to copy the data from the existing database into it. Now, looking at the two db, I see the old one's size is 8.64 MB whereas the new one's is only 3.86 MB !

Sounds like maybe you missed something. I suggest you dump both and compare them.

I should add that I used PHPMyAdmin to create a new database and then to copy the data from the existing database into it. Now, looking at the two db, I see the old one's size is 8.64 MB whereas the new one's is only 3.86 MB !

DrByte:

Sounds like maybe you missed something. I suggest you dump both and compare them.

Is there an easy way of doing this ? I can download the bases easily enough but how do I compare them ?

petek:

Is there an easy way of doing this ? I can download the bases easily enough but how do I compare them ?

I've attempted to compare both databases with Beyond Compare but the task is huge for an inexperienced eye. It looks like I'm stuffed.:cry: Suppose I restore the old database and then upgrade. Would I then be able to able to insert the 4 or five new orders and customers I've received today ?

I'm getting this message in my error logs :

[19-May-2010 13:40:07] PHP Warning:  array_merge() [<a href='function.array-merge'>function.array-merge</a>]: Argument #1 is not an array in /home/XXXX/public_html/XXXX/customers.php on line 1099
[19-May-2010 13:40:07] PHP Warning:  array_merge() [<a href='function.array-merge'>function.array-merge</a>]: Argument #2 is not an array in /home/XXXX/public_html/XXXX/customers.php on line 1101
[19-May-2010 13:40:07] PHP Warning:  reset() [<a href='function.reset'>function.reset</a>]: Passed variable is not an array or object in /home/XXXX/public_html/XXXX/includes/classes/object_info.php on line 29
[19-May-2010 13:40:07] PHP Warning:  Variable passed to each() is not an array or object in /home/XXXX/public_html/XXXX/includes/classes/object_info.php on line 30
```.

This appears to generate itself when I access the customers' info page in the admin of the site.

In object_info.php, I see there is a line which is quoted out, ie ```html
//this line should be added, but should be tested first:
//if (!is_array($object_array)) return;

When I enable this line, ie I remove the "//", the error message relating to the object_info.php file disappears but the one relating to customers.php remains. I've checked versions 1.38a, 1.3.9b and 1.3.9c of the file in Beyond compare and nothing seems amiss. Any ideas ?

I'm giving up on this. This morning, I've created a new database, copied the 1.3.8a database data into it and tested it on the site BEFORE upgrading. Apart from the fact that the site informed me that I needed to patch the database to the latest version, everything worked, ie all customer details were there no problem. Now, after upgrading, they've all disappeared again ! So I'm going back to 1.3.8a, perhaps I'll have better luck with version 2.

petek:

I'm getting this message in my error logs :

[19-May-2010 13:40:07] PHP Warning: array_merge() [<a href='function.array-merge'>function.array-merge</a>]: Argument #1 is not an array in /home/XXXX/public_html/XXXX/customers.php on line 1099
[19-May-2010 13:40:07] PHP Warning: array_merge() [<a href='function.array-merge'>function.array-merge</a>]: Argument #2 is not an array in /home/XXXX/public_html/XXXX/customers.php on line 1101
[19-May-2010 13:40:07] PHP Warning: reset() [<a href='function.reset'>function.reset</a>]: Passed variable is not an array or object in /home/XXXX/public_html/XXXX/includes/classes/object_info.php on line 29
[19-May-2010 13:40:07] PHP Warning: Variable passed to each() is not an array or object in /home/XXXX/public_html/XXXX/includes/classes/object_info.php on line 30

Well, I'm back onto 1.3.8a because I have to earn a living but I would like to upgrade one day. Does nobody have any idea why I get the above error message and why my client details are absent from the admin ? I carried out two new zc_installs today and both produced the same result. Its a bit depressing all of this.

I've found the answer :clap:. What occurred is that the list of countries in the new database didn't match those of the old one. I created (in 1.3.8a) a new zone "Metropolitan France excluding Corsica" because I can't deliver by sea to Corsica. All of my clients live in that zone otherwise they can't be clients. When I created the new base and imported the data from the old, I didn't get the country error message when I tested it before upgrading the database. It was only after the upgrade that the problem occurred ie "Metropolitan France excluding Corsica" appears to have been deleted in the upgrade process so all my clients defaulted to the "Aaland Islands" which produced the error. It would be nice to know why this happened however. Anyway, onto more interesting things...

Petek,
Dang those pesty little errors. Thanks for the fix on the feedback..

haredo:

Petek,
Dang those pesty little errors. Thanks for the fix on the feedback..

Yes, but why did it happen in the first place ? zc_install deleted my custom country zone : why ? Zat eez ze question !

the zc_install upgrade process for 1.3.9 doesn't delete any custom zone data

DrByte:

the zc_install upgrade process for 1.3.9 doesn't delete any custom zone data

Never mind, all is well now.