Module: kamailio Branch: master Commit: 3bedfd3ac9a061f53e16d57a1d21eae8342455c1 URL: https://github.com/kamailio/kamailio/commit/3bedfd3ac9a061f53e16d57a1d21eae8342455c1
Author: Victor Seva <[email protected]> Committer: Victor Seva <[email protected]> Date: 2026-03-05T02:52:50+01:00 ims_usrloc_scscf: fix raw queries 'subscriber' => 'subscriber_scscf' * schema was changed at 283a77887c88c38a240567a7b165478775662d81 fixes #4622 --- Modified: src/modules/ims_usrloc_scscf/usrloc_db.c --- Diff: https://github.com/kamailio/kamailio/commit/3bedfd3ac9a061f53e16d57a1d21eae8342455c1.diff Patch: https://github.com/kamailio/kamailio/commit/3bedfd3ac9a061f53e16d57a1d21eae8342455c1.patch --- diff --git a/src/modules/ims_usrloc_scscf/usrloc_db.c b/src/modules/ims_usrloc_scscf/usrloc_db.c index 8fb32dcc031..cdb9d5f3ada 100644 --- a/src/modules/ims_usrloc_scscf/usrloc_db.c +++ b/src/modules/ims_usrloc_scscf/usrloc_db.c @@ -102,15 +102,17 @@ int impu_contact_delete_query_len; char *impu_subscriber_insert_query = "INSERT INTO impu_subscriber (impu_id, subscriber_id) (SELECT I.id, " - "S.id FROM impu I, subscriber S WHERE I.impu='%.*s' and S.event='%.*s' " - "and S.watcher_contact='%.*s' and S.presentity_uri='%.*s')"; + "S.id FROM impu I, subscriber_scscf S WHERE I.impu='%.*s' and " + "S.event='%.*s' and S.watcher_contact='%.*s' and " + "S.presentity_uri='%.*s')"; int impu_subscriber_insert_query_len; char *impu_subscriber_delete_query = "DELETE impu_subscriber FROM impu_subscriber INNER JOIN impu on " - "impu_subscriber.impu_id=impu.id INNER JOIN subscriber on " - "impu_subscriber.subscriber_id=subscriber.id WHERE impu.impu='%.*s' " - "AND subscriber.event='%.*s' and subscriber.watcher_contact='%.*s' and " - "subscriber.presentity_uri='%.*s'"; + "impu_subscriber.impu_id=impu.id INNER JOIN subscriber_scscf on " + "impu_subscriber.subscriber_id=subscriber_scscf.id WHERE " + "impu.impu='%.*s' AND subscriber_scscf.event='%.*s' and " + "subscriber_scscf.watcher_contact='%.*s' and " + "subscriber_scscf.presentity_uri='%.*s'"; int impu_subscriber_delete_query_len; char *delete_unlinked_contact_query = "DELETE from contact"; @@ -822,7 +824,8 @@ int preload_udomain(db1_con_t *_c, udomain_t *_d) "s.presentity_uri,s.watcher_uri,s.watcher_contact,s.event,s." "expires,s.version,s.local_cseq,s.call_id,s.from_tag," "s.to_tag,s.record_route,s.sockinfo_str FROM impu_subscriber m " - "LEFT JOIN subscriber s ON s.id=m.subscriber_id WHERE m.impu_id="; + "LEFT JOIN subscriber_scscf s ON s.id=m.subscriber_id WHERE " + "m.impu_id="; query_contact.s = p_contact; query_contact.len = strlen(query_contact.s); _______________________________________________ Kamailio - Development Mailing List -- [email protected] To unsubscribe send an email to [email protected] Important: keep the mailing list in the recipients, do not reply only to the sender!
