17 Jun
2008
17 Jun
'08
2:31 p.m.
El Tuesday 17 June 2008 13:38:31 David Villasmil escribió:
But you are above SQL query is a SELECT, so? Forget it, the important queries
are those for START, UPDATE and STOP action of FreeRadius. These SQL's are
INSERT or UPDATE.
--
Iñaki Baz Castillo
ibc(a)in.ilimit.es
> >
select *, UNIX_TIMESTAMP(AcctStartTime) as timestamp from radacct
> > where (1=1) and Normalized = '0' and AcctStopTime != '0000-00-00
> > 00:00:00'
>
> and
>
> > (ConnectInfo_stop is not NULL or MediaInfo is NULL or MediaInfo != '')
> >
> >
> > MediaInfo (after update from mediaproxy) is NOT null... the rest of
> > the fields are ok.
>
> Look again at the SQL query of above:
>
> MediaInfo is NULL or MediaInfo != ''
>
> It's not needed that MediaInfo is NULL, it can be any value except NULL
> or empty string.
That's it, it IS an empry string, so it will never rate it