Trouble Upgrading Forum

[markhendo1986]

Hi, I've attempted to upgrade my forums to the latest version of vBulletin.

All was going well up until I ran the upgrade script in the browser (Having already backed up existing files, moved new files/folders into directory, renamed config.php, etc).

When processing step 1 of 5 in the upgrade system, I am greeted by the following error:

Step 1) Miscellaneous table alterations 1/4
 
Altering moderatorlog Table (1 of 1) 
Altering reputation Table (1 of 1) 
Altering usergroupleader Table (1 of 1) Database error 
The Championship Manager 2001/2002 Forums database has encountered a problem. 
 
--------------------------------------------------------------------------------
 
Please try the following: 
Load the page again by clicking the Refresh button in your web browser. 
Open the [URL="https://www.vbulletin.com/link.php?u=http%3A%2F%2Fwww.champman0102.co.uk"]http://www.champman0102.co.uk[/URL] home page, then try to open another page. 
Click the Back button to try another link. 
 
The [URL="https://www.vbulletin.com/link.php?u=http%3A%2F%2Fwww.champman0102.co.uk"]http://www.champman0102.co.uk[/URL] forum technical staff have been notified of the error, though you may contact them if the problem persists. 
 
We apologise for any inconvenience.

And the exact database error message below the above error is:

Database error in vBulletin 3.0.1:
 
Invalid SQL:
ALTER TABLE usergroupleader ADD index ugl (userid, usergroupid);
 
MySQL Error : Duplicate key name 'ugl'
Error Number : 1061
Request Date : Wednesday, February 11th 2009 @ 12:44:04 PM
Error Date : Wednesday, February 11th 2009 @ 12:44:04 PM
Script : [URL="https://www.vbulletin.com/link.php?u=http%3A%2F%2Fwww.champman0102.co.uk%2Fforum%2Finstall%2Fupgrade_302.php%3Fstep%3D1"]http://www.champman0102.co.uk/forum/install/upgrade_302.php?step=1[/URL]
Referrer : [URL="https://www.vbulletin.com/link.php?u=http%3A%2F%2Fwww.champman0102.co.uk%2Fforum%2Finstall%2Fupgrade_302.php%3Frand%3D1234356206"]http://www.champman0102.co.uk/forum/install/upgrade_302.php?rand=1234356206[/URL]
IP Address : xxx.x.xxx.xxx
Username : 
Classname : vb_database
MySQL Version : 5.0.67-community

I am very confused, this is the first time I have attempted an upgrade and I had ensured I did everything according to the book.

Regards
Mark

[Sully90]

What version are you upgrading from?

[markhendo1986]

I can't remember now! The home page of the forum is inaccessible as well now so I can't verify which version it was. I'm sure it was 2.9.1 or something similar though...

[Sully90]

In the Members' Area, you will find specific instructions for upgrading from vBulletin 2.x to the latest versions. You need to run through each upgrade script.

[markhendo1986]

Whereabouts are these specific instructions? I've had a look and can't find any of them. Besides, I wouldn't know where to start as I can't remember the original version of vBulletin that I originally had?

[Sully90]

Go into the Members' Area and click "Download vBulletin" and just above the license agreement is a link to the upgrade instructions.

[markhendo1986]

Found it, thanks. I'm a little confused though because although there's a logn list of each vB version with upgrade php files. Where am I meant to download them from?

Am I supposed to download the full package for each version? Then go through each one starting from the earliest version I think I had and once that's done, run through the latest version upgrade again?

Sorry to appear rather clueless but as I said, I've not done any of this before.

[Sully90]

That's alright, mate - we've all been stuck at one point or another.

You don't need to download them. In your downloaded vBulletin package, go to your /install/ folder and you'll see the upgrade scripts in there. It's automatically included in the vBulletin package.

You need to run the upgrade scripts from your original (2.x) files. Then upload the new version of vBulletin, and run those upgrade scripts.

EDIT: If you don't have the original files anymore, you can download them from the bottom of the upgrade instructions page. The upgrade files are available in there.

[markhendo1986]

Ohhhh, I see now! Right then, I'll give it a go.

I'll report back later to let you know how I got in. Thanks again

[Sully90]

Not a problem, mate. Best of luck!