17 Jun
2008
17 Jun
'08
2:38 p.m.
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.