UPGRADE FROM 2.9.02 TO V.2.9.99 INSTRUCTIONS:


1) Unzip the new version in the modules dir but not in dir leonardo/ but something other like  leo/

If you are running phpbb copy also the following files (from the new dir you just made )

doc/install/phpbb2Files/mainfile.php -> main phpbb dir
doc/install/phpbb2Files/modules.php -> main phpbb dir
doc/install/phpbb2Files/page_header_leonardo.php -> includes/ dir under the main phpbb dir
doc/install/phpbb2Files/page_tail_leonardo.php -> includes/ dir under the main phpbb dir

BEFORE COPYING THESE 4 FILES MAKE A BACKUP OF THE ORGINAL TARGET FILES


2) run the provided SQL on your main DB.

***********************

MAKE A BACKUP OF YOUR DB

*********************

The SQL to run is in file /doc/install/upgrade_2.0.0_fixes/upgrade_2.0.0_fixes.sql

 

For upgrading from 2.9.02 search the file for

#2008/05/05

and execute only sql commands after this line


3)

**********************

THIS STEP IS IMPORTANT DO NOT SKIP IT

**********************

You need command line access to linux servers or a C compiler in Windows

from commnand line go to the loenardo/server directory and once in there execute:

gcc -o olc -lm -O6 olc2002.c

In windows you must find a way to compile the olc2002.c to OLC.EXE


4) No need for new site/ files, copy over your old site/ dir

** By this time your new version will be available at /modules.php?name=leo
Test the basic functionality. because the fligths/ and maps/ dir are not yet moved the fligth display screen
will not display maps/ and charts. **

 

THE FOLLOWING STEPS 6,6,7 MUST BE DONE AS FAST AS POSSBILE TOGETHER SO THAT NORMAL OPERATION IS NOT DISTURBED



5) MOVE (or copy but it is not nessasary) the


flights/
maps/
data/

files from the leonardo/ dir to leo/ (no backup is really needed)

** By this time your new version will be available at /modules.php?name=leo
Test ALL the functionality now that the fligths/ and maps/ dir are moved to the right place.. **


6) rename leonardo/ to leonardo_old/ ?(or anything you wish)


7) rename leo/  to leonardo/ and you are done!

** Test again all features on new version, if big problems,
revert to old by using the steps in reverse order.
(YOU NEED TO RESTORE YOUR DB FROM THE BACKUP YUOU MADE) **




This is a fail safe method until this step , now we will do some changes in the DB from the admin interface that will move the DB into newer version


ADDITIONAL STEPS

 

1. From Admin-Menu:

Use these to find any problems with the flights uploaded so far

1. Find missing IGC  

2. Find bad filenames (due to non-latin chars)

2. Migrate to 2.9.99

From Admin menu proccess all 3 options one after the other under

Migrate to changes 2008/05/20

2. Update Scoring

1.Clean the batchProcessed field for all flights

2. Then repeat until the message at the bottom says "0 flights scored"

Update XC Scoring

you can try with small values 200 in the text box and increase this to larger values (ie.1000-5000) if your script doesnt timeout

***********************

THIS WILL TAKE LONG AND USE CPU 100%
IT MAY TAKE 1 HOUR TO RESCORE 2000-5000 FLIGHTS DEPENDING ON THE CPU
ON DUAL CPU SYSTEM THIS IS NOT A PROBLEM, SINCE ONLY ONE CPU IS USED.
ON SINGLE CPU SYSTEMS THIS WILL SLOW DOWN THE SERVER

*********************

 

3. Make the hashes

Use the option "Make hashes for all flights" under the "Migration to newer DB schemes operations" in "admin" menu

This is required so no flight can be netered twice in the system.

4. Rebuild the logs (MUST BE PERFORMED LAST ! )

Use the 2 options under "Sync Log oparations"

Use "Clean sync-log" one time and then
Use "Remake sync-log" in batches of 500-1000 until it reports no other flights