[Freeswitch-users] How to use sofia_count_reg ?

[Avi Marcus]

I'm trying to use the API sofia_count_reg but all I'm getting is an error or
-1.
If I do "sofia_count_reg 1000" - whether there's multiple bindings or the
user doesn't exist, I get -1.
When I try "sofia_count_reg 1000 at domain.com" I get an sql error:

2011-09-08 08:22:29.381355 [ERR] switch_core_sqldb.c:825 ERR: [select
count(*) from sip_registrations where (sip_user='' or dir_user='1102') and
(sip_host='1102' or presence_hosts like '%sip.getbestfone.com%')]
[STATE: 42S22 CODE 1054 ERROR: [unixODBC][MySQL][ODBC 3.51
Driver][mysqld-5.1.41-3ubuntu12.10-log]Unknown column 'dir_user' in 'where
clause'

Thanks!

-Avi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20110908/ee4a3c26/attachment.html