<h2>p_usrloc: location.sql missing columns</h2>
<p><a href="https://github.com/kamailio/kamailio/blob/6c01e2692d5ff56dda54d21469d32c4d3dcbfbff/src/modules/p_usrloc/location.sql">location.sql</a> should include columns corresponding to <code>RUID_COL</code> and <code>REG_ID_COL</code>) from <a href="https://github.com/kamailio/kamailio/blob/6c01e2692d5ff56dda54d21469d32c4d3dcbfbff/src/modules/p_usrloc/p_usrloc_mod.c#L65">p_usrloc_mod.c</a></p>
<h3>Log Messages</h3>
<pre><code>kamailio: ERROR: db_mysql [km_dbase.c:127]: db_mysql_submit_query(): driver error on query: Unknown column 'reg_id' in 'field list' (1054)
kamailio: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query
kamailio: ERROR: p_usrloc [ul_db_query.c:110]: db_exec_query(): could not query table location.
</code></pre>
<pre><code>kamailio: ERROR: db_mysql [km_dbase.c:127]: db_mysql_submit_query(): driver error on query: Unknown column 'ruid' in 'field list' (1054)
kamailio: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query
kamailio: ERROR: p_usrloc [ul_db_query.c:110]: db_exec_query(): could not query table location.
</code></pre>
<h3>Solutions</h3>
<p>Adding columns referenced by <a href="https://github.com/kamailio/kamailio/blob/6c01e2692d5ff56dda54d21469d32c4d3dcbfbff/src/modules/p_usrloc/p_usrloc_mod.c#L65">p_usrloc_mod.c</a> to match <code>kamdbctl</code>'s <a href="https://github.com/kamailio/kamailio/blob/6c01e2692d5ff56dda54d21469d32c4d3dcbfbff/utils/kamctl/mysql/usrloc-create.sql#L3">usrloc-create.sql</a></p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/kamailio/kamailio/issues/1265">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AF36ZWy8v4e3AgkIC1jRm9GXH6Bz6PU3ks5sqKAhgaJpZM4PxqAF">mute the thread</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AF36Zc2hFfMvZL0aKABbomPV8qyiU8-Lks5sqKAhgaJpZM4PxqAF.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
  <link itemprop="url" href="https://github.com/kamailio/kamailio/issues/1265"></link>
  <meta itemprop="name" content="View Issue"></meta>
</div>
<meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>

<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/kamailio/kamailio","title":"kamailio/kamailio","subtitle":"GitHub repository","main_image_url":"https://cloud.githubusercontent.com/assets/143418/17495839/a5054eac-5d88-11e6-95fc-7290892c7bb5.png","avatar_image_url":"https://cloud.githubusercontent.com/assets/143418/15842166/7c72db34-2c0b-11e6-9aed-b52498112777.png","action":{"name":"Open in GitHub","url":"https://github.com/kamailio/kamailio"}},"updates":{"snippets":[{"icon":"DESCRIPTION","message":"p_usrloc: location.sql missing RUID_COL and REG_ID_COL (#1265)"}],"action":{"name":"View Issue","url":"https://github.com/kamailio/kamailio/issues/1265"}}}</script>