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 dirBEFORE 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
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
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)
From Admin menu proccess all 3 options one after the other under
Migrate to changes 2008/05/20
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
*********************
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.
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