[Freeswitch-svn] [commit] r6476 - freeswitch/trunk/src/mod/endpoints/mod_sofia

[Freeswitch SVN]

Author: mikej
Date: Mon Dec  3 11:12:04 2007
New Revision: 6476

Modified:
   freeswitch/trunk/src/mod/endpoints/mod_sofia/sofia_presence.c

Log:
fix sql error due to wrong field name (MODENDP-50)

Modified: freeswitch/trunk/src/mod/endpoints/mod_sofia/sofia_presence.c
==============================================================================
--- freeswitch/trunk/src/mod/endpoints/mod_sofia/sofia_presence.c	(original)
+++ freeswitch/trunk/src/mod/endpoints/mod_sofia/sofia_presence.c	Mon Dec  3 11:12:04 2007
@@ -784,7 +784,7 @@
 		switch_mutex_lock(profile->ireg_mutex);
 
 		sql = switch_mprintf("delete from sip_subscriptions where "
-							 "proto='%q' and user='%q' and host='%q' and sub_to_user='%q' and sub_to_host='%q' and event='%q'",
+							 "proto='%q' and sip_user='%q' and sip_host='%q' and sub_to_user='%q' and sub_to_host='%q' and event='%q'",
 							 proto,
 							 from_user,
 							 from_host,