<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<font face="monospace">Hi,<br>
<br>
That;s not the recommended way to fix the issue, as the the
structure of the `dispatcher ` table is actually different in 3.4
and 3.1. Bypassing the check may result in failing DB queries.<br>
<br>
The proper fix is install the correct dispatcher table for 3.4:<br>
<a class="moz-txt-link-freetext" href="https://github.com/OpenSIPS/opensips/blob/3.4/scripts/mysql/dispatcher-create.sql">https://github.com/OpenSIPS/opensips/blob/3.4/scripts/mysql/dispatcher-create.sql</a><br>
<br>
Or use the db migration/create functionality of opensips-cli<br>
<br>
Regards,<br>
</font>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="https://www.opensips-solutions.com">https://www.opensips-solutions.com</a>
<a class="moz-txt-link-freetext" href="https://www.siphub.com">https://www.siphub.com</a></pre>
<div class="moz-cite-prefix">On 9/10/23 10:02 AM, Social Boh wrote:<br>
</div>
<blockquote type="cite"
cite="mid:edbd3677-c1d2-e0a7-49b7-7595af38162d@bohboh.info">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<p>mysql -u root -p</p>
<p>use opensips</p>
<p>update version set table_version='9' where
table_name='dispatcher';</p>
<p>quit</p>
<pre class="moz-signature" cols="72">---
I'm SoCIaL, MayBe</pre>
<div class="moz-cite-prefix">El 10/09/2023 a las 12:33 a. m.,
Saint Michael escribió:<br>
</div>
<blockquote type="cite"
cite="mid:CAC9cSOBTr2z9kY5GJ=eqG1PeaNzBH2fO32A4JMNF7DQUniUORw@mail.gmail.com">
<meta http-equiv="content-type" content="text/html;
charset=UTF-8">
<div dir="ltr">
<div class="gmail_default" style="font-size:small">I attempted
an upgrade to version 3.4 from 3.1 and It failed</div>
<div class="gmail_default" style="font-size:small">ERROR:core:db_check_table_version:
invalid version 8 for table dispatcher found, expected 9<br>
ERROR:dispatcher:mod_init: failed to init database support<br>
ERROR:core:init_mod: failed to initialize module dispatcher<br>
ERROR:core:main: error while initializing modules<br>
</div>
<div class="gmail_default" style="font-size:small"><br>
</div>
<div class="gmail_default" style="font-size:small">how do I
upgrade the dispatcher table from 8 version 8 to version 9?</div>
<div class="gmail_default" style="font-size:small">The script
is fine.</div>
<div class="gmail_default" style="font-size:small"><br>
</div>
<div class="gmail_default" style="font-size:small"><br>
</div>
<div class="gmail_default" style="font-size:small"><br>
</div>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org" moz-do-not-send="true">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" moz-do-not-send="true">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>