Problem with dailycounter

[Arran Cudbard-Bell]

> On Aug 21, 2016, at 12:18 AM, Frederic Fichter <ffichter at mac.com> wrote:
> 
> (5) dailycounter: EXPAND %{sql:SELECT SUM(acctsessiontime - GREATEST((1471730400 - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username = '%{User-Name}' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '1471730400'}
> (5) dailycounter:    --> 
> (5) dailycounter: No integer found in result string "".  May be first session, setting counter to 0

Have you tried running the query manually? What do you get.

-Arran