Upgrade to 3.5.4

[xRoyal15]

Just upgraded... well tried and got this message:

Database error in vBulletin 3.5.3:

Invalid SQL:
ALTER TABLE subscribethread ADD canview SMALLINT UNSIGNED NOT NULL DEFAULT 1;

MySQL Error : Duplicate column name 'canview'
Error Number : 1060
Date : Thursday, April 20th 2006 @ 06:42:49 PM
Script : http://www.ourhabboforum.be/install/...354.php?step=1
Referrer : http://www.ourhabboforum.be/install/...4.php?rand=452
IP Address : 82.34.123.112
Username :
Classname : vb_database

anyone know the query to run to solve it??

[Re101]

COntact vb