Error Upgrade 3.7

[Mr.Fidel]

Database error in vBulletin 3.7.0 Beta 2:

Invalid SQL:
ALTER TABLE dqd_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 'dqd_album'
Error Number : 1054
Request Date : Wednesday, April 30th 2008 @ 07:03:39 PM
Error Date : Wednesday, April 30th 2008 @ 07:03:39 PM
Script : http://duongquangdong.net/f@rum/install/upgrade_370b3.php?step=2
Referrer :
IP Address : 203.162.3.154
Username :
Classname : vB_Database
MySQL Version : 5.0.51a-community


So, How I do that ?

[Marco van Herwaarden]

From which version are you trying to upgrade? Also are you trying to upgrade to 3.7 'Gold'?

[Marco van Herwaarden]

If you are upgrading from 3.6, have previously tested a 3.7 version in this same database and after this restored the 3.6 database without first deleting all tables and then try to upgrade, then this can also happen. See bug report: http://www.vbulletin.com/forum/project.php?issueid=25167