search problem with CDRTool

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

search problem with CDRTool

troxlinux
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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: 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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: search problem with CDRTool

troxlinux
thank its work fine

regards

rickygm

2008/11/17 Adrian Georgescu <[hidden email]>
Add the field quota to the MySQL subscriber table.



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users