Can't edit customer page in admin area

[Laki]

Hi,

I experienced a strange problem for me. I created a new zen cart website and loaded existing customers from my previous site (which was 1.3.9 version). I loaded it through PHPMyadmin. These customers are visible in admin area of the new website but I can't open a customer page. Also, if some of these customers (loaded from the old site) make a purchase my system record an order but an invoice doesn't have information who purchased. I can see what is purchased but there is no customer name.

I don't have this issue with the new customers who have registered after I run the new website.

I did the next test. I removed one old customer in admin area and created his account manually in PHPMyAdmin inserting a new row in the customer table (using the same information as it was) but this wasn't a solution. This customer is visible but his page can't be open in admin area and his name doesn't appear on the invoice.

Any idea how to fix this?

Thanks

[Laki]

Just to give you some additional info. How did I load old customers to the new database? Since I needed only information about the customers from the old db I exported them to csv file and imported to the new database. As I wrote above, I saw them in the admin area but can't open their profile page and if someone of them make a purchase, a customer name doesn't show up on the invoice so I don't have a track who purchased.

[mc12345678]

So you didn't follow a known functional process such as: http://www.zen-cart.com/entry.php?3-...d-of-upgrading

Or any process that offers a method of upgrading the database of the old store?

[Laki]

That's not the answer. I want to upgrade just one table in my database with data I already had. You can do it in many ways and writing and executing SQL queries in MySQL is one of them. Also you can insert new rows in your table and populate with necessary data. This is not about the upgrade zen cart website. Understand what I mean?

[mc12345678]

That's not the answer. I want to upgrade just one table in my database with data I already had. You can do it in many ways and writing and executing SQL queries in MySQL is one of them. Also you can insert new rows in your table and populate with necessary data. This is not about the upgrade zen cart website. Understand what I mean?

Understand how it can be made difficult yes. The database is a relationship database, what all tables were imported related to the customer(s)? Have you looked at the tables associated with a "characteristic" is? Such as in the wiki Table List Ordered By Data which is not identified as a complete list, but might help.

[Laki]

I have not looked at the table associated with a "characteristic" but I'l do that.
Yes, the database is relational database. For an example, I can add something new through website admin but I should be able to insert new data in the database directly.
Now you gave me an idea that some other tables should be also inserted that have a connection to the table with customers. Thanks and I'll report you if I find a solution.

Best!

[Laki]

Couldn't edit my previous message and just to add. You're right when you say if I had upgraded the whole database this would have not happened (I've done upgrade few time seamlessly).

[Laki]

I found a solution for this. If you want to import customers from old database to the new one you have to import data to two tables in the database: "customer" and "address_book".
These two tables refer each to other using customer_id column.

The issue happened because I didn't import data to address_book table (initially I did it only to the customer table). That's why a I missed a customer name on the invoice (that information is pulled from address book table along with primary address).

Thanks for giving me an idea to solve this.

[mc12345678]

Welcome, and if I may suggest that while you are still able to do an upgrade of the old database, that you upgrade that database in it's entirety and then you can save that database for later reference as necessary, but at least all fields will be at the current version. While at it would suggest converting the database to utf8 unless there is some legitimate reason to stay at latin1... That can be done with the db2utf8 conversion plugin.