vb.org Archive
Page 6 of 14 « First 45 6 78 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Show Thread Enhancements - [AJAX] Post Groan Hack (https://vborg.vbsupport.ru/showthread.php?t=193489)

Leo Brazil 11-07-2008 12:21 PM
Quote:
Originally Posted by Leo Brazil (Post 1658462)
Database error in vBulletin 3.7.3:

Invalid SQL:

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 :
Just some more details I've notice, may be to help you out to find a fix for this.

I get this error only when Googlebots are cheking users profiles as I have enabled "show stats at profile".

I've noticed visitor can have an answer if they try to use "Find All Posts Groaned by" the answer for the search is always "Sorry, no matches were found" but as a regular visitor despite of the getting any results I don't have the same MySQL error. If I just log in I can get results using the same script. So far so good because I believe visitors don't need such info.
Why am I getting this error only with Googlebots ?

Tks.

albibak 11-07-2008 05:57 PM
1 Attachment(s)
You can find the french translation here for the version 4.1 and in attachement (with the french button).

Abe1 11-12-2008 01:43 AM
Quote:
Originally Posted by Leo Brazil (Post 1658462)
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.

Abe1 11-12-2008 01:44 AM
Quote:
Originally Posted by albibak (Post 1659209)
Thanks Abe1 for this hack :)
Is it possible to have the psd button?
Sorry, I dont have one.

bigtime 11-12-2008 03:49 AM
Quote:
Originally Posted by Leo Brazil (Post 1658462)
Abe,


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 Version :
Upgrade or do the following:

https://vborg.vbsupport.ru/showpost....6&postcount=24

Leo Brazil 11-12-2008 11:41 AM
Quote:
Originally Posted by Abe1 (Post 1663952)
Upload the latest files. This bug was fixed already.
Quote:
Originally Posted by bigtime (Post 1664001)
Thanks guys. In fact I was using the current version but the dumb one here forgot to upgrade one file... :eek:
Never happended this to me before....

Dragonsys 11-15-2008 05:06 PM
can this be integrated with vBExperience, like the Post Thank You is?
So any posts with groans, would lose vBExperience points.

Blumy 11-19-2008 02:09 AM
Is there any way to change the name from Groan to something else? For some reason my users really like shenanigans...could i make it display as shenanigans in the postbit?

vktechnology 11-23-2008 12:48 AM
for my website i rename as DISAGREE button instead of goan button

vktechnology 11-23-2008 12:51 AM
How can i place this goan button manully ?
i wan tto change possition.

I donlt want to palce near by thank button it easy to make mebers to press wrong button..


All times are GMT. The time now is 01:14 PM.
Page 6 of 14 « First 45 6 78 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01132 seconds
  • Memory Usage 1,750KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete