[sr-dev] git:master: modules_k/rls: Fixed broken SQL query in RLS

Module: sip-router Branch: master Commit: 1a91ac3475ad24a75de17801181d2cb673bd6d82 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1a91ac3… Author: Peter Dunkley &lt;peter.dunkley(a)crocodile-rcs.com&gt; Committer: Peter Dunkley &lt;peter.dunkley(a)crocodile-rcs.com&gt; Date: Tue May 1 14:22:27 2012 +0100 modules_k/rls: Fixed broken SQL query in RLS - Fix by Hugh Waite @ Crocodile RCS --- modules_k/rls/rls_db.c | 13 ++++++------- 1 files changed, 6 insertions(+), 7 deletions(-) diff --git a/modules_k/rls/rls_db.c b/modules_k/rls/rls_db.c index 0aab750..cabd164 100644 --- a/modules_k/rls/rls_db.c +++ b/modules_k/rls/rls_db.c @@ -119,7 +119,7 @@ int delete_expired_subs_rlsdb( void ) db_op_t query_ops[1]; db_row_t *rows; db1_res_t *result = NULL; - int n_query_cols = 0, n_result_cols = 0, n_update_cols = 0; + int n_query_cols = 0, n_result_cols = 0; int r_callid_col = 0, r_to_tag_col = 0, r_from_tag_col = 0; int i; subs_t subs; @@ -206,14 +206,13 @@ int delete_expired_subs_rlsdb( void ) query_vals[n_query_cols].val.str_val = subs.from_tag; n_query_cols++; - update_cols[n_update_cols] = &str_updated_col; - update_vals[n_update_cols].type = DB1_INT; - update_vals[n_update_cols].nul = 0; - update_vals[n_update_cols].val.int_val = subs.updated; - n_update_cols++; + update_cols[0] = &str_updated_col; + update_vals[0].type = DB1_INT; + update_vals[0].nul = 0; + update_vals[0].val.int_val = subs.updated; if(rls_dbf.update(rls_db, query_cols, 0, query_vals, - update_cols,update_vals,n_query_cols,n_update_cols) < 0) + update_cols,update_vals,n_query_cols, 1) < 0) { LM_ERR("db update failed for expired subs\n"); goto error;