nightmere upgrading - Products not showing up in their categories

[mc12345678]

I have done a fresh install of zc since my old php versions are no longer supported. Then restored my zc 155 database. my problem is my products do not show up in there categories on the store front, but show up on the store front as new products. also my products do not show up at all in admin area, or in categories or as products of thoses categries in admin area at all.

can somone please guide me to a fix for this.

server information/ specs and php versions can be posted upon request.

I *have* read all of the other posts, but the linked database data is no longer available for perusal (hopefully it did not include customer data). I don't see though, what process was used to obtain the "backup" of the previous/old database to be able to indicate whether a step (option) was missed in backing up the database, if a table did not get restored, if a table existed and did not get its data replaced or if in adding data from the recovered database new record designations were assigned that caused a loss of correlation between product and category.

In the more recent versions, queries were modified to require relationships to exist in order to retrieve results as compared to older versions that allowed a lapse of relationship within the admin. At least in the older versions, data could be retrieved and issues corrected by pushing the correct relationship where found to be broken. Now, unexpected results occur which requires one to dig into the database more in order to resolve the issue.

As you show in your images, in the admin there appear to be product and there appear to be categories. On the catalog side, there appear to be product in categories.

From those conditions, it appears to me that product have master_categories assigned, categories exist, but the table products_to_categories does not have appropriate information to represent the product/category relationships.

If that is true, there are ways to restore the relationships using one or more sql queries at least to restore primary relationships with linked product to be rebuilt separately. Such would be simpler if that table is/was in the 155 version of the sql.

[immortalgames]

Thank you for your swift reply, this helped heaps. (products_to_categories) in SQL had not executed correctly from the 1.55 database as this is a huge database, did take me awhile to copy just that one table from the database but however fixed the issue so it was worth it. thank you very much for this. im going to painstakingly go through the rest of the database for any other error but in all very pleased with the result. updating or moving PHP or SQL versions/ SQL processors is painfull when you have long term working website. will message again if anything.

Thank you again guys for your help.

[immortalgames]

im still having an issue with products not showing up with a name, and in turn not showing up in search or inorder to edit them in the admin area.

[lat9]

If you'll do a database export (via phpMyAdmin) and PM me a link to where I can download that, I'll see what I can see.

[immortalgames]

I have PM-ed you thank you

[lat9]

I have PM-ed you thank you

Got it!

On initial inspection, I see that the site has one language (english), 9626 entries in the products table and 1290 (!) entries in the products_description table. I'm pretty sure that for a product to be considered as valid, it needs to have an entry in both of those tables (as well as others).

Any ideas as to where those other 8336 products' descriptions disappeared to? Do you have a backup of the current/previous site's database?

[immortalgames]

yes, what i will have a look and PM you back. thank you

[immortalgames]

Got it!

On initial inspection, I see that the site has one language (english), 9626 entries in the products table and 1290 (!) entries in the products_description table. I'm pretty sure that for a product to be considered as valid, it needs to have an entry in both of those tables (as well as others).

Any ideas as to where those other 8336 products' descriptions disappeared to? Do you have a backup of the current/previous site's database?

just a quick question is there an easier way of filling the products with no description with a generic entry for example ("no description") with a sql querie that way i can at least see the product for editing

[brittainmark]

Assuming that you can get to phpMyAdmin or some other database tool then the following will insert a product name of "No Name" which will allow you to see and edit the missing product details. Please back up the database before using this command.

INSERT IGNORE INTO products_description SELECT products_id, 1, 'NO Name', Null, Null, 0 FROM products;

Note:
1. If you use a table prefix then you will need to add the prefix to the table names. i.e. id you use "ZEN" then command will be.

INSERT IGNORE INTO ZEN_products_description SELECT ZEN_products_id, 1, 'NO Name', Null, Null, 0 FROM products;

2. You will see a lot of errors because there are some products already with names. These will not be overwritten.

3. If you have the old database you would be better to export the products_description table and import to your new database.

[mprough]

Sounds to me like it's so large it's being corrupted in transfer... Try big dump maybe (https://www.ozerov.de/bigdump/).

~Melanie