From 81e635dd3ebc378b63b9b4fd39e69cc99b3dd8c8 Mon Sep 17 00:00:00 2001
From: Peter van Dijk <peter.van.dijk@netherlabs.nl>
Date: Tue, 6 May 2014 12:28:27 +0200
Subject: [PATCH] attach comments to qname, not zonename

---
 pdns/zone2sql.cc | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/pdns/zone2sql.cc b/pdns/zone2sql.cc
index 78d1d9c87..bd1abb6bd 100644
--- a/pdns/zone2sql.cc
+++ b/pdns/zone2sql.cc
@@ -190,7 +190,7 @@ static void emitRecord(const string& zoneName, const string &qname, const string
         " from domains where name="<<toLower(sqlstr(zoneName))<<";\n";
 
       if(!recordcomment.empty()) {
-        cout<<"insert into comments (domain_id,name,type,modified_at, comment) select id, "<<toLower(sqlstr(zoneName))<<", "<<sqlstr(qtype)<<", "<<time(0)<<", "<<sqlstr(recordcomment)<<" from domains where name="<<toLower(sqlstr(zoneName))<<";\n";
+        cout<<"insert into comments (domain_id,name,type,modified_at, comment) select id, "<<toLower(sqlstr(stripDot(qname)))<<", "<<sqlstr(qtype)<<", "<<time(0)<<", "<<sqlstr(recordcomment)<<" from domains where name="<<toLower(sqlstr(zoneName))<<";\n";
        
       }
 
-- 
2.40.0