vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Show Thread Enhancements - [AJAX] Post Thank You Hack (https://vborg.vbsupport.ru/showthread.php?t=231666)

djbaxter 05-23-2010 09:14 PM

Quote:

Originally Posted by MikalMirkas (Post 2042366)
Is this supported on 4.0.3 PL1?

Is it supported on 4.03 PL1? No. That's why it says "Not Supported" up there at the top of the page in the first post.

Does it work on 4.03 PL1? Yes. It works even better if you apply a couple of tweaks mentioned in this thread.

Golzarion 05-24-2010 06:22 PM

Quote:

Originally Posted by cmeinck (Post 2039956)
I'm sure I'm not the only one, so would appreciate any help on how to prevent these database errors. As far as I can tell, there are no visible links to "find thanks".

Code:

Database error in vBulletin 4.0.3:

Invalid SQL:

            REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
            VALUES (0, '66.249.65.181', 1, 'manic', '', 'post.dateline', 'DESC', 0.12551, 1, '351328,351311,348467,348466,346458,346411,344262,342697,342689', 1274289300, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:118484;s:5:\"manic\";}s:6:\"forums\";i:0;s:7:\"options\";a:3:{s:11:\"starteronly\";i:0;s:11:\"childforums\";i:1;s:6:\"action\";s:7:\"process\";}}', 'cd78b1a0b7a48890db58b480739e121c');

MySQL Error  : Table 'my_forum.search' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, May 19th 2010 @ 12:15:00 PM
Error Date    : Wednesday, May 19th 2010 @ 12:15:01 PM
Script        : http://www.mysite.com/forum/post_thanks.php?do=findthanks_user_gave&u=118484
Referrer      :
IP Address    : 66.249.65.181
Username      : Unregistered
Classname    : vB_Database
MySQL Version :


The same problem .... I think it is a bug for this hack on vB 4.0.3 !

djbaxter 05-24-2010 06:36 PM

1 Attachment(s)
Quote:

Originally Posted by cmeinck (Post 2039956)
I'm sure I'm not the only one, so would appreciate any help on how to prevent these database errors. As far as I can tell, there are no visible links to "find thanks".

Code:

Database error in vBulletin 4.0.3:

Invalid SQL:

                        REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
                        VALUES (0, '66.249.65.181', 1, 'manic', '', 'post.dateline', 'DESC', 0.12551, 1, '351328,351311,348467,348466,346458,346411,344262,342697,342689', 1274289300, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:118484;s:5:\"manic\";}s:6:\"forums\";i:0;s:7:\"options\";a:3:{s:11:\"starteronly\";i:0;s:11:\"childforums\";i:1;s:6:\"action\";s:7:\"process\";}}', 'cd78b1a0b7a48890db58b480739e121c');

MySQL Error  : Table 'my_forum.search' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, May 19th 2010 @ 12:15:00 PM
Error Date    : Wednesday, May 19th 2010 @ 12:15:01 PM
Script        : http://www.mysite.com/forum/post_thanks.php?do=findthanks_user_gave&u=118484
Referrer      :
IP Address    : 66.249.65.181
Username      : Unregistered
Classname    : vB_Database
MySQL Version :


Quote:

Originally Posted by Golzarion (Post 2042787)
The same problem .... I think it is a bug for this hack on vB 4.0.3 !

This questioned has been asked and answered several times in this thread.

Quote:

Originally Posted by imagirlgeek (Post 1958396)
What I did to resolve this was to comment out these lines in post_thanks.php...

PHP Code:

$db->query_write("
   REPLACE INTO " 
TABLE_PREFIX "search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
   VALUES (" 
$vbulletin->userinfo['userid'] . ", '" $db->escape_string(IPADDRESS) . "', 1, '" $db->escape_string($user['username']) . "', '" $db->escape_string($forumchoice) . "', 'post.dateline', 'DESC', $searchtime, 1, '" $db->escape_string(implode(','$orderedids)) . "', " TIMENOW ", '" $db->escape_string(serialize($display)) . "', '" $db->escape_string($searchhash) . "')
  "
);
  
$searchid $db->insert_id();
 
  
$vbulletin->url 'search.php?' $vbulletin->session->vars['sessionurl'] . "searchid=$searchid";
  eval(
print_standard_redirect('search')); 

I found this query on lines 278 - 285, 413 - 420, and 527 - 534. I commented out all of them 3 days ago and haven't received this error and also haven't seen any adverse effects.

If you don't know how to do those edits, upload the attached corrected post_thanks.php file to the forum root and import the attached corrected product-post_thanks.xml file, making sure you select the "overwrite" option.

To fix the cosmetic (font size) errors, apply the fixes in post_thanks_7_82_improvements.zip, posted earlier in this thread bu attached here for convenience.

empty2002 05-25-2010 12:38 AM

Plz help me :(
https://vborg.vbsupport.ru/showpost....&postcount=900

djbaxter 05-25-2010 12:48 AM

Quote:

Originally Posted by empty2002 (Post 2041759)
hey, when I upgrade from 3.8.4 to 4.0.3, then I reinstall this MOD, but I have an error :-s
Code:

http://mydomain.com/forum/post_thanks.php?do=post_thanks_add&p=22591&securitytoken=1274514074-1434d6d6da7a61dbd3ee2a933f54435b1bdc3c5c
And I can't rebuilt quantity of thanks!!!
PLZ help me
thx :)

If you uninstalled this add-on, upgraded, and then reinstalled the vBulletin 4.x version, you probably will lose the previous "thanks" counts.

As for the error, exactly what does the error message say?

empty2002 05-26-2010 12:46 PM

eror 500

jacobomoya 05-27-2010 09:13 AM

Maybe the operation takes too long and your server timeouts?

kmohamed 05-27-2010 07:01 PM

is it possible to have a list with highest thanked threads
via admin panel
i am planing to use this thread for something else ?

Hippy 05-29-2010 11:31 AM

The problem I noticed was in IE7 or IE8 running in compatibility view.
In a private forum when a admin other than yourself was last to post.
the report icon would get pushed out of the comment area and push
the foot a full screen down where it would display that little report post icon..
I have had this mod install for many version and just noticed this debugging a different problem
the fix is as followed

in post_thanks_javascript template
this is the original code
PHP Code:

<script type="text/javascript" src="clientscript/post_thanks.js"></script>

<
style type="text/css">
.
postbitlegacy .postfoot .textcontrols a.post_thanks_button, .postbit .postfoot .textcontrols a.post_thanks_button  {
    
backgroundurl({vb:stylevar imgdir_button}/post_thanks.pngno-repeat transparent {vb:stylevar left};
    
padding-{vb:stylevar left}: 20px;
}
.
postbitlegacy .postfoot .textcontrols a.post_thanks_button:hover, .postbit .postfoot .textcontrols a.post_thanks_button:hover  {
    
backgroundurl({vb:stylevar imgdir_button}/post_thanks-hover.pngno-repeat transparent {vb:stylevar left};

</
style

I added a } at the end before /style

so it looks like this now
PHP Code:

<script type="text/javascript" src="clientscript/post_thanks.js"></script>

<
style type="text/css">
.
postbitlegacy .postfoot .textcontrols a.post_thanks_button, .postbit .postfoot .textcontrols a.post_thanks_button  {
    
backgroundurl({vb:stylevar imgdir_button}/post_thanks.pngno-repeat transparent {vb:stylevar left};
    
padding-{vb:stylevar left}: 20px;
}
.
postbitlegacy .postfoot .textcontrols a.post_thanks_button:hover, .postbit .postfoot .textcontrols a.post_thanks_button:hover  {
    
backgroundurl({vb:stylevar imgdir_button}/post_thanks-hover.pngno-repeat transparent {vb:stylevar left};
}
</
style

hope it helps someone out

sebaldus 05-30-2010 02:02 AM

Hi.

I have installed both This hack, Ajax Advance Stats, and Ajax Chat Box.
Get this error code from my forums every day and two -five times each day, now..:(

Code:

Database error in vBulletin 4.0.2:

Invalid SQL:

              SELECT
                      userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
                      IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
                      language.phrasegroup_global AS phrasegroup_global,
                      language.phrasegroup_posting AS phrasegroup_posting,
                      language.phrasegroup_search AS phrasegroup_search,
                      language.phrasegroup_socialgroups AS phrasegroup_socialgroups,
                      language.options AS lang_options,
                      language.languagecode AS lang_code,
                      language.charset AS lang_charset,
                      language.locale AS lang_locale,
                      language.imagesoverride AS lang_imagesoverride,
                      language.dateoverride AS lang_dateoverride,
                      language.timeoverride AS lang_timeoverride,
                      language.registereddateoverride AS lang_registereddateoverride,
                      language.calformat1override AS lang_calformat1override,
                      language.calformat2override AS lang_calformat2override,
                      language.logdateoverride AS lang_logdateoverride,
                      language.decimalsep AS lang_decimalsep,
                      language.thousandsep AS lang_thousandsep

              FROM vb_user AS user
              LEFT JOIN vb_userfield AS userfield ON (user.userid = userfield.userid)
              LEFT JOIN vb_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN vb_language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

              WHERE user.userid = 5;

MySQL Error  : MySQL server has gone away
Error Number  : 2006
Request Date  : Saturday, May 29th 2010 @ 09:38:29 PM
Error Date    : Saturday, May 29th 2010 @ 11:38:31 PM
Script        : http://www.sebaldus.no/ajax.php
Referrer      : http://www.sebaldus.no/forum.php
IP Address    : 85.164.231.112
Username      :
Classname    : vB_Database
MySQL Version :

Do you know what this is?

How I can correct it?
[Script : http://www.sebaldus.no/ajax.php]

Have try to close one and one of those hack, but cant find out what it crash with?
Thanks in Advance.
Regards from Sebaldus:rolleyes:


All times are GMT. The time now is 12:24 AM.

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.32065 seconds
  • Memory Usage 1,823KB
  • 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
  • (4)bbcode_code_printable
  • (3)bbcode_php_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)pagenav_pagelinkrel
  • (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