vb.org Archive
Page 237 of 240 « First 137187227235236 237 238239 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 Thank You Hack (https://vborg.vbsupport.ru/showthread.php?t=165673)

Manipulation 04-01-2017 03:27 PM
Bump, does anybody have a solution to the page freezing when I upload the plug in?

Manipulation 04-08-2017 01:58 AM
Can I get some assistance with this? Anybody?

Don Z. 05-21-2017 12:03 PM
I'll bump this since I'm having the exact same problem. After upgrading to vB 3.8.11 pages just freeze when Post Thank You Hack 7.7 is enabled.

Does anyone know how to get this working again? I have thousands of "Thanks" I don't want to lose.

vbem2 05-23-2017 06:11 PM
Quote:
Originally Posted by blind-eddie (Post 2583617)
Would have a better idea if you were to post your database error in [CODE] brackets.
Also just upgraded to 3.8.11 and am getting errors on showthread.php when the Thanks plugin is enabled.

Seems to be related to an array variable that doesn't exist after the upgrade.

Code:
Database error in vBulletin 3.8.11:

Invalid SQL:
SELECT * FROM post_thanks AS post_thanks INNER JOIN user AS user USING (userid) WHERE post_thanks.postid IN (0Array) ORDER BY post_thanks.username ASC;

MySQL Error  : Unknown column '0Array' in 'where clause'
Error Number  : 1054
Request Date  : Tuesday, May 23rd 2017 @ 03:57:59 PM
Error Date    : Tuesday, May 23rd 2017 @ 03:57:59 PM
Script        : ....../forum/showthread.php?t=33292
Classname    : vB_Database_MySQLi
MySQL Version : 5.5.54-0+deb8u1

treki 05-24-2017 06:41 PM
Same problem. After upgrading to 3.8.11:

Code:
Invalid SQL:
SELECT * FROM vb_post_thanks AS post_thanks INNER JOIN vb_user AS user USING (userid) WHERE post_thanks.postid IN (0Array) ORDER BY post_thanks.username ASC;

MySQL Error  : Unknown column '0Array' in 'where clause'
Error Number  : 1054
Any ideas/solutions?

cassedy 05-26-2017 12:57 PM
same error here after upgrade to 3.8.11.

any idea?

vbem2 05-26-2017 03:58 PM
Making the following changes caused the Post Thanks hack to start working again on my 3.8.11 installation. Note: I haven't tested extensively beyond seeing that I could give thanks and delete it from one other member's post.

GIANT DISCLAIMER: I am not an expert coder. I occasionally muck around in PHP and sometimes understand what I'm doing.

Apply this fix AT YOUR OWN RISK. I can't help if it doesn't work for you.

The changes below refer to Post Thank You Hack version 7.6 only.

1) Back up a copy of your original 7.6 file in /forum/includes/functions_post_thanks.php in case this gets all screwed up.

2) Open the file in your favourite editor.

3) Starting at line 178, replace this...

Code:
                if ($postids)
                {
                        $post_ids = "0$postids";
                }
                else
                {
                        $post_ids = $postid;
                }
... with this:

Code:
                if (empty($postids))
                {
                        $postids[] = $postid;
                }
4) A few lines below that (originally at line 189, but moved down due to the changes above), replace the this line ...

Code:
                        $thanks = $vbulletin->db->query_read("SELECT * FROM " .TABLE_PREFIX. "post_thanks AS post_thanks INNER JOIN " .TABLE_PREFIX. "user AS user USING (userid) WHERE post_thanks.postid IN (" . $post_ids . ") ORDER BY post_thanks.username ASC");
... with this:

Code:
                        $thanks = $vbulletin->db->query_read("SELECT * FROM " .TABLE_PREFIX. "post_thanks AS post_thanks INNER JOIN " .TABLE_PREFIX. "user AS user USING (userid) WHERE post_thanks.postid IN (" . implode(',', $postids) . ") ORDER BY post_thanks.username ASC");
5) A few lines below that (originally at line 193, but since moved further down due to the changes above), replace the this line ...

Code:
                        $thanks = $vbulletin->db->query_read("SELECT * FROM " .TABLE_PREFIX. "post_thanks WHERE postid IN (" . $post_ids . ") ORDER BY username ASC");
... with this:

Code:
                        $thanks = $vbulletin->db->query_read("SELECT * FROM " .TABLE_PREFIX. "post_thanks WHERE postid IN (" . implode(',', $postids) . ") ORDER BY username ASC");
6) Save & upload the file to /forum/includes.

Maybe it'll work for you too. Good luck!

cassedy 05-26-2017 04:30 PM
Quote:
Originally Posted by vbem2 (Post 2586995)
Making the following changes caused the Post Thanks hack to start working again on my 3.8.11 installation. Note: I haven't tested extensively beyond seeing that I could give thanks and delete it from one other member's post.

GIANT DISCLAIMER: I am not an expert coder. I occasionally muck around in PHP and sometimes understand what I'm doing.

Apply this fix AT YOUR OWN RISK. I can't help if it doesn't work for you.

The changes below refer to Post Thank You Hack version 7.6 only.

1) Back up a copy of your original 7.6 file in /forum/includes/functions_post_thanks.php in case this gets all screwed up.

2) Open the file in your favourite editor.

3) Starting at line 178, replace this...

Code:
                if ($postids)
                {
                        $post_ids = "0$postids";
                }
                else
                {
                        $post_ids = $postid;
                }
... with this:

Code:
                if (empty($postids))
                {
                        $postids[] = $postid;
                }
4) A few lines below that (originally at line 189, but moved down due to the changes above), replace the this line ...

Code:
                        $thanks = $vbulletin->db->query_read("SELECT * FROM " .TABLE_PREFIX. "post_thanks AS post_thanks INNER JOIN " .TABLE_PREFIX. "user AS user USING (userid) WHERE post_thanks.postid IN (" . $post_ids . ") ORDER BY post_thanks.username ASC");
... with this:

Code:
                        $thanks = $vbulletin->db->query_read("SELECT * FROM " .TABLE_PREFIX. "post_thanks AS post_thanks INNER JOIN " .TABLE_PREFIX. "user AS user USING (userid) WHERE post_thanks.postid IN (" . implode(',', $postids) . ") ORDER BY post_thanks.username ASC");
5) A few lines below that (originally at line 193, but since moved further down due to the changes above), replace the this line ...

Code:
                        $thanks = $vbulletin->db->query_read("SELECT * FROM " .TABLE_PREFIX. "post_thanks WHERE postid IN (" . $post_ids . ") ORDER BY username ASC");
... with this:

Code:
                        $thanks = $vbulletin->db->query_read("SELECT * FROM " .TABLE_PREFIX. "post_thanks WHERE postid IN (" . implode(',', $postids) . ") ORDER BY username ASC");
6) Save & upload the file to /forum/includes.

Maybe it'll work for you too. Good luck!
genius! it works.. thanks a lot..:)

treki 05-26-2017 06:42 PM
YEEEES!!!! Genius. 7.7 work fine under vB3.8.11

Silvio 07-05-2017 07:28 AM
@vbem2 thank you! It fixed to me too! great work.


All times are GMT. The time now is 08:37 AM.
Page 237 of 240 « First 137187227235236 237 238239 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.04113 seconds
  • Memory Usage 1,769KB
  • 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
  • (14)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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