Hi @zephro98
To fix this, first check that this is indeed the issue. Backup your database and then run the following SQL to see if any product and/or category associations are incorrect:
# Determine incorrect product associations
SELECT * FROM `catalog_category_product` WHERE
product_id not in (select entity_id from catalog_product_entity);
# Determine incorrect categories
SELECT * FROM `catalog_category_product` WHERE
category_id not in (select entity_id from catalog_category_entity);
If that returns a record, you'll know exactly which product is in a non-existent category or which category has a non-existent product. Run the following SQL to then remove those invalid records:
# Delete incorrect product associations
DELETE FROM `catalog_category_product` WHERE
product_id not in (select entity_id from catalog_product_entity);
# Delete incorrect categories
DELETE FROM `catalog_category_product` WHERE
category_id not in (select entity_id from catalog_category_entity);
Now log back into Magento Admin and reindex the Category Products index.
If issue resolve, please click on 'Kudos' & Accept as Solution!
Problem solved? Click Accept as Solution!
