[sr-dev] git:master:c7cf1937: Fix on saving protocol info for ims_usrloc_pcscf

[67456745]

Module: kamailio
Branch: master
Commit: c7cf1937bfc9a36e70865fed8cf704f34f17685f
URL: https://github.com/kamailio/kamailio/commit/c7cf1937bfc9a36e70865fed8cf704f34f17685f

Author: 67456745 <erhan.sendag at i2i-systems.com>
Committer: 67456745 <erhan.sendag at i2i-systems.com>
Date: 2021-10-11T11:51:33+03:00

Fix on saving protocol info for ims_usrloc_pcscf

---

Modified: src/modules/ims_usrloc_pcscf/usrloc_db.c
Modified: utils/kamctl/mysql/ims_usrloc_pcscf-create.sql

---

Diff:  https://github.com/kamailio/kamailio/commit/c7cf1937bfc9a36e70865fed8cf704f34f17685f.diff
Patch: https://github.com/kamailio/kamailio/commit/c7cf1937bfc9a36e70865fed8cf704f34f17685f.patch

---

diff --git a/src/modules/ims_usrloc_pcscf/usrloc_db.c b/src/modules/ims_usrloc_pcscf/usrloc_db.c
index ca57a2b4b33..5f0df126fa2 100644
--- a/src/modules/ims_usrloc_pcscf/usrloc_db.c
+++ b/src/modules/ims_usrloc_pcscf/usrloc_db.c
@@ -341,7 +341,7 @@ int db_insert_pcontact(struct pcontact* _c)
 		return -1;
 	}
 
-	if (ul_dbf.insert(ul_dbh, keys, values, 15) < 0) {
+	if (ul_dbf.insert(ul_dbh, keys, values, 16) < 0) {
 		LM_ERR("inserting contact in db failed\n");
 		return -1;
 	}
diff --git a/utils/kamctl/mysql/ims_usrloc_pcscf-create.sql b/utils/kamctl/mysql/ims_usrloc_pcscf-create.sql
index cf978df1f58..2a18c59601b 100644
--- a/utils/kamctl/mysql/ims_usrloc_pcscf-create.sql
+++ b/utils/kamctl/mysql/ims_usrloc_pcscf-create.sql
@@ -17,7 +17,7 @@ CREATE TABLE `location` (
   `socket` varchar(64) DEFAULT NULL,
   `public_ids` varchar(2048) DEFAULT NULL,
   `security_type` int(11) DEFAULT NULL,
-  `protocol` char(5) DEFAULT NULL,
+  `protocol` int(10) DEFAULT NULL,
   `mode` char(10) DEFAULT NULL,
   `ck` varchar(100) DEFAULT NULL,
   `ik` varchar(100) DEFAULT NULL,