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

[Anthony Minessale]

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
>



-- 
Anthony Minessale II

FreeSWITCH http://www.freeswitch.org/
ClueCon http://www.cluecon.com/
Twitter: http://twitter.com/FreeSWITCH_wire

AIM: anthm
MSN:anthony_minessale at hotmail.com
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org
googletalk:conf+888 at conference.freeswitch.org
pstn:+19193869900
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20120111/3c7f0c75/attachment.html