[OpenSIPS-Users] CDRtool freeradius mysql error

[toqeer ali]

Hi all,


I successfully configured Freeradius and CDRtool but when i accesses the
CDRs in CDRtool webinterface   i got this error ... it can't get Normalized
field in radacct table of Freeradius...

Please help
 Bellow is the error i got...

"Database error: Invalid SQL: select count(*) as c from radacct where
(AcctStartTime >= '2009-11-21 07:06' and AcctStartTime < '2009-11-21 23:55')
and Normalized = '0' and AcctStopTime != '0000-00-00 00:00:00' and
(ConnectInfo_stop is not NULL or MediaInfo is NULL or MediaInfo != '' or
(UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(AcctStopTime) > 20)) MySQL error:
1054 (Unknown column 'Normalized' in 'where clause')"

-- 
Toqeer Ali Syed

Red Hat Certified Engineer
mob:     +92 321 9059916
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20091121/98b25721/attachment.htm