older customer info not found

Hi All, i have a huge problem.

I had made a new store and everything was working perfect. I even had all the old customers info imported into my new database an that was up and running prefect.

I could view the customers info in admin without any problems.

BUT.....

After a server updat of my hosting provider everything changed.

I can not view the customers info of older customers. I am getting the following errord:

Customers-customers- ilonka

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/ilonka/domains/fritenglas.nl/public_html/admin/customers.php on line 1020

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/ilonka/domains/fritenglas.nl/public_html/admin/customers.php on line 1022

Warning: reset() [function.reset]: Passed variable is not an array or object in /home/ilonka/domains/fritenglas.nl/public_html/admin/includes/classes/object_info.php on line 29

Warning: Variable passed to each() is not an array or object in /home/ilonka/domains/fritenglas.nl/public_html/admin/includes/classes/object_info.php on line 30

When i choose to edit the customer details, i am getting the following errors

Warning: reset() [function.reset]: Passed variable is not an array or object in /home/ilonka/domains/fritenglas.nl/public_html/admin/includes/classes/object_info.php on line 29

Warning: Variable passed to each() is not an array or object in /home/ilonka/domains/fritenglas.nl/public_html/admin/includes/classes/object_info.php on line 30

And all the fields are empty

What happened and what can i do to get back the details?

The strange thing is that i can log in to the store as a customer and all my details are shown in their..

I tried to enter the details myself but then i am getting the error that the e-mail address is already in use.

Thanks Ilonka

After a server updat of my hosting provider everything changed

Exactly what did your host update?

i don't know, they did not tell.
But they are ensuring me that my problem has nothing to do with the server update....

How exactly did you get your "customers imported" ?

Zen Cart currently uses three tables for handling customer information:

• address_book
• customers
• customers_info

If all the data in those tables is not kept in sync, you will get errors similar to what you described.

HI DrByte,

I have checked those three and they all have the customers details. BUT....

Now i have found out that all my new customers. ( ID 44 - 56) Are not anywhere in my database.

SO... my guess is that it has something to do with this.
But i don't have a clue what. Maybe something with my settings??

The strange thing is that the customers that i do not find in my database, i can view all the details in admin.

And the once that are in my database i can not view their details in admin...

Could you PLEASE help me out?

Thanks a lot

Ilonka

DrByte:

How exactly did you get your "customers imported" ?

Zen Cart currently uses three tables for handling customer information:

• address_book
• customers
• customers_info

If all the data in those tables is not kept in sync, you will get errors similar to what you described.

I have solved the following errors:

When i choose to edit the customer details, i am getting the following errors

Warning: reset() [function.reset]: Passed variable is not an array or object in /home/ilonka/domains/fritenglas.nl/public_html/admin/includes/classes/object_info.php on line 29

Warning: Variable passed to each() is not an array or object in /home/ilonka/domains/fritenglas.nl/public_html/admin/includes/classes/object_info.php on line 30

But i am still getting the following once when i try to view the customer details.

admin-Customers-customers- ilonka

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/ilonka/domains/fritenglas.nl/public_html/admin/customers.php on line 1020

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/ilonka/domains/fritenglas.nl/public_html/admin/customers.php on line 1022

But i just can't figger out what this means...

What version of Zen Cart?

version 1.3.7

ilonka:

i am still getting the following once when i try to view the customer details.[/b]

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/ilonka/domains/fritenglas.nl/public_html/admin/customers.php on line 1020

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/ilonka/domains/fritenglas.nl/public_html/admin/customers.php on line 1022That's because there is no data in the "customers_info" table for that particular customer.

When manually importing or adjusting customer data, the address_book, customers, and customers_info tables need to be kept in sync. Your database is missing information from that table for those customers.

What do you mean with the sync??
I have exported all the old clients from my old database as SQL and have imported it in my new databse.

was this wrong?

DrByte:

That's because there is no data in the "customers_info" table for that particular customer.

When manually importing or adjusting customer data, the address_book, customers, and customers_info tables need to be kept in sync. Your database is missing information from that table for those customers.

ilonka:

What do you mean with the sync??
I have exported all the old clients from my old database as SQL and have imported it in my new databse.

was this wrong?
Did you export and import all three tables?

1. address_book
2. customers
3. customers_info

yes i did. And al the data is showing in teh database.

But the strange thing is that all my new customers are not showing up in my database.

New customers - not in database - can view al the details in admin

old customers - in database - can not view the details in admin

ilonka:

yes i did. And al the data is showing in teh database.

But the strange thing is that all my new customers are not showing up in my database.Then ... your Zen Cart configure.php files are not pointing to the same database.

both my configure.php files are directing to the same correct database.

i am going crazy..... what else can it be?

Cause i find it so strange that my new customers are not shown in my database but they are in my admin. Where does this information go to?

Zen Cart only pulls customer information from the database identified in the configure.php files.
If you're seeing your data in the customers table in phpMyAdmin but not in Zen Cart, then you're probably looking at two different databases.

Nope, configure files are both with the correct database....

DrByte:

Zen Cart only pulls customer information from the database identified in the configure.php files.
If you're seeing your data in the customers table in phpMyAdmin but not in Zen Cart, then you're probably looking at two different databases.

Dr Byte,

I had the same problem when bringing over my customers and this fixed it...i had not copied the address book! Thanks!

If i want to bring over the history of orders as well which tables would i need to copy?

Many thanks,
Neil

neilg:

If i want to bring over the history of orders as well which tables would i need to copy?If this is an "upgrade" that you're doing, keep in mind that Zen Cart already allows you to bring forward all your customers and orders ... just by using its database-upgrade script built-in to zc_install.

Blindly importing data from a mismatched version structure is very dangerous and highly unrecommended.

If you're going to import data from another database, make sure that both databases are at the same version level.

As to which tables contain what, see the wiki: http://www.zen-cart.com/wiki/index.php/Developers_-_Database_Schema#Table_List_Ordered_by_Data