Modified: freeswitch/trunk/src/mod/endpoints/mod_sofia/sofia_presence.c (16223 => 16224)

--- freeswitch/trunk/src/mod/endpoints/mod_sofia/sofia_presence.c	2010-01-09 00:34:17 UTC (rev 16223)
+++ freeswitch/trunk/src/mod/endpoints/mod_sofia/sofia_presence.c	2010-01-09 16:56:11 UTC (rev 16224)
@@ -1885,7 +1885,7 @@
 		switch_snprintf(exp_delta_str, sizeof(exp_delta_str), "%ld", exp_delta);
 		
 		if (sofia_test_pflag(profile, PFLAG_MULTIREG)) {
-			sql = switch_mprintf("update sip_subscriptions set expires=-1 where call_id='%q' "
+			sql = switch_mprintf("delete from sip_subscriptions where call_id='%q' "
 								 "or (proto='%q' and sip_user='%q' and sip_host='%q' "
 								 "and sub_to_user='%q' and sub_to_host='%q' and event='%q' and hostname='%q' "
 								 "and contact='%q')",
@@ -1893,7 +1893,7 @@
 								 contact_str);
 
 		} else {
-			sql = switch_mprintf("update sip_subscriptions set expires=-1 where "
+			sql = switch_mprintf("delete from sip_subscriptions where "
 								 "proto='%q' and sip_user='%q' and sip_host='%q' and sub_to_user='%q' and sub_to_host='%q' and event='%q' and hostname='%q'",
 								 proto, from_user, from_host, to_user, to_host, event, mod_sofia_globals.hostname);
 		}