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

Rob Hutton justlikeef at gmail.com
Wed Jan 11 22:11:23 MSK 2012


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 at 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 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
> >
> > _________________________________________________________________________
> > Professional FreeSWITCH Consulting Services:
> > consulting at freeswitch.org
> > http://www.freeswitchsolutions.com
> >
> > 
> > 
> >
> > Official FreeSWITCH Sites
> > http://www.freeswitch.org
> > http://wiki.freeswitch.org
> > http://www.cluecon.com
> >
> > FreeSWITCH-users mailing list
> > FreeSWITCH-users at lists.freeswitch.org
> > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> > http://www.freeswitch.org
> >
> 
> 
> 
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20120111/ffd29965/attachment-0001.html 


Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users mailing list