<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Add the field quota to the MySQL subscriber table.<div><br></div><div>Adrian</div><div><br></div><div><br><div><div>On Nov 17, 2008, at 4:48 AM, troxlinux wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">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.<br><br>11 records found. Database error: Invalid SQL: select quota from subscriber where username = '112' and domain = '<a href="http://192.168.10.1">192.168.10.1</a>' MySQL error: 1054 (Unknown column 'quota' in 'field list') 59Session halted<br><br>Database error: Invalid SQL: select quota from subscriber where username = '119' and domain = '<a href="http://192.168.10.1">192.168.10.1</a>' MySQL error: 1054 (Unknown column 'quota' in 'field list') 59Session halted. <br><br>23 records found. <p>Database error: Invalid SQL: select quota from subscriber where username = 'asterisk' and domain = '<a href="http://192.168.10.1">192.168.10.1</a>' MySQL error: 1054 (Unknown column 'quota' in 'field list') 59Session halted. </p>any idea that it can be failing?<br><br>best regards<br><br>rickygm<br> _______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br></blockquote></div><br></div></body></html>