I'm using :
SQL 7
NT4 SP5
Emerald 2.5.278
RadiusNT 2.5.213
On calls Table I had a calls_insert trigger that was not reducing the
TimeLeft field on SubAccounts
In my case the problem was the line 22 on the trigger:
*and sa.TimeLeft <> NULL*
in order to fix the problem I just updated it to:
*and sa.TimeLeft IS NOT NULL*
UPDATE sa
Set sa.TimeLeft = sa.TimeLeft - (i.AcctSessionTime/60 +
1)
FROM SubAccounts sa, inserted i
WHERE sa.Login = i.Username
and sa.TimeLeft IS NOT NULL
and i.AcctStatusType = 2
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart