[
https://issues.apache.org/jira/browse/TC-41?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dewayne Richardson closed TC-41.
--------------------------------
Resolution: Fixed
Fixed
> Traffic Ops route returns 500 Internal Error
> --------------------------------------------
>
> Key: TC-41
> URL: https://issues.apache.org/jira/browse/TC-41
> Project: Traffic Control
> Issue Type: Bug
> Components: Traffic Ops
> Affects Versions: 1.8.0, 2.0.0
> Reporter: Dewayne Richardson
> Priority: Minor
> Fix For: 1.8.0, 2.0.0
>
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> 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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
