[Freeswitch-users] switch_core_sqldb.c:840 SQL ERR

[Bob Smith]

Hi,

I think it may be related to me updating to the latest git point (cfa926d7 ....add sub_host to the sip_registrations table to keep track of the original host).

Haven't seen these messages before today, and don't really want to break anything more than it might already be, so could someone point me in the right direction as to what needs to be done ?

2012-01-11 12:30:59.466486 [ERR] switch_core_sqldb.c:840 SQL ERR: [select sip_registrations.sip_user, sip_registrations.sub_host, sip_registrations.status, sip_registrations.rpid, '', sip_dialogs.uuid, sip_dialogs.state, sip_dialogs.direction, sip_dialogs.sip_to_user, sip_dialogs.sip_to_host, sip_presence.status,sip_presence.rpid,sip_dialogs.presence_id, sip_presence.open_closed,'','' from sip_registrations left join sip_dialogs on sip_dialogs.presence_id = sip_registrations.sip_user || '@' || sip_registrations.sub_host or (sip_dialogs.sip_from_user = sip_registrations.sip_user and sip_dialogs.sip_from_host = sip_registrations.sub_host) left join sip_presence on (sip_registrations.sip_user=sip_presence.sip_user and sip_registrations.orig_server_host=sip_presence.sip_server and sip_registrations.profile_name=sip_presence.profile_name) where sip_dialogs.presence_id='1000 at an.example.com' or (sip_registrations.sip_user='1000' and
 (sip_registrations.orig_server_host='an.example.com' or sip_registrations.sub_host='an.example.com' or sip_registrations.presence_hosts like '%an.example.com%'))] no such column: sip_presence.sip_server

Thanks

Bob