Anthony -

Does this mean that the presence issue is likely resolved?

Thanks,

Rob

On Wednesday 11 January 2012 13:44:55 Anthony Minessale wrote:

> 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

> >

>

>

>

>