Missing Products after upgrade

It's all gone on about database upgrades now, so I did the upgrades using the zc_install and now it's dead :(
I will try once more. What is the best way to import the data from the old 1.39h db into the new 1.51db please ajeh?

Ajeh:

You said you got 12 pages of results for:

#TEST PRODUCTS VS PRODUCTS_DESCRIPTION

If you write down the first 10 products_id that show, and search the table products for them how many come up?

If you write down the first 10 products_id that show, and search the table products_description for them how many come up?

Then for:
#TEST CATEGORIES VS CATEGORIES_DESCRIPTION

You showed a number of records ...
If you write down the first 10 categories_id that show, and search the table categories for them how many come up?

If you write down the first 10 categories_id that show, and search the table categories_description for them how many come up?

Sorry Ajeh, I think I cocked something up because it's dead.
I have to start again with the import now

Lost it all...good job I still have the original files :-|

I'm having a very similar issue. I use dreamhost, upgraded from 139 to the newest 151 version of Zen. Because of my database size, I couldn't do a export from the old database and import into the new database, so I did the synchronize databases thing instead, then once that was done, I turned off the synchronize, ran the install again to upgrade the database, and it looked like it worked. But, like the OP, I have a lot of products that are showing in the Category Counts, that aren't showing up in the categories. Looking at the database under Products, they're all there, and there's nothing different about the missing ones, and the others that did work. Even the products that are in the same category, I'll have 8 actually there, and 4 being ghosts.

There is a difference in the Products total and the Products_Description totals, 961 Products, and 480ish listings in the description db. What's the most efficient way to fix this? Should I just insert the products into the Description table?

Attributes - I do have some, but many of the listings that worked came through with the attributes no problem.