[ https://issues.apache.org/jira/browse/TC-15?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Neuman closed TC-15. -------------------------- > 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)