New failed upgrade (to vaultwiki_4-0-0_Beta_4_patch_07-14-2013)

[Morrus]

I got this:

Parse error: syntax error, unexpected ')', expecting ']' in /var/www/virtual/enworld/forum/vault/core/controller/install/upgradepath/steps/4/0/0/beta/4/4X/vb4.php on line 74

[pegasus]

In vault/core/controller/install/upgradepath/steps/4/0/0/beta/4/4X/vb4.php, find:

if (isset($tag_done[$tag['tag']))

Replace with:

if (isset($tag_done[$tag['tag']]))

[Morrus]

Thanks.

Got as far as 32%:

Upgrading to 4.0.0 Beta 4
Step 7

Updating data in table: vw_redirect
Database Error 	Database error
The EN World: RPG News & Reviews database has encountered a problem.
Please try the following:

    Load the page again by clicking the Refresh button in your web browser.
    Open the www.enworld.org home page, then try to open another page.
    Click the Back button to try another link.

The www.enworld.org forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.
Database error in vBulletin 4.2.1: Invalid SQL: UPDATE `vw_redirect` SET `reason` = CASE `redirectid` WHEN 1 THEN 'Legendfall' WHEN 2 THEN 'Iron DM Winter 2003' WHEN 3 THEN 'Legendfall' WHEN 4 THEN 'Iron DM Winter 2003' WHEN 5 THEN 'ZEITGEIST: The Gears of Revolution Players Guide' WHEN 6 THEN 'Vancian' WHEN 7 THEN 'Delete me' WHEN 8 THEN 'Campaign Overview' WHEN 9 THEN 'A World of Tainted Legacy' WHEN 10 THEN 'BURNED CIRCLE - Game Rules' WHEN 11 THEN 'Iron DM 2012' WHEN 12 THEN 'OGRE' WHEN 13 THEN 'O.G.R.E.' WHEN 14 THEN 'Delete me' WHEN 15 THEN 'Campaign Overview' WHEN 16 THEN 'A World of Tainted Legacy' WHEN 17 THEN 'BURNED CIRCLE - Game Rules' WHEN 18 THEN 'Iron DM 2012' WHEN 19 THEN 'OGRE' WHEN 20 THEN 'O.G.R.E.' WHEN 21 THEN 'Deleted #2' WHEN 22 THEN 'Deleted #2' WHEN 23 THEN 'Knightfall\'s World of Kulan D&D v.3.5 Campaign Setting' WHEN 24 THEN 'Shadow Wars' WHEN 25 THEN 'Storminator: Characters' WHEN 26 THEN 'Wizards of the Coast' WHEN 27 THEN 'Dungeons & Dragons' WHEN 28 THEN 'From TSR to WotC: A History of D&D' WHEN 29 THEN 'From TSR to WotC: A History of D&D' WHEN 30 THEN 'Star Wars RPG' WHEN 31 THEN 'Revised d20 System Reference Document' WHEN 32 THEN 'Wizards of the Coast' WHEN 33 THEN 'Dungeons & Dragons' WHEN 34 THEN 'From TSR to WotC: A History of D&D' WHEN 35 THEN 'From TSR to WotC: A History of D&D' WHEN 36 THEN 'Star Wars RPG' WHEN 37 THEN 'Revised d20 System Reference Document' WHEN 38 THEN 'Wizards of the Coast' WHEN 39 THEN 'Dungeons & Dragons' WHEN 40 THEN 'From TSR to WotC: A History of D&D' WHEN 41 THEN 'From TSR to WotC: A History of D&D' WHEN 42 THEN 'Star Wars RPG' WHEN 43 THEN 'Revised d20 System Reference Document' WHEN 44 THEN 'Skills+I#Appraise' WHEN 45 THEN 'Skills+I#Appraise' WHEN 46 THEN 'Services and Feats' WHEN 47 THEN 'Classes' WHEN 48 THEN 'Ability Scores#Strength' WHEN 49 THEN 'Modern Lifestyle Items & Services' WHEN 50 THEN 'Classes' WHEN 51 THEN 'Modern Skills' WHEN 52 THEN 'Cybernetics' WHEN 53 THEN 'Engineer' WHEN 54 THEN 'Soldier' WHEN 55 THEN 'Modern Skills#Pilot (Dex) Trained Only' WHEN 56 THEN 'Open Gaming Content' WHEN 57 THEN 'Open Gaming License' WHEN 58 THEN 'Shipboard Equipment' WHEN 59 THEN 'Modern Skills#Balance (Dex; Armor Penalty)' WHEN 60 THEN 'Modern Skills# (Cha)' WHEN 61 THEN 'Modern Skills#Climb (Str - Armor Penalty)' WHEN 62 THEN 'Modern Skills#Computer Use (Int)' WHEN 63 THEN 'Modern Skills#Concentration (Con)' WHEN 64 THEN 'Modern Skills#Craft (Int)' WHEN 65 THEN 'Modern Skills#Decipher Script (Int - Trained Only)' WHEN 66 THEN 'Modern Skills#Demolitions (Int) Trained Only' WHEN 67 THEN 'Modern Skills#Diplomacy (Cha)' WHEN 68 THEN 'Modern Skills#Disable Device (Int) Trained Only' WHEN 69 THEN 'Modern Skills#Disguise (Cha)' WHEN 70 THEN 'Modern Skills#Drive (Dex)' WHEN 71 THEN 'Modern Skills#Escape Artist (Dex) Armor Penalty' WHEN 72 THEN 'Modern Skills#Forgery (Int)' WHEN 73 THEN 'Modern Skills#Gamble (Wis)' WHEN 74 THEN 'Modern Skills#Gather Information (Cha)' WHEN 75 THEN 'Modern Skills#Handle Animal (Cha) Trained Only' WHEN 76 THEN 'Modern Skills#Hide (Dex) Armor Penalty' WHEN 77 THEN 'Modern Skills#Intimidate (Cha)' WHEN 78 THEN 'Modern Skills#Investigate (Int) Trained Only' WHEN 79 THEN 'Modern Skills#Jump (Str) Armor Penalty' WHEN 80 THEN 'Modern Skills#Knowledge (Int) Trained Only' WHEN 81 THEN 'Modern Skills#Listen (Wis)' WHEN 82 THEN 'Modern Skills#Move Silently (Dex) Armor Penalty' WHEN 83 THEN 'Modern Skills#Navigate (Int)' WHEN 84 THEN 'Modern Skills#Perform (Cha)' WHEN 85 THEN 'Modern Skills#Profession (Wis)' WHEN 86 THEN 'Modern Skills#Read/Write Language (None) Trained Only' WHEN 87 THEN 'Modern Skills#Repair (Int) Trained Only' WHEN 88 THEN 'Modern Skills#Research (Int)' WHEN 89 THEN 'Modern Skills#Ride (Dex)' WHEN 90 THEN 'Modern Skills#Search (Int)' WHEN 91 THEN 'Modern Skills#Sense Motive (Wis)' WHEN 92 THEN 'Modern Skills#Sleight of Hand (Dex) Trained Only; Armor Penalty' WHEN 93 THEN 'Modern Skills#Speak Language (None) Trained Only' WHEN 94 THEN 'Modern Skills#Spot (Wis)' WHEN 95 THEN 'Modern Skills#Survival (Wis)' WHEN 96 THEN 'Modern Skills#Swim (Str) Armor Penalty' WHEN 97 THEN 'Modern Skills#Treat Injury (Wis)' WHEN 98 THEN 'Modern Skills#Tumble (Dex) Trained Only; Armor Penalty' WHEN 99 THEN 'Ability Scores#Dexterity' WHEN 100 THEN 'Ability Scores#Con' WHEN 101 THEN 'Ability Scores#Intelligence' WHEN 102 THEN 'Ability Scores#Wisdom' WHEN 103 THEN 'Ability Scores#Charisma' WHEN 104 THEN 'Ability Scores#Strength' WHEN 105 THEN 'Ability Scores#Dexterity' WHEN 106 THEN 'Ability Scores#Constitution' WHEN 107 THEN 'Ability Scores#Intelligence' WHEN 108 THEN 'Ability Scores#Wisdom' WHEN 109 THEN 'Ability Scores#Charisma' WHEN 110 THEN 'World of Kulan (gid:23)' WHEN 111 THEN 'Morrus\' ZEITGEIST Campaign (gid:220)' WHEN 112 THEN 'Esoteric Order of the Golden Globe (gid:227)' WHEN 113 THEN 'Plaguelands (gid:332)' WHEN 114 THEN 'Libertas (gid:352)' WHEN 115 THEN 'Deeds Not Words (gid:353)' WHEN 116 THEN 'Dark Days in Sion (gid:359)' WHEN 117 THEN 'Central Castings Revival (gid:360)' WHEN 118 THEN 'Central Houston D&D Next (gid:363)' WHEN 119 THEN 'The Planar Chorus (gid:364)' WHEN 120 THEN 'System Reference Documents' WHEN 121 THEN 'd20 Modern SRD' WHEN 122 THEN 'Pathfinder RPG' WHEN 123 THEN 'The Charismatic Hero' WHEN 124 THEN 'The Dedicated Hero' WHEN 125 THEN 'The Smart Hero' WHEN 126 THEN 'The Tough Hero' WHEN 127 THEN 'The Fast Hero' WHEN 128 THEN 'The Strong Hero' WHEN 129 THEN 'd20-Modern:Modern-Skills#Balance-Dex-Armor-Penalty' WHEN 130 THEN 'd20-Modern:Modern-Skills#Balance-Dex-Armor-Penalty' WHEN 131 THEN 'Starships' WHEN 132 THEN 'Condition Summary' END WHERE `redirectid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132); 

MySQL Error : Unknown column 'reason' in 'field list'
Error Number : 1054
Request Date : Tuesday, July 30th 2013 @ 02:52:56 PM
Error Date : Tuesday, July 30th 2013 @ 02:52:56 PM
Script : http://www.enworld.org/forum/vault/install/index.php?step=7&nostyle=1
Referrer : http://www.enworld.org/forum/vault/install/index.php?step=6&nostyle=1
Username : Morrus
Classname : vB_Database
MySQL Version : 5.5.29

[pegasus]

In vault/core/controller/install/upgradepath/steps/4/0/0/beta/4/base/vw.php, find:

						'reason' => array(
							'case' => 'redirectid',

Replace with:

						'target' => array(
							'case' => 'redirectid',

[Morrus]

After doing that should I then just hit refresh on the installer?

(Note, it found 'reason' => array( twice... also at:

'reason' => array(
'case' => 'revisionid',

I haven't changed that though)

[pegasus]

Only change it for case => redirectid

Yes, hit refresh on the installer and it should continue from the same place.

[Morrus]

Got it. Thanks! All upgraded.