Quote Originally Posted by DrByte View Post
That is typically a result of bad data. The data which comprises a "customer" comes from several tables. Those errors typically appear when one or more of those tables is empty or does not contain the expected record for the selected customer.
Quote Originally Posted by Cheeky Chino View Post
Could you advise me which tables are linked to the customers table?
Quote Originally Posted by Cheeky Chino View Post
Yes i clicked through your link, and i didn't really help with my situation.
The link I posted specifically answers your question about "which tables are linked to the customers table".



Quote Originally Posted by DrByte View Post
A proper upgrade of a Zen Cart site uses the /zc_install/index.php script to do convert the old database to the new structure. You can find the details of the upgrade process in the upgrade documentation which came with your version of Zen Cart.
It's important to use the upgrade program because it not only preserves the data, but also handles upgrading the database structure.
Quote Originally Posted by Cheeky Chino View Post
It doesnt say what tables etc are exactly upgraded changed etc, it's just saying that you should run the upgrade wizard etc...
The correct way to upgrade your database structure is to use the supplied upgrade script. It takes all of 5-10 minutes. Maybe 15 including backups.


The documented upgrade instructions are written and supplied not just to take up disk space, but to provide a plan which will prevent you from having the problems you're reporting.


So, since it seems you are bent on using a new database and merging data, instead of upgrading the original one, you'll need to:
1. Upgrade your "old" database using the supplied zc_install upgrade script.
2. Then import the tables related to customer-data.
That way you'll have the data in the right format.