I am trying to delete ads buy listing cant delete.. Only title and description removed . see screenshot

When i try to delete ads from t_item in phpmyadmin then below error is showing

 #1451 - Cannot delete or update a parent row: a foreign key constraint fails (`****_oscl985`.`osj3_t_item_stats`, CONSTRAINT `osj3_t_item_stats_ibfk_1` FOREIGN KEY (`fk_i_item_id`) REFERENCES `osj3_t_item` (`pk_i_id`))

@ishan
Strange error, probably something is missing in database. Solution is to update this foreign key to have ON DELETE CASCADE ON UPDATE CASCADE

The Ghostbuster plugin will solve your problem)

@atba
I am not sure, I would say that this plugin will just cleanup like redundant data in dabase (without key pairing). Or am I wrong?

I have not studied your question, but the fact that it will allow you to delete what is not deleted is no problem here