Upgrading and the versions

Support forum for the ViciBox ISO Server Install and ISO LiveCD Demo

Moderators: enjay, williamconley, Staydog, mflorell, MJCoate, mcargile, Kumba

Upgrading and the versions

Postby bghayad » Sat Feb 27, 2016 7:51 pm

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
bghayad
 
Posts: 579
Joined: Sun Jan 01, 2012 4:53 pm

Re: Upgrading and the versions

Postby williamconley » Sat Feb 27, 2016 8:33 pm

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.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Upgrading and the versions

Postby Kumba » Sun Feb 28, 2016 9:00 pm

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.
Kumba
 
Posts: 939
Joined: Tue Oct 16, 2007 11:44 pm
Location: Florida


Return to ViciBox Server Install and Demo

Who is online

Users browsing this forum: No registered users and 83 guests