Error trying to find user

[TheComputerGuy]

I get this error when I am searching for any user...

Database error in vBulletin 3.0.0 Release Candidate 2:

Invalid SQL: SELECT profilefieldid,type,data,optional FROM profilefield
mysql error: Unknown column 'data' in 'field list'

mysql error number: 1054

Date: Tuesday 20th of January 2004 07:27:39 PM
Script: [url="http://www.runaked.com/forums/admincp/user.php"]http://www.runaked.com/forums/admincp/user.php[/url]
Referer: [url="http://www.runaked.com/forums/admincp/user.php?do=modify"]http://www.runaked.com/forums/admincp/user.php?do=modify[/url] 

Not sure how I can fix this, I just upgraded from 2.3.2.

[Steve Machol]

You missed a step somewhere in the upgrade process. Do you recall which upgrade scripts ran and did you get any error messages during the upgrade?

[TheComputerGuy]

number 19 out of 42...something about session...

[TheComputerGuy]

Database error in vBulletin 3.0.0 Release Candidate 2:

Invalid SQL: ALTER TABLE session
   CHANGE host host CHAR(15) NOT NULL,
   ADD badlocation SMALLINT UNSIGNED NOT NULL
   
mysql error: Duplicate column name 'badlocation'

mysql error number: 1060 

[Steve Machol]

So what did you do when you got this error? This should only appear if you've already run the upgrade script before.

[TheComputerGuy]

Well I changed the number from being 19 to 20. Never ran the upgrade script before actually.

[TheComputerGuy]

I went through the upgrade script, and manually ran each query.

It took time, but it works fine now!

Thanks steve!