How to – Fix the Vicidial error: Code Expects Different Schema

How to – Fix the Vicidial error: Code Expects Different Schema

This is a pretty easy fix, “Code Expects Different Schema” occurs when you update your svn version but forget to update the db schema through mysql. The instructions are below.

After database dump restoration taken from older Vicibox to the latest Vicibox 9.0.3 I got the following error in Admin -> System Settings section:

WARNING: Code expects different schema: 1585

It’s not possible to change or save any setting. The reason is obvious: Vicibox 9 has new and altered tables and functions so you will have to add them to the restored database before you can use system.

First, confirm your current database schema version. Log in to MariaDB command prompt and perform the following query:

1MariaDB> SELECT db_schema_version FROM system_settings;

Next, navigate to /usr/src/astguiclient/trunk/extras folder and locate upgrade_X.XX.sql files. Open the newest file and if it contains this schema version – this is the one that needs to be executed. In case you found your DB schema version not in the newest .sql , execute it first and then all newer files.

Please make note that some tables and functions may already exist in your database that’s why add -f key to the mysql command:

1# mysql -u root -f asterisk < /usr/src/astguiclient/trunk/extras/upgrade_2.14.sql

Confirm your current database schema version again and make sure it’s been upgraded.

Now you should be able to use the system and change/set settings.

I hope this helps

-Nox

Carpenox

View Comments

Recent Posts

How to – Fix the “You don’t have permission to access /RECORDINGS/MP3/” error within ViciDial

How to - Fix the "You don't have permission to access /RECORDINGS/MP3/" error within ViciDial…

1 day ago

Navigating the Future: Artificial Intelligence in the Call Center Industry

Navigating the Future: Artificial Intelligence in the Call Center Industry In the ever-evolving landscape of…

1 week ago

How to – Setup a ViciDial Cluster with scratch installs

How to - Setup a ViciDial Cluster with scratch installs This article is going to…

4 weeks ago

Unlocking the Future of Call Centers: Introducing CyburDial’s Call Center as a Service (CCaaS)

Unlocking the Future of Call Centers: Introducing CyburDial's Call Center as a Service (CCaaS) In…

4 weeks ago

Choosing the Right Call Center Solution: CyburDial vs. ReadyMode vs. Convoso

Choosing the Right Call Center Solution: CyburDial vs. ReadyMode vs. Convoso In the fast-paced world…

1 month ago

How to – Set Up Asterisk 18 with ConfBridge for ViciDial with Bug fixes for monitoring

How to - Set Up Asterisk 18 with ConfBridge for ViciDial with Bug fixes for…

2 months ago

This website uses cookies.