8 Sep
2011
8 Sep
'11
5:26 a.m.
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@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