Thread: Show Thread Enhancements - [AJAX] Post Groan Hack
View Single Post
  #54  
Old 11-12-2008, 01:43 AM
Abe1's Avatar
Abe1 Abe1 is offline
 
Join Date: Feb 2004
Location: I LOVE New York!
Posts: 2,886
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Leo Brazil View Post
Abe,

It works really great on my board, thank you for that. But there's something I'm getting here that I'd like you to take a look into.

I'm getting a Database error like below. I'm used Groan Hack combined with Post Thanks and I notice this error only with Googlebots. See the IP ? All of them belongs to Google bots.

Any idea why ?

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT post_groan.postid AS postid
FROM vbpost_groan AS post_groan
LEFT JOIN vbpost AS post USING (postid)
INNER JOIN vbthread AS thread ON(thread.threadid = post.threadid)
WHERE post_thanks.userid = 207
AND thread.forumid
IN(6,7,127,8,10,9,11,78,119,118,79,122,120,121,123 ,16,22,35,36,37,38,39,40,30,41,42,43,44,45,46,
47,48,49,124,31,18,34,26,28,27,24,25,29,23,32,116, 33,17,54,53,57,56,55,51,50,52,58,12,80,81,76,77,
14,15,112,13,75,59,99,100,101,60,71,72,73,74,61,67 ,68,70,69,63,94,95,64,66,117,125,65,62,82,88,89,
90,91,83,92,93,84,102,103,85,104,105,106,107,113,1 14,115,86,108,109,87,110,111,96,97,98)
ORDER BY post.dateline DESC
LIMIT 1000;

MySQL Error : Unknown column 'post_thanks.userid' in 'where clause'
Error Number : 1054
Request Date : Saturday, November 1st 2008 @ 07:06:23 PM
Error Date : Saturday, November 1st 2008 @ 07:06:23 PM
Script :
http://www.mysite.com/forums/post_gr...ser_gave&u=207
Referrer :
IP Address : 66.249.71.230
Username : Not Registred
Classname : vB_Database
MySQL Version :
Upload the latest files. This bug was fixed already.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01151 seconds
  • Memory Usage 1,769KB
  • 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