[OpenSIPS-Users] upgrade failed

[Bogdan-Andrei Iancu]

Hi,

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.

The proper fix is install the correct dispatcher table for 3.4:
https://github.com/OpenSIPS/opensips/blob/3.4/scripts/mysql/dispatcher-create.sql

Or use the db migration/create functionality of opensips-cli

Regards,

Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
   https://www.opensips-solutions.com
   https://www.siphub.com

On 9/10/23 10:02 AM, Social Boh wrote:
>
> mysql -u root -p
>
> use opensips
>
> update version set table_version='9' where table_name='dispatcher';
>
> quit
>
> ---
> I'm SoCIaL, MayBe
> El 10/09/2023 a las 12:33 a. m., Saint Michael escribió:
>> I attempted an upgrade to version 3.4 from 3.1 and It failed
>> ERROR:core:db_check_table_version: invalid version 8 for table 
>> dispatcher found, expected 9
>> ERROR:dispatcher:mod_init: failed to init database support
>> ERROR:core:init_mod: failed to initialize module dispatcher
>> ERROR:core:main: error while initializing modules
>>
>> how do I upgrade the dispatcher table from 8 version 8 to version 9?
>> The script is fine.
>>
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20230919/27522e2f/attachment.html>