Not able to delete the default products
Posted: Mon Sep 28, 2015 4:29 am
I installed the DemoSite version of Broadleaf. When I try to delete a product from the /admin section. I get the following error message.
org.hibernate.exception.ConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`broadleaf`.`blc_product`, CONSTRAINT `FK5B95B7C96D386535` FOREIGN KEY (`DEFAULT_SKU_ID`) REFERENCES `blc_sku` (`SKU_ID`))
I understand that there is a foreign key constraint on SKU table. Shouldn't it auto delete SKU's related whenever I delete a product.
Even if not how can I delete the SKU's first. I tried deleting the product options first. But that dint helped either.
org.hibernate.exception.ConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`broadleaf`.`blc_product`, CONSTRAINT `FK5B95B7C96D386535` FOREIGN KEY (`DEFAULT_SKU_ID`) REFERENCES `blc_sku` (`SKU_ID`))
I understand that there is a foreign key constraint on SKU table. Shouldn't it auto delete SKU's related whenever I delete a product.
Even if not how can I delete the SKU's first. I tried deleting the product options first. But that dint helped either.