[OpenSIPS-Users] search problem with CDRTool

[Adrian Georgescu]

Add the field quota to the MySQL subscriber table.

Adrian


On Nov 17, 2008, at 4:48 AM, troxlinux wrote:

> Hi list , does a few days installs CDRTool in my server  openser, I  
> am using radius and to openser to handle accounting,  but I have a  
> problem that shows me every time that I search for the calls made by  
> my users from a date to another.
>
> 11 records found. Database error: Invalid SQL: select quota from  
> subscriber where username = '112' and domain = '192.168.10.1' MySQL  
> error: 1054 (Unknown column 'quota' in 'field list') 59Session halted
>
> Database error: Invalid SQL: select quota from subscriber where  
> username = '119' and domain = '192.168.10.1' MySQL error: 1054  
> (Unknown column 'quota' in 'field list') 59Session halted.
>
> 23 records found.
> Database error: Invalid SQL: select quota from subscriber where  
> username = 'asterisk' and domain = '192.168.10.1' MySQL error: 1054  
> (Unknown column 'quota' in 'field list') 59Session halted.
>
> any idea that it can be failing?
>
> best regards
>
> rickygm
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20081117/9ff0ca65/attachment.htm