Return 0 if no counter exists

diff --git a/raddb/sql/mysql/counter.conf b/raddb/sql/mysql/counter.conf
index c05b3b8..a327819 100644 (file)
--- a/raddb/sql/mysql/counter.conf
+++ b/raddb/sql/mysql/counter.conf
@@ -113,7 +113,7 @@ sqlcounter noresetcounter {
                 sqlmod-inst = sql 
                 key = User-Name 
                 reset = never 
-        query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{%k}'" 
+        query = "SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='%{%k}'" 
 }