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.
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!