Hi Dan, It's probably a good idea to go through intermediate version for the upgrade. For example, 1.5 -> 1.7 -> 1.9 -> 1.11 -> 1.13. You may be able to make bigger jumps, but going two versions up should always be safe.
There is an archive of older releases here: http://download.wikimedia.org/mediawiki/ Regards, Leons Petrazickis http://lpetr.org/blog/ On Fri, May 1, 2009 at 11:34, Dan Tomlinson <[email protected]> wrote: > Hi all, > > I am trying to upgrade an old mediawiki installation (version 1.5.8) to > the latest version, following the upgrade instructions here: > > http://www.mediawiki.org/wiki/Manual:Upgrading_to_1.14 > > I backed up the database and files from the old installation and > unpacked the new version over the top of my existing installation using > the following command: > > tar xvfz mediawiki-1.14.0.tar.gz -C /path/to/my/wiki/ --strip-components=1 > > I then updated AdminSettings.php to be my root mysql user, changed to > the maintenance directory and ran: > > php update.php --aconf ../AdminSettings.php > > This gave me the following output: > >> # php update.php --aconf ../AdminSettings.php >> >> MediaWiki 1.14.0 Updater >> >> Going to run database updates for ccbi_micklem >> Depending on the size of your database this may take a while! >> Abort with control-c in the next five seconds...0 >> ...have ipb_id field in ipblocks table. >> ...have ipb_expiry field in ipblocks table. >> ...already have interwiki table >> ...indexes seem up to 20031107 standards >> ...hitcounter table already exists. >> ...have rc_type field in recentchanges table. >> ...have user_real_name field in user table. >> ...querycache table already exists. >> ...objectcache table already exists. >> ...categorylinks table already exists. >> Already have pagelinks; skipping old links table updates. >> ...have rc_ip field in recentchanges table. >> ...image primary key already set. >> ...have rc_id field in recentchanges table. >> ...have rc_patrolled field in recentchanges table. >> ...logging table already exists. >> ...have user_token field in user table. >> The watchlist table is already set up for email notification. >> ...watchlist talk page rows already present >> ...user table does not contain old email authentication field. >> ...page table already exists. >> ...have log_params field in logging table. >> logging table has correct log_title encoding. >> ...archive table does not exist, skipping new field patch >> ...have page_len field in page table. >> revision timestamp indexes already up to 2005-03-13 >> ...rev_text_id already in place. >> ...have rev_deleted field in revision table. >> ...have img_width field in image table. >> ...have img_metadata field in image table. >> ...have user_email_token field in user table. >> ...archive table does not exist, skipping new field patch >> ...page_namespace is already a full int (int(11)). >> A database query syntax error has occurred. >> The last attempted database query was: >> "SHOW COLUMNS FROM `archive` LIKE 'ar_namespace'" >> from within function "". >> MySQL returned error "1146: Table 'mywiki.archive' doesn't exist >> (localhost)". > When I then browse to the wiki I get the following error: > > from within function "Job::pop". MySQL returned error "1146: Table > 'mywiki.job' doesn't exist (localhost)". > > Having failed on this tack, I wiped everything and restored from backup > to attempt "Alternative 2". The web installed gave the following output: > > > Checking environment... > > /Please include all of the lines below when reporting installation > problems./ > > * PHP 5.2.5 installed > * Found database drivers for: MySQL > * PHP server API is apache2handler; ok, using pretty URLs > (index.php/Page_Title) > * Have XML / Latin1-UTF-8 conversion support. > * Session save path (/var/lib/php/session) appears to be valid. > * PHP's memory_limit is 128M. > * eAccelerator <http://eaccelerator.sourceforge.net/> installed > * Found GNU diff3: /usr/bin/diff3. > * Found ImageMagick: /usr/bin/convert; image thumbnailing will be > enabled if you enable uploads. > * Found GD graphics library built-in. > * Installation directory: /var/www/WIKI > * Script URI path: /wiki > * Installing MediaWiki with php file extensions > * Environment checked. You can install MediaWiki. > * > > *Generating configuration file...* > > * Database type: MySQL > * Loading class: DatabaseMysql > * Attempting to connect to database server as ccbi_wiki...success. > * Connected to mysql 5.0.27; enabling MySQL 4.1/5.0 charset mode > * Database mywiki exists > * There are already MediaWiki tables in this database. Checking if > updates are needed... > * *Warning:* you requested the mysql5-binary schema, but the > existing database has the mysql4 schema. This upgrade script can't > convert it, so it will remain mysql4. > * *Warning:* you requested the InnoDB storage engine, but the > existing database uses the MyISAM engine. This upgrade script > can't convert it, so it will remain MyISAM. > > ...have ipb_id field in ipblocks table. > ...have ipb_expiry field in ipblocks table. > ...already have interwiki table > ...indexes seem up to 20031107 standards > ...hitcounter table already exists. > ...have rc_type field in recentchanges table. > ...have user_real_name field in user table. > ...querycache table already exists. > ...objectcache table already exists. > ...categorylinks table already exists. > Already have pagelinks; skipping old links table updates. > ...have rc_ip field in recentchanges table. > ...image primary key already set. > ...have rc_id field in recentchanges table. > ...have rc_patrolled field in recentchanges table. > ...logging table already exists. > ...have user_token field in user table. > The watchlist table is already set up for email notification. > ...watchlist talk page rows already present > ...user table does not contain old email authentication field. > ...page table already exists. > ...have log_params field in logging table. > logging table has correct log_title encoding. > ...archive table does not exist, skipping new field patch > ...have page_len field in page table. > revision timestamp indexes already up to 2005-03-13 > ...rev_text_id already in place. > ...have rev_deleted field in revision table. > ...have img_width field in image table. > ...have img_metadata field in image table. > ...have user_email_token field in user table. > ...archive table does not exist, skipping new field patch > ...page_namespace is already a full int (int(11)). > > > This script does not seem to have finished and there was no LocalSettings.php > created. When I moved the LocalSettings.old.php to LocalSettings.php and > browse to the wiki I get the following error: > > > from within function "Job::pop". MySQL returned error "1146: Table > 'mywiki.job' doesn't exist (localhost)". > > So thats it, I'm currently stuck at version 1.5.8 :( > > Does anyone have any idea how I can get past this and upgrade to the latest > version? Please do not hesitate to ask if you need more information to debug > this. > > Many thanks in advance, > Dan T. > > > _______________________________________________ > Wikitech-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wikitech-l > _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
