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!