20 Aug
2016
20 Aug
'16
8:13 p.m.
On Aug 21, 2016, at 12:18 AM, Frederic Fichter <ffichter@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