Thread: Show Thread Enhancements - [AJAX] Post Thank You Hack
View Single Post
  #104  
Old 08-19-2006, 09:23 PM
acco acco is offline
 
Join Date: Nov 2005
Posts: 41
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

A little curious, upgraded vbulletin 3.5.4 to 3.6 gold.
Updated thank you hack from Version 4.4 to latest v5.

Now in the forum if someone clicks the reputation icon first and then after the thanks button it will cause a db error.
Quote:
Database error in vBulletin 3.6.0:

Invalid SQL:

INSERT INTO reputation
(postid, userid, reputation, whoadded, reason, dateline)
VALUES ('18168', '5', '10', '7', 'Thanked Post', 1156020852);

MySQL Error : Duplicate entry '7-18168' for key 2 Error Number : 1062
Date : Saturday, August 19th 2006 @ 04:54:12 PM
Script : http://www.xxx.co.uk/test/forum/show...d_ajax&p=18168
Referrer :
IP Address : xx.x.193.174
Username : tester
Classname : vb_database
Does this mean users can only choose 1 or the outher?
A little confused as I don?t recall having this problem prior to upgrade.
Also wasn?t there some update counter buttons for thanks in acp, I don?t seem to have them now if their was?

Any pointers?
Acco.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02313 seconds
  • Memory Usage 1,764KB
  • 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