[jira] [Closed] (TC-15) Duplicate data in seeds.sql results in error

["David Neuman (JIRA)" <ji...@apache.org>]

     [ 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)