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)

gnrx 09-07-2018 08:37 AM

1 Attachment(s)
Ok, use the product I attach in this post.

mahimapu 09-07-2018 08:48 AM

Quote:

Originally Posted by gnrx (Post 2596266)
Ok, use the product I attach in this post.

@gnrx

It worked.. Thanks ! :up:

Pocket Aces 10-10-2018 04:04 AM

================================================== ===

Database error in vBulletin 4.2.5:

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

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY post_thanks.username ASC' at line 1
Error Number : 1064
Request Date : Wednesday, October 10th 2018 @ 05:35:23 AM
Error Date : Wednesday, October 10th 2018 @ 05:36:17 AM
Script : *removed*/user.php?do=dopruneusers
Referrer : *removed*/user.php?do=pruneusers
IP Address : *removed*
Username : *removed*
Classname : vB_Database_MySQLi
MySQL Version : 10.2.18-MariaDB
User Agent :

================================================== ===

Can't proceed with the pruning of members when post thanks is enabled. Disabling it via Manage Products page works so this mod is the one causing the database error.

How do we fix it?

gnrx 10-10-2018 03:36 PM

Pocket Aces; You fresh install post thanks in vb 4.2.5?

Pocket Aces 10-11-2018 05:10 AM

Nope. Been using it since its inception in vB4.

gnrx 10-11-2018 05:22 AM

And now you have this problem? You made some change like upgrade php or similar?

Pocket Aces 10-11-2018 03:15 PM

yep, new php is causing this, i'll just wait for someone who has similar experience and able to fix it

gnrx 10-11-2018 03:17 PM

You upgrade your php version of your hosting to php 7.0?

winky8300 10-23-2018 04:04 PM

Hello
how to reset all thanks for lightening the database
thank you in advance

x iJailBreak x 10-23-2018 05:09 PM

Quote:

Originally Posted by Pocket Aces (Post 2596699)
================================================== ===

Database error in vBulletin 4.2.5:

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

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY post_thanks.username ASC' at line 1
Error Number : 1064
Request Date : Wednesday, October 10th 2018 @ 05:35:23 AM
Error Date : Wednesday, October 10th 2018 @ 05:36:17 AM
Script : *removed*/user.php?do=dopruneusers
Referrer : *removed*/user.php?do=pruneusers
IP Address : *removed*
Username : *removed*
Classname : vB_Database_MySQLi
MySQL Version : 10.2.18-MariaDB
User Agent :

================================================== ===


Can't proceed with the pruning of members when post thanks is enabled. Disabling it via Manage Products page works so this mod is the one causing the database error.


How do we fix it?

Just tested this with the 7.88 version and it works fine for me on PHP 7.0 and 7.1, using vB 4.2.5 - what version of the plugin are you using?

snakes1100 11-05-2018 02:56 PM

Unless you apply this fix, it doesnt work on 7.1

https://vborg.vbsupport.ru/showpost....postcount=3671

Hilary 01-03-2019 04:33 PM

Editing to answer my own clueless question/s.

First, edit the xml file for version 7.88. Set the max version to 4.2.6.
Then install version 7.88.
Then visit forum/includes and upload the revised functions_post_thanks.php


Fixed!

Thank you, snakes1100 and everyone.

===========
original cluelessness:
===========


That would be exactly what I need, thank you (just upgraded php today).

Clueless Question Of The Day: what should I do with the functions_post_thanks.php file? (upload it somewhere? copy its contents somewhere?)

sansar50 01-16-2019 03:25 PM

Quote:

Originally Posted by Hilary (Post 2598006)
Editing to answer my own clueless question/s.

First, edit the xml file for version 7.88. Set the max version to 4.2.6.
Then install version 7.88.
Then visit forum/includes and upload the revised functions_post_thanks.php


Fixed!

Thank you, snakes1100 and everyone.

===========
original cluelessness:
===========


That would be exactly what I need, thank you (just upgraded php today).

Clueless Question Of The Day: what should I do with the functions_post_thanks.php file? (upload it somewhere? copy its contents somewhere?)

I'm using 4.2.5. It worked like you said. thank.

tbellik 02-17-2019 03:42 AM

Anyone here for help?

I have changed my theme and also hosting and users like all of them gone. I have old db and it is possible to recall them with insert ün phpmyadmin or something else?

Mark.B 02-17-2019 10:54 PM

What do you mean by 'all of them gone'?

If they physically no longer exist in the database, then when you moved to new hosting the database import was not done properly.

If they are there then it's probably your custom theme and you will need to reapply any changes so they appear in this theme.

tbellik 02-18-2019 05:11 PM

Quote:

Originally Posted by Mark.B (Post 2598527)
What do you mean by 'all of them gone'?

If they physically no longer exist in the database, then when you moved to new hosting the database import was not done properly.

If they are there then it's probably your custom theme and you will need to reapply any changes so they appear in this theme.

I think database import wasnt succesfull. Now in postbit like counter started like new but users experience is looking good, I just didnt see in postbit old likes count.

For example I was have 5000 like and was seeing in my postbit, but now all users including me deleted or not imported properly.

I have old SQL backup file, is it possible to import them or no ?

I also changed my theme maybe they disappear after changed theme, Im not sure.
I just want to bring back them.

gnrx 02-18-2019 05:46 PM

Quote:

Originally Posted by tbellik (Post 2598538)

I have old SQL backup file, is it possible to import them or no ?

If you have a old SQL backup, recreate this backup database (with other name) and export the tables of post thanks, then, delete this tables in your new database and import this tables.
Then, you have the values of post thanks of your SQL backup.

tbellik 02-24-2019 08:04 AM

Quote:

Originally Posted by gnrx (Post 2598540)
If you have a old SQL backup, recreate this backup database (with other name) and export the tables of post thanks, then, delete this tables in your new database and import this tables.
Then, you have the values of post thanks of your SQL backup.

It was just 5kb is it normal or no ?

I have a little bit care import for this post thanks table

gnrx 03-28-2019 06:00 PM

Quote:

Originally Posted by tbellik (Post 2598601)
It was just 5kb is it normal or no ?

I have a little bit care import for this post thanks table

Sorry for the delay in reply, left this message parked to answer it later and I completely missed it. Do you continue with the problem?

tehbasmentdwell 04-08-2019 03:25 PM

Hello there, been using this product on Vbulletin 4x for a number of years with no issues - recently however the thanks button does not function when using Tapatalk....... anyone had this issue or know of a fix? The button is still visible, it just nothing when you attempt to click it now.

Thanks in advance for any assistance :)

sufilala 04-09-2019 08:52 PM

Quote:

Originally Posted by Hilary (Post 2598006)

First, edit the xml file for version 7.88. Set the max version to 4.2.6.
Then install version 7.88.
Then visit forum/includes and upload the revised functions_post_thanks.php


Fixed!

Hey thanks all contributors for keeping this thing going x

Raptor 05-27-2019 02:29 AM

Unable to delete forums that have posts with thanks and not working correctly with PHP 7.1

1. Any version PHP: Unable to delete a forum or post that is linked to a "thanks". Throws up an SQL error. Have to disable the mod to delete any posts that have thanks.

2. PHP 7.1: Throws up an error when you click on thanks

Code:

[] operator not supported for strings on line 182 in /home/*****/forums/includes/functions_post_thanks.php
#0 /home/*****/forums/includes/functions_post_thanks.php(137): fetch_thanks('1180756', '', false)
#1 /home/*****/forums/post_thanks.php(64): thanked_already(Array)
#2 {main}


Fatal User Error: [] operator not supported for strings on line 182 in ..../includes/functions_post_thanks.php in ..../vb/vb.php on line 286
Trace Data:
#1 : vbstop() called in ..../includes/class_core.php on line 6089
#2 : vbulletin_error_handler() called in  on line
#3 : trigger_error() called in ..../vb/vb.php on line 286
#4 : vB::handleException() called in  on line

Var Type:
[ NULL ]

Var Data:
null


#1 still has the issue with PHP 7.0 (i've seen many others post about this - its a major issue that no one has attempted to fix). It seems to be linked to the option "Remove User's Thanks Count When Deleting Post" - when this is set to No then it deletes no problem.

#2 is fixed when revert back to PHP 7.0. We need to be on PHP 7.1

Thanks in advance.

Raptor 05-27-2019 02:40 AM

Quote:

Originally Posted by x iJailBreak x (Post 2596977)
Just tested this with the 7.88 version and it works fine for me on PHP 7.0 and 7.1, using vB 4.2.5 - what version of the plugin are you using?

7.88 has these errors. Whatever you tested wasn't the error we are reporting.

Honestly - you saying it works on PHP 7.1 just shows you're either lying or you don't know what you are doing. This issue is verified 100%.

Meister2017 05-28-2019 01:42 PM

functions_post_thanks.php

search:

Code:

            if (empty($postids))
            {
                $postids[] = $postid;
            }

replace with:
Code:

            if (empty($postids))
            {
    $postids = array();   
                $postids[] = $postid;     
            }

product-post_thanks-7.88.xml

Code:

<dependency dependencytype="vbulletin" minversion="4.2.0" maxversion="4.2.4" />
replace with:
Code:

<dependency dependencytype="vbulletin" minversion="4.2.0" maxversion="4.2.8" />

jonatanros 06-07-2019 10:18 PM

Quote:

Originally Posted by Flipfloptrader (Post 2586386)
I have no idea what I did different but I was having another attempt at this and that code worked and now I'm running PHP 7.1.

Many thanks.


I have attached the functions_post_thanks for anyone who may need it to get this mod working with 4.2.5 and PHP 7.

Thank you very much bro!.

tbellik 06-20-2019 02:04 PM

Quote:

Originally Posted by gnrx (Post 2598901)
Sorry for the delay in reply, left this message parked to answer it later and I completely missed it. Do you continue with the problem?

I still have this problem.

I have old db and is it possible to export all users like and import current system ?

ALl my users asking likes, I want to import it again, thanks for your advance.

gnrx 06-21-2019 09:19 PM

Quote:

Originally Posted by tbellik (Post 2599590)
I still have this problem.

I have old db and is it possible to export all users like and import current system ?

ALl my users asking likes, I want to import it again, thanks for your advance.

Yes, its possible if you have a old database backup before lost this likes.

Only you need export from old backup database and import in new database.

Regards.

tbellik 06-22-2019 02:27 AM

Quote:

Originally Posted by gnrx (Post 2599604)
Yes, its possible if you have a old database backup before lost this likes.

Only you need export from old backup database and import in new database.

Regards.

Which table I dont know for export and import

gnrx 06-24-2019 08:11 PM

Quote:

Originally Posted by tbellik (Post 2599606)
Which table I dont know for export and import

I reply your mp.

I don't remember exactly what tables, a lot time ago, I change this mod for other, but if I view the tables I remember what tables, its very easy.

Regards.

tbellik 06-25-2019 02:35 AM

Quote:

Originally Posted by gnrx (Post 2599618)
I reply your mp.

I don't remember exactly what tables, a lot time ago, I change this mod for other, but if I view the tables I remember what tables, its very easy.

Regards.

Is it possible to post_thanks ?

I have this table but I just think thats, When I import this table to my new DB,will it keep my new like record or, only old likes stay there ?

I mean I have 500 like last one month, 5000 like last 3 years, when I import it is it going to save all of them

gnrx 06-25-2019 09:16 AM

Quote:

Originally Posted by tbellik (Post 2599620)
Is it possible to post_thanks ?

I have this table but I just think thats, When I import this table to my new DB,will it keep my new like record or, only old likes stay there ?

I mean I have 500 like last one month, 5000 like last 3 years, when I import it is it going to save all of them

Yes, is this table "post_thanks".

When you import, I think deleted new thanks, only have the thanks you have in the table it does not increase, but it rewrites.

You do not lose anything doing the test if you previously make a backup of said table.

tbellik 06-25-2019 05:47 PM

Quote:

Originally Posted by gnrx (Post 2599621)
Yes, is this table "post_thanks".

When you import, I think deleted new thanks, only have the thanks you have in the table it does not increase, but it rewrites.

You do not lose anything doing the test if you previously make a backup of said table.

Now I have old thanks table and new tables, is it possible to combine them ?

like insert into ....... code should I use ?

gnrx 06-25-2019 05:55 PM

Quote:

Originally Posted by tbellik (Post 2599624)
Now I have old thanks table and new tables, is it possible to combine them ?

like insert into ....... code should I use ?

In this case, I don't know how combine / merge 2 tables for have all thanks.

I can made some tests, but I need the tables...but I'm not sure If I can set this.

exploringnh 07-17-2019 12:03 AM

There are 7 files. Do I need to download all of them to make it work? If not, which file do I need for VB4.2.2? Thank you.

matheus21 08-30-2019 10:59 PM

1 Attachment(s)
how i translate to my language ?

lange 08-31-2019 02:27 PM

Quote:

Originally Posted by matheus21 (Post 2600459)
how i translate to my language ?

I'm using the version 3.x of this mod but the answer is probably the same :

Languages & Phrases > Search in Phrases ...

matheus21 09-01-2019 11:07 PM

Quote:

Originally Posted by lange (Post 2600465)
I'm using the version 3.x of this mod but the answer is probably the same :

Languages & Phrases > Search in Phrases ...

I translate but has not changed in profile
Thanks giving
Thanks Received

lange 09-02-2019 03:03 AM

Sorry, I don't have these phrases on vB 3.8.11.

I have this:
https://vborg.vbsupport.ru/external/2019/09/1.jpg

https://vborg.vbsupport.ru/external/2019/09/2.jpg

https://vborg.vbsupport.ru/external/2019/09/4.jpg

matheus21 09-02-2019 10:52 AM

Quote:

Originally Posted by lange (Post 2600484)

see this translated but in the profile there is no change

https://vborg.vbsupport.ru/external/2019/09/2.png

lange 09-02-2019 11:14 AM

Try to find the variables in the templates, create new phrases and translate these phrases.

I don't use vB 4.x, I prefer to use version vB 3.x, easier to customize (with tables) for my needs.

@++


All times are GMT. The time now is 01:53 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.05019 seconds
  • Memory Usage 1,850KB
  • 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
  • (5)bbcode_code_printable
  • (21)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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