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

Traffic Ops route returns 500 Internal Error

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 2.0.0, 1.8.0
    • 2.0.0, 1.8.0
    • Traffic Ops
    • None

    Description

      GET /aadata/ProfileParameter/cachegroup/all fails with 500 Internal Error

      Fails with Traffic Ops Error:

      Traffic Ops fatal error occurred while processing your request.
      Error at line 242 ( while ( my $row = $rs->next ) {)
      DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'cachegroup' in 'where clause' [for Statement "SELECT me.id, me.name, me.config_file, me.value, me.last_updated, me.secure, profile.name FROM parameter me LEFT JOIN profile_parameter profile_parameters_2 ON profile_parameters_2.parameter = me.id LEFT JOIN profile profile ON profile.id = profile_parameters_2.profile WHERE ( cachegroup IS NULL ) GROUP BY me.id, me.name, me.config_file, me.value, me.last_updated, me.secure, profile.name"] at /opt/traffic_ops/app/lib/UI/Cdn.pm line 242

      Attachments

        Activity

          People

            Unassigned Unassigned
            dewrich Dewayne Richardson
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 24h
                24h
                Remaining:
                Remaining Estimate - 24h
                24h
                Logged:
                Time Spent - Not Specified
                Not Specified