fixed in tree<br><br><div class="gmail_quote">On Wed, Jan 11, 2012 at 6:36 AM, Bob Smith <span dir="ltr"><<a href="mailto:gb10hkzo-freeswitch@yahoo.co.uk">gb10hkzo-freeswitch@yahoo.co.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
<br>
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).<br>
<br>
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 ?<br>
<br>
<a href="tel:2012-01-11%2012" value="+12012011112">2012-01-11 12</a>: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='<a href="mailto:1000@an.example.com">1000@an.example.com</a>' or (sip_registrations.sip_user='1000' and<br>
(sip_registrations.orig_server_host='<a href="http://an.example.com" target="_blank">an.example.com</a>' or sip_registrations.sub_host='<a href="http://an.example.com" target="_blank">an.example.com</a>' or sip_registrations.presence_hosts like '%<a href="http://an.example.com" target="_blank">an.example.com</a>%'))] no such column: sip_presence.sip_server<br>
<br>
Thanks<br>
<br>
Bob<br>
<br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>Anthony Minessale II<br><br>FreeSWITCH <a href="http://www.freeswitch.org/">http://www.freeswitch.org/</a><br>ClueCon <a href="http://www.cluecon.com/">http://www.cluecon.com/</a><br>
Twitter: <a href="http://twitter.com/FreeSWITCH_wire">http://twitter.com/FreeSWITCH_wire</a><br><br>AIM: anthm<br><a href="mailto:MSN%3Aanthony_minessale@hotmail.com">MSN:anthony_minessale@hotmail.com</a><br>GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com">PAYPAL:anthony.minessale@gmail.com</a><br>
IRC: <a href="http://irc.freenode.net">irc.freenode.net</a> #freeswitch<br><br>FreeSWITCH Developer Conference<br><a href="mailto:sip%3A888@conference.freeswitch.org">sip:888@conference.freeswitch.org</a><br><a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org">googletalk:conf+888@conference.freeswitch.org</a><br>
pstn:+19193869900<br>