After adding some products to the magento , I'm now getting this error when i try to reindex "category products" :
There was a problem with reindexing process. SQLSTATE: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`domain_shop`.`catalog_category_product_index`, CONSTRAINT `catalog_category_product_index_ibfk_3` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CAS)
I've searched for answers here , and I tried some queries in phpmyadmin , but none of them worked . Also , I don't have access to SSH of my website . Control panel is DirectAdmin. Any helps would be appreciated.