I've just tried upgrading my forum to 3.8.4. I had this installed already (v1.0.1) and I get a DB error about a duplicate column.
Code:
Database error in vBulletin 3.8.4:
Invalid SQL:
ALTER TABLE vb3_thread
ADD sticky_order SMALLINT( 5 ) UNSIGNED DEFAULT '5' NOT NULL AFTER sticky,
ADD sticky_expiry INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL AFTER sticky_order;
MySQL Error : Duplicate column name 'sticky_order'
Error Number : 1060
Request Date : Tuesday, September 8th 2009 @ 12:53:44 PM
Error Date : Tuesday, September 8th 2009 @ 12:53:44 PM
Script : http://www.puntosports.co.uk/forums/admincp/plugin.php?do=productimport
Referrer : http://www.puntosports.co.uk/forums/admincp/plugin.php?do=productadd
IP Address : 188.220.15.42
Username : Puntoboy
Classname : vB_Database
MySQL Version : 4.1.22-community-nt-log
How can I fix this without having to set up all my stickies again?