vicidial.org

Hello;

vicibox 4.0.3, vicidial 2.8-404a, Build 130605-0841, asterisk 1.4.39.1-vici, Single Machine

I need to upgrade for latest vicibox which is 7.0.1 but I am facing the problem with the running the scripts upgrade_2.8.sql and upgrade_2.10.sql and upgrade_2.12.sql as it always give me that there are missing tables or duplicate in the tables. I checked manifest.txt and I found the following:

upgrade_2.0.5.sql 1074
upgrade_2.2.0.sql 1135
upgrade_2.4.sql 1193
upgrade_2.6.sql 1316
upgrade_2.8.sql 1347
upgrade_2.10.sql 1378
upgrade_2.12.sql 1403

I need to kno what it is meant by upgrade_2.8.sql 1347? Does it means that to be able to upgrade from 2.8 version then the build should be 1347? Or what?
From the other side: what is the solution for my case as my build is 841?

And thanks a lot for the kindly help.
Regards
Bilal

you're skipping around and expecting a catch-all solution.

baby steps. one step at a time.

you run upgrade_2.8.sql ... and you get an error. What is the error? what DB schema are you presently at? and what DB schema is the line associated with the error? note that you do not need to run any entries from the file that are before your present db schema.

provide us with the error, and we may be able to help you get past THAT error. then we tackle the next one.

bghayad wrote:I need to kno what it is meant by upgrade_2.8.sql 1347? Does it means that to be able to upgrade from 2.8 version then the build should be 1347? Or what?

It means that the upgrade_2.8.sql file will take you up to DB Schema Revision 1347. If your DB Schema Version is higher then 1347, then you would not run upgrade_2.8.sql. You would run the next entry in the manifest, like upgrade_2.10.sql.

Also, if you've been randomnly running upgrade schema files without knowing what you are doing, you'll likely need to run them all and ignore any errors you get, or find out what your original db_schema_version was before you hacked your way through the database with the upgrade schemas. I hope you have good back-up's. Alternatively, if you have ViciBox v.5 or better, you can try running the vicidial-mysqldiff to see what changes you need to make to get the schema upgraded to the SVN.