Thread: Show Thread Enhancements - [AJAX] Post Thank You Hack
View Single Post
  #168  
Old 31 Dec 2009, 19:50
vulture vulture is offline
 
Join Date: Mar 2005
Originally Posted by garretbyrne View Post
I've tried to install but came across an issue.. I had this mod back in 3.8.4 and my members love it was being well used.. but had to uninstall all the mods because of an issue upgrading to 4 (I'm aware I might have lost previous thanks count) but now when I install I get an SQL error..

------------------
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
Request Date : Thursday, December 31st 2009 @ 06:06:50 PM
Error Date : Thursday, December 31st 2009 @ 06:06:51 PM
Script : http://www.irishparanormal.org/admin...=productimport
Referrer : http://www.irishparanormal.org/admin...?do=productadd
IP Address : 79.97.12.86
Username : Garret
Classname : vB_Database
MySQL Version : 5.0.85-community
------------------

Is there any ideas on how to fix this?? Because I really like this thanks..
See my post. The install script is coded incorrectly are far as I'm concerned as it doesn't take into account if you are doing an upgrade.

Edit: as you uninstalled, you should really check if all the alterations made by the script are in you db. If not, you need to change the install accordingly.
Reply With Quote