You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafficcontrol.apache.org by ra...@apache.org on 2018/12/18 23:43:29 UTC

[trafficcontrol] branch master updated: Fix TO query for crconfig column rename (#3137)

This is an automated email from the ASF dual-hosted git repository.

rawlin pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/trafficcontrol.git


The following commit(s) were added to refs/heads/master by this push:
     new 4bda917  Fix TO query for crconfig column rename (#3137)
4bda917 is described below

commit 4bda91770345b066e2a09a577ac2eb5f44354bda
Author: Robert Butts <ro...@users.noreply.github.com>
AuthorDate: Tue Dec 18 16:43:25 2018 -0700

    Fix TO query for crconfig column rename (#3137)
    
    Fixes #3136
---
 traffic_ops/traffic_ops_golang/cdn/dnssec.go | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/traffic_ops/traffic_ops_golang/cdn/dnssec.go b/traffic_ops/traffic_ops_golang/cdn/dnssec.go
index bfd0195..446ef5a 100644
--- a/traffic_ops/traffic_ops_golang/cdn/dnssec.go
+++ b/traffic_ops/traffic_ops_golang/cdn/dnssec.go
@@ -121,7 +121,7 @@ func GetDNSSECKeysV11(w http.ResponseWriter, r *http.Request) {
 
 func GetDSRecordTTL(tx *sql.Tx, cdn string) (time.Duration, error) {
 	ttlSeconds := 0
-	if err := tx.QueryRow(`SELECT JSON_EXTRACT_PATH_TEXT(content, 'config', 'ttls', 'DS') FROM snapshot WHERE cdn = $1`, cdn).Scan(&ttlSeconds); err != nil {
+	if err := tx.QueryRow(`SELECT JSON_EXTRACT_PATH_TEXT(crconfig, 'config', 'ttls', 'DS') FROM snapshot WHERE cdn = $1`, cdn).Scan(&ttlSeconds); err != nil {
 		return 0, errors.New("getting cdn '" + cdn + "' DS Record TTL from CRConfig: " + err.Error())
 	}
 	return time.Duration(ttlSeconds) * time.Second, nil