After I had migrated my website from magento 1.9 to magento 2.1, Everything is working fine except for a few bugs

i get this while running php bin/magento indexer:reindex

    SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails 
    (`thebeautyfloor1`.`catalogrule_group_website`, CONSTRAINT `CATALOGRULE_GROUP_WEBSITE_RULE_ID_CATALOGRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `catalogrule` (`rule_id`) ON DELETE CASCADE), 
query was: 
INSERT INTO `catalogrule_group_website` (`rule_id`, `customer_group_id`, `website_id`) 
SELECT DISTINCT  `catalogrule_product`.`rule_id`, `catalogrule_product`.`customer_group_id`, `catalogrule_product`.`website_id` FROM `catalogrule_product` 
WHERE (1527155869 >= from_time
 AND ((1527155869 <= to_time AND to_time > 0) OR to_time = 0)) ON DUPLICATE KEY UPDATE `rule_id` = VALUES(`rule_id`), `customer_group_id` = VALUES(`customer_group_id`), 
`website_id` = VALUES(`website_id`)

And when i try to change the Theme i get the ERROR

Requested store is not found

Any guidance will be really appreciated.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.