[daveaite]

Originally Posted by GamerPerfection

AARRRGGHHH!!! This is doing my head in!!!!

I uninstalled it to try 6.3, that installed then I uninstalled that a re-installed 7.3 only to get this database error when installing:



Database error in vBulletin 4.2.1:

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

MySQL Error : Duplicate column name 'ln_thanks_user_amount'
Error Number : 1060
Request Date : Tuesday, May 7th 2013 @ 09:33:02 PM
Error Date : Tuesday, May 7th 2013 @ 09:33:02 PM
Script : http://www.gamerperfection.com/admin...=productimport
Referrer : http://www.gamerperfection.com/admin...?do=productadd
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.1.68-cll

Simply remove these 4 lines from the .xml, then try to run the .xml again.

				$vbulletin->db->query_write("ALTER TABLE `". TABLE_PREFIX ."user` ADD `ln_thanks_user_amount` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL");
				$vbulletin->db->query_write("ALTER TABLE `". TABLE_PREFIX ."post` ADD `ln_thanks_amount` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL");
				$vbulletin->db->query_write("ALTER TABLE `". TABLE_PREFIX ."user` ADD `ln_thanks_thanked_posts` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL");
				$vbulletin->db->query_write("ALTER TABLE `". TABLE_PREFIX ."user` ADD `ln_thanks_thanked_times` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL");