Error Upgrading from 3.8.2 to RC1

[Rebecca217]

I'm trying to upgrade from 3.8.2 to RC1 using upgrade.php. When I get to upgrade_370b3.php?step=2, I get the following error (below). I've tried it several times, and always get the same result.

Any help is appreciated.




Step 2) Altering Table Defaults


Altering socialgrouppicture Table (1 of 1)
Altering notice Table (1 of 1)
Altering noticecriteria Table (1 of 1)
Altering tag Table (1 of 1)
Altering tagthread Table (1 of 1)
Altering tagsearch Table (1 of 1)
Altering postedithistory Table (1 of 1)
Altering usercsscache Table (1 of 1)
Altering visitormessage Table (1 of 1)
Altering groupmessage Table (1 of 1)
Altering album Table (1 of 1)

-------

Database error in vBulletin 3.7.0 Beta 2:

Invalid SQL:
ALTER TABLE album
CHANGE userid userid INT UNSIGNED NOT NULL DEFAULT '0',
CHANGE createdate createdate INT UNSIGNED NOT NULL DEFAULT '0',
CHANGE lastpicturedate lastpicturedate INT UNSIGNED NOT NULL DEFAULT '0',
CHANGE picturecount picturecount INT UNSIGNED NOT NULL DEFAULT '0',
CHANGE title title VARCHAR(100) NOT NULL DEFAULT '',
CHANGE description description TEXT,
CHANGE coverpictureid coverpictureid INT UNSIGNED NOT NULL DEFAULT '0';

MySQL Error : Unknown column 'picturecount' in 'album'
Error Number : 1054
Date : Saturday, March 22nd 2008 @ 09:30:29 PM
Script : http://mydomain.com/forums/install/upgrade_370b3.php?step=2
Referrer : http://mydomain.com/forums/install/upgrade_370b3.php?step=1
IP Address : **********
Username :
Classname : vb_database
MySQL Version : 5.0.45-community

[syrus.xl]

What vBulletin version are you upgrading from? You stated 3.8.2 - but this does not exist yet.

Are you referring to 3.6.8 PL 2?

[Rebecca217]

Yes, I am. Clumsy fingers! Sorry for the confusion! :o 3.6.8 PL 2 it is.

[extremesanity]

I am having this same problem. I submitted a bug in the bug tracker, no response yet though. I really wanted to play with RC 1. :(

[extremesanity]

What mods are you running on your board?

FYI, bug I submitted:
http://www.vbulletin.com/forum/project.php?issueid=24991

[Rebecca217]

Thanks for the link. :) I'm running a few mods, including VBA and VBA Links, and the Geek article system. All work exclusively on plugins, no file edits. After I received this error on upgrade the first couple times, I restored a backup of my database and tried again with all plugins disabled. Same error.

Mike just responded to the bug tracker thread, and I think he correctly identified the issue. I went into my database and noticed the "album" table already exists. We may have to manually compare the database structure for both versions and drop any extra tables. I'll work on this, and post instructions (on how to fix it) if I'm successful.

Rebecca

[extremesanity]

That is strange, I restore the database to my 3.6.8 backup and before I do the upgrade I don't notice the albums table already exists.

I will take another look.

[extremesanity]

I found out my problem is my own fault. Some how I introduced the wrong database structure into the upgrade process. I am still scratching my head trying to figure out how I did it though. I am being extra thorough now, dropping the entire database before I restore it so I don't make the same mistake twice.

So far the upgrade looks like it worked perfectly.