weird upgrade error - says i am not running the version i uploaded

[jilly]

I am trying to upload from 3.5.4 to 3.7 - I uploaded all the 3.7 files, and tried to enter the upgrade, system, and got this error message

Your vBulletin (3.5.4) does not appear to be running the version that was downloaded (3.7.0).
This generally means your upgrade was not successful. Please ensure that you have uploaded the latest files and click here (http://www.passboards.org/install/upgrade.php) to try again.
If you are sure you wish to continue with this part of the upgrade, click here (http://www.passboards.org/install/finalupgrade.php?step=1).

This is when I was on the very first step of upgrading, right after entering the member number!

[jilly]

okay, i reuploaded the install folder and now it's going a little better - the upgrade has started

[Nick]

Maybe that means none of the 3.7 files actually overwrote the original files you had.
Be sure that they are.

[Jose Amaral Rego]

Run this to determine if files have been overwritten and you might see modification files, but those you will know what they are for.
Admin Control Panel > Maintenance > Diagnostics > Suspect File Versions

[jilly]

I can't get admincp to load now. I tried re-uploading all the files, checked and made sure the date showed today, and going back to the upgrade script - it's still giving me the same error - now it says

Your vBulletin version does not appear to match with the version for which this script was created (version 3.5.4+).
Please ensure that you are attempting to run the correct script.
If you are sure this is the script you would like to run, click here (http://www.passboards.org/install/upgrade_360b1.php?step=1).

[jilly]

maybe i should download an older version first, and try to upgrade to like 3.6 first??

[Steve Machol]

You did make a backup of this database first, right? If so at this point, click on the 'click here' to continue.

[jilly]

You did make a backup of this database first, right? If so at this point, click on the 'click here' to continue.
oh yes, I did make a backup :)

I clicked on the 'click here to continue' anyway script, but it seems to freeze on the first step, which is 'large table alterations' -with this url
upgrade_360b1.php?step=1 (http://www.passboards.org/install/upgrade_360b1.php?step=1)

[Steve Machol]

That step may take a while depending on the size of your database.

[jilly]

my database is pretty big - when you say ' a while', how long would that be? i can't get to admincp anymore, but it'sd got about 20,000 - 30,000 members and getting close to 2 million posts..

[Steve Machol]

It's hard to say. It could be an hour or more.

[jilly]

It's hard to say. It could be an hour or more.

okay thanks - i will let it run and see what happens... i think my server froze in the meantime - trying to get that rebooted.. Steve, I'll send you some coffee, stay up late with me tonight until it's done!!

[jilly]

okay, now on step 2 large table alterations, i got this error

Database error in vBulletin :
Invalid SQL:
ALTER TABLE post
ADD reportthreadid INT UNSIGNED NOT NULL DEFAULT 0;
MySQL Error : Duplicate column name 'reportthreadid'
Error Number : -1
Request Date : Friday, May 2nd 2008 @ 11:17:20 PM
Error Date : Friday, May 2nd 2008 @ 11:19:21 PM
Script : http://www.passboards.org/install/upgrade_360b1.php?step=2
Referrer : http://www.passboards.org/install/upgrade_360b1.php?step=1
IP Address : 71.206.17.116
Username :
Classname : vb_database
MySQL Version :

[jilly]

ok, i hit refresh several times, and it is now proceeding