Uploaded image for project: 'Traffic Control'
  1. Traffic Control
  2. TC-15

Duplicate data in seeds.sql results in error

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.8.0
    • 1.8.0
    • Traffic Ops
    • None

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              neuman David Neuman
              neuman David Neuman
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: