David Neuman created TC-15: ------------------------------ Summary: Duplicate data in seeds.sql results in error Key: TC-15 URL: https://issues.apache.org/jira/browse/TC-15 Project: Traffic Control Issue Type: Bug Components: Traffic Ops Affects Versions: 1.8.0 Reporter: David Neuman Assignee: David Neuman Fix For: 1.8.0
When you try to run a setup of the Traffic Ops database, it fails with the following error: ERROR 1452 (23000) at line 172: Cannot add or update a child row: a foreign key constraint fails (`to_integration`.`profile_parameter`, CONSTRAINT `fk_atsprofile_atsparameters_atsparameters1` FOREIGN KEY (`parameter`) REFERENCES `parameter` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION) This is because of a copy/paste error on lines 152 and 153 that cause duplicate data. -- This message was sent by Atlassian JIRA (v6.3.4#6332)