Thread: Show Thread Enhancements - [AJAX] Post Thank You Hack
View Single Post
  #169  
Old 12-31-2009, 06:50 PM
vulture vulture is offline
 
Join Date: Mar 2005
Posts: 54
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02659 seconds
  • Memory Usage 1,765KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete