When attempting to upgrade from 0.19.7 to 0.19.13, I got these errors on the 0.19.7 -> 0.19.8 upgrade:
DELETE FROM AttributeMap WHERE chapter_id NOT IN (SELECT id FROM Chapter) -- Cannot delete or update a parent row: a foreign key constraint fails (`racktables_db`.`AttributeValue`, CONSTRAINT `AttributeValue-FK-attr_id` FOREIGN KEY (`attr_id`) REFERENCES `AttributeMap` (`attr_id`))
ALTER TABLE AttributeMap ADD CONSTRAINT `AttributeMap-FK-chapter_id` FOREIGN KEY (chapter_id) REFERENCES Chapter (id) -- Cannot add or update a child row: a foreign key constraint fails (`racktables_db`., CONSTRAINT `AttributeMap-FK-chapter_id` FOREIGN KEY (`chapter_id`) REFERENCES `Chapter` (`id`))
It looks like a similar issue was discussed a few months ago, but I never saw a final description of how to fix this problem. So, how do I clean up from this?
-- Todd D. Taft UNC Computational Systems Biology todd_taft@xxxxxxx
