<p></p>
<h3>Description</h3>
<p><code>Version</code> table in default <code>db_text</code> creation has incorrect structure.</p>
<h3>Troubleshooting</h3>
<p>version table is</p>
<h4>Reproduction</h4>
<p>Installing Kamailio 5.4 from Debian repos. Tuning <strong>kamdbctl</strong> to DBTEXT.<br>
Running <code>kamdbctl create</code></p>
<p>Check <code>version</code> table.</p>
<p>Shows something like</p>
<pre><code>id(int,auto) table_name(string) table_version(int)
version:1
...
</code></pre>
<p>Should be</p>
<pre><code>table_name(string) table_version(int)
version:1
</code></pre>
<p>or with <code>id</code> index</p>
<h3>Possible Solutions</h3>
<p>Manually delete <code>id(int,auto)</code> from <code>version</code></p>
<h3>Additional Information</h3>
<ul>
<li><strong>Kamailio Version</strong> - output of <code>kamailio -v</code></li>
</ul>
<pre><code>/# kamailio -v
version: kamailio 5.4.1 (x86_64/linux) 
flags: USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, USE_RAW_SOCKS, DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MMAP, PKG_MALLOC, Q_MALLOC, F_MALLOC, TLSF_MALLOC, DBG_SR_MEMORY, USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT, USE_DNS_CACHE, USE_DNS_FAILOVER, USE_NAPTR, USE_DST_BLACKLIST, HAVE_RESOLV_RES, TLS_PTHREAD_MUTEX_SHARED
ADAPTIVE_WAIT_LOOPS 1024, MAX_RECV_BUFFER_SIZE 262144, MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB
poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.
id: unknown 
compiled with gcc 8.3.0
</code></pre>
<ul>
<li><strong>Operating System</strong>:</li>
</ul>
<p>Debian 10/Docker image</p>
<pre><code># uname -a
Linux 9b7efa852274 5.3.18-lp152.36-default #1 SMP Tue Aug 18 17:09:44 UTC 2020 (885251f) x86_64 GNU/Linux
</code></pre>

<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/2463">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/ABO7UZM2VAKIVA7NM7XHH7TSDXOYBANCNFSM4QSTUHLA">unsubscribe</a>.<img src="https://github.com/notifications/beacon/ABO7UZI26DGKZTWX5EIXD43SDXOYBA5CNFSM4QSTUHLKYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4KJL7HTQ.gif" height="1" width="1" alt="" /></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/kamailio/kamailio/issues/2463",
"url": "https://github.com/kamailio/kamailio/issues/2463",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>