fixed in tree 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
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900