When I click "give up and delete spell", I'm taken to an error page that says:
PDOException [ 23000 ]: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`SM3`.`characters_spells`, CONSTRAINT `characters_spells_ibfk_2` FOREIGN KEY (`spell_id`) REFERENCES `Spells` (`id`))
