<div dir="ltr">Hmm, for me it looks like it is the wrong table. Should be "
<span class="gmail-pl-en">rls_watchers</span>" not "
<span class="gmail-pl-en">rls_presentity</span>" So it is a error on the SQ upgrade commands from <a href="https://www.kamailio.org/wiki/install/upgrade/3.1.x-to-3.2.0">https://www.kamailio.org/wiki/install/upgrade/3.1.x-to-3.2.0</a><br></div><div class="gmail_extra"><br><div class="gmail_quote">2018-05-29 16:19 GMT+02:00 Kristijan Vrban <span dir="ltr"><<a href="mailto:vrban.lkml@gmail.com" target="_blank">vrban.lkml@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Hi,</div><div><br></div><div>i try a upgrade from old 3.0.3 Kamailio mysql db. Got stuck with 
update the structure

: <br></div><div>
<pre class="m_5363899840586254572gmail-code m_5363899840586254572gmail-sql"><span class="m_5363899840586254572gmail-kw1">ALTER</span> <span class="m_5363899840586254572gmail-kw1">TABLE</span> rls_presentity <span class="m_5363899840586254572gmail-kw1">MODIFY</span> callid <span class="m_5363899840586254572gmail-kw1">VARCHAR</span><span class="m_5363899840586254572gmail-br0">(</span><span class="m_5363899840586254572gmail-nu0">255</span><span class="m_5363899840586254572gmail-br0">)</span> <span class="m_5363899840586254572gmail-kw1">NOT</span> <span class="m_5363899840586254572gmail-kw1">NULL</span>;
<span class="m_5363899840586254572gmail-kw1">ALTER</span> <span class="m_5363899840586254572gmail-kw1">TABLE</span> rls_presentity <span class="m_5363899840586254572gmail-kw1">MODIFY</span> contact <span class="m_5363899840586254572gmail-kw1">VARCHAR</span><span class="m_5363899840586254572gmail-br0">(</span><span class="m_5363899840586254572gmail-nu0">128</span><span class="m_5363899840586254572gmail-br0">)</span> <span class="m_5363899840586254572gmail-kw1">NOT</span> <span class="m_5363899840586254572gmail-kw1">NULL</span>;</pre>

</div><div>found on: 
<a href="https://www.kamailio.org/wiki/install/upgrade/3.1.x-to-3.2.0" target="_blank">https://www.kamailio.org/wiki/<wbr>install/upgrade/3.1.x-to-3.2.0</a>

<br></div><div><br></div><div>But this two table does not exist? See also table definition at: <a href="https://kamailio.org/docs/db-tables/kamailio-db-3.1.x.html#GEN-DB-RLS-PRESENTITY" target="_blank">https://kamailio.org/docs/db-<wbr>tables/kamailio-db-3.1.x.html#<wbr>GEN-DB-RLS-PRESENTITY</a></div><div><br></div><div>I reckon it is safe to skip this to tables?</div><span class="HOEnZb"><font color="#888888"><div><br></div><div>Kristijan<br></div></font></span></div>
</blockquote></div><br></div>