Details
-
Bug
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
2.0.0, 1.8.0
-
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