User table in RC3 causing problems

[Bubble #5]

We just upgraded from RC2 to RC3. RC2 worked fine. NO modifications have been done to anything. RC2 was a fresh install. We're using the default style. After we upgraded to RC3 it seemed to run good for about an hour (which in hindsight seems weird) and then suddenly, on its own, it started giving us this database error:

Database error in vBulletin :

Invalid SQL:

		SELECT username, userid, birthday
		FROM vb35_user
		WHERE (birthday LIKE '09-10-%' OR birthday LIKE '09-11-%')
		AND usergroupid IN (0, 6, 7, 2, 5)
		AND showbirthday = 2
		AND lastactivity >= 1123780191;

MySQL Error  : Unknown column 'showbirthday' in 'where clause'
Error Number : 1054
Date         : Saturday, September 10th 2005 @ 01:09:51 PM

We have tried to delete the 'user' table and then inserting a known good 'user' table from a backup of RC2 into the database, but the same error popped up. It says 'unknown column' so maybe the problem is in another part of the database. What should we try to fix this?

[Steve Machol]

You either didn't run the upgrade.php script or you skipped a step. If you did run upgrade.php, try this query:

ALTER TABLE vb35_user ADD showbirthday SMALLINT UNSIGNED DEFAULT '2' NOT NULL;

[Bubble #5]

Thank you Steve, running that query fixed it. We're making a backup of the database now. Thank you