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

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TC-15?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15625652#comment-15625652 ] 

ASF GitHub Bot commented on TC-15:
----------------------------------

Github user asfgit closed the pull request at:

    https://github.com/apache/incubator-trafficcontrol/pull/26


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