Ghost buster error

[adewoye]

Please expert in the forum help,  ghost buster bring the following error messages:

Cannot delete or update a parent row: a foreign key constraint fails (`kadcngco_sellit`.`ba_t_item_seo`, CONSTRAINT `ba_t_item_seo_ibfk_1` FOREIGN KEY (`seo_item_id`) REFERENCES `ba_t_item` (`pk_i_id`))
Cannot delete or update a parent row: a foreign key constraint fails (`kadcngco_sellit`.`ba_t_item_seo`, CONSTRAINT `ba_t_item_seo_ibfk_1` FOREIGN KEY (`seo_item_id`) REFERENCES `ba_t_item` (`pk_i_id`))
Cannot delete or update a parent row: a foreign key constraint fails (`kadcngco_sellit`.`ba_t_item_seo`, CONSTRAINT `ba_t_item_seo_ibfk_1` FOREIGN KEY (`seo_item_id`) REFERENCES `ba_t_item` (`pk_i_id`))
Cannot delete or update a parent row: a foreign key constraint fails (`kadcngco_sellit`.`ba_t_item_seo`, CONSTRAINT `ba_t_item_seo_ibfk_1` FOREIGN KEY (`seo_item_id`) REFERENCES `ba_t_item` (`pk_i_id`))

[design]

what plugin are you using? it looks like you have an ad that is using a category that has a plugin option, so the ad won't delete because of it.

[tomshaft]

I don't know that even the great Ghostbuster can delete a foreign key when they contain tables. Everything under the key must be deleted before a foreign key can be removed.

Seems to me that the seo plugin would have to be fully un-installed and hope that it removes itself from the database or you will have to do it manually.

Just thoughts I have when thinking of other thoughts.....

tom

[trains58554]

Hi adewoye,

Thanks for posting this I will update the ghostbuster plugin soon.

Jay

[firetool]

Please expert in the forum help,  ghost buster bring the following error messages:

Cannot delete or update a parent row: a foreign key constraint fails (`kadcngco_sellit`.`ba_t_item_seo`, CONSTRAINT `ba_t_item_seo_ibfk_1` FOREIGN KEY (`seo_item_id`) REFERENCES `ba_t_item` (`pk_i_id`))
Cannot delete or update a parent row: a foreign key constraint fails (`kadcngco_sellit`.`ba_t_item_seo`, CONSTRAINT `ba_t_item_seo_ibfk_1` FOREIGN KEY (`seo_item_id`) REFERENCES `ba_t_item` (`pk_i_id`))
Cannot delete or update a parent row: a foreign key constraint fails (`kadcngco_sellit`.`ba_t_item_seo`, CONSTRAINT `ba_t_item_seo_ibfk_1` FOREIGN KEY (`seo_item_id`) REFERENCES `ba_t_item` (`pk_i_id`))
Cannot delete or update a parent row: a foreign key constraint fails (`kadcngco_sellit`.`ba_t_item_seo`, CONSTRAINT `ba_t_item_seo_ibfk_1` FOREIGN KEY (`seo_item_id`) REFERENCES `ba_t_item` (`pk_i_id`))

I have same issue as you.....same error you are not alone

[frosticek]

Hi guys,
Same issue when custom plugin / stuff is developed with table that has foreign key to some existing table that is base for osclass.

[trains58554]

Hi All,

The new version of Ghostbuster's will be able to fix those errors.

http://market.osclass.org/plugins/ghostbuster_83

Jay

[tomshaft]

This is great Jay.
Nice to be able to download from the market.

Looking forward to trying it.

Tom