Modified: freeswitch/trunk/src/mod/endpoints/mod_sofia/sofia.c (15461 => 15462)

--- freeswitch/trunk/src/mod/endpoints/mod_sofia/sofia.c	2009-11-13 16:37:42 UTC (rev 15461)
+++ freeswitch/trunk/src/mod/endpoints/mod_sofia/sofia.c	2009-11-13 17:55:52 UTC (rev 15462)
@@ -915,8 +915,9 @@
 
 				switch_mutex_lock(profile->ireg_mutex);
 			
-				sprintf(sqlbuf + len, "begin;\n");
-				len += 7;
+				
+				sprintf(sqlbuf, "begin;\n");
+				sofia_glue_actually_execute_sql(profile, sqlbuf, NULL);
 
 				while (switch_queue_trypop(profile->sql_queue, &pop) == SWITCH_STATUS_SUCCESS && pop) {
 					char *sql = (char *) pop;
@@ -940,10 +941,13 @@
 					free(pop);
 				}
 
-				sprintf(sqlbuf + len, "commit;\n");
-
 				//printf("TRANS:\n%s\n", sqlbuf);
 				sofia_glue_actually_execute_sql(profile, sqlbuf, NULL);
+
+				sprintf(sqlbuf, "commit;\n");
+				sofia_glue_actually_execute_sql(profile, sqlbuf, NULL);
+
+
 				switch_mutex_unlock(profile->ireg_mutex);
 				loop_count = 0;
 			}