On Wed, Jan 11, 2012 at 6:36 AM, Bob Smith
<gb10hkzo-freeswitch@yahoo.co.uk> wrote:
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@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
_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com
Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com
FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org