Unable to delete ads

[adsvads]

I am trying to delete these ghost ads but getting the following error

Cannot delete or update a parent row: a foreign key constraint fails (`database_name`.`os_t_item_job_attr`, CONSTRAINT `os_t_item_job_attr_ibfk_1` FOREIGN KEY (`fk_i_item_id`) REFERENCES `os_t_item` (`pk_i_id`))

[frosticek]

@adsvads
I know this problem too, when listing has record also on other table and cannot be deleted. But really do not know why (bad table configuration, foreign key?).
You can delete it manually, access your database and delete records from os_t_item_job_attr first

[adsvads]

@adsvads
I know this problem too, when listing has record also on other table and cannot be deleted. But really do not know why (bad table configuration, foreign key?).
You can delete it manually, access your database and delete records from os_t_item_job_attr first

thank you for the advice

[dev101]

Hi adsvads,
try ghost fix plugin.

[frosticek]

@dev101
For me Ghost Ads Plugin do not work on those listings.
I have also replied Jay about this bug but not responded yet