[vulture]

Version 5.3 uses exactly the same database tables. To fix the error change to the following in products-post_thanks.xml

<installcode><![CDATA[$db->query_write("CREATE TABLE IF NOT EXISTS`". TABLE_PREFIX ."post_thanks` (

    `id` INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,

    `userid` INT(10) NOT NULL,

    `username` VARCHAR(50) NOT NULL,

    `date` INT(10) NOT NULL,

    `postid` INT(10) NOT NULL)

    ");
]]></installcode>

This is the original error:

Originally Posted by vulture

Getting the following error when upgrading from 5.3

Database error in vBulletin 4.0.0:

Invalid SQL:
ALTER TABLE `user` ADD `post_thanks_user_amount` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error   : Duplicate column name 'post_thanks_user_amount'
Error Number  : 1060
Classname     : vB_Database
MySQL Version : 5.0.41-community

Edit: v5.3 is disabled when I do the upgrade