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)
