older customer info not found

[ilonka]

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

[Kim]

After a server updat of my hosting provider everything changed

Exactly what did your host update?

[ilonka]

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

[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.

[ilonka]

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

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.

[ilonka]

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...

[DrByte]

What version of Zen Cart?

[ilonka]

version 1.3.7

[DrByte]

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 1022

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?

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.