![]() |
1 Attachment(s)
Ok, use the product I attach in this post.
|
Quote:
It worked.. Thanks ! :up: |
================================================== ===
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? |
Pocket Aces; You fresh install post thanks in vb 4.2.5?
|
Nope. Been using it since its inception in vB4.
|
And now you have this problem? You made some change like upgrade php or similar?
|
yep, new php is causing this, i'll just wait for someone who has similar experience and able to fix it
|
You upgrade your php version of your hosting to php 7.0?
|
Hello
how to reset all thanks for lightening the database thank you in advance |
Quote:
|
Unless you apply this fix, it doesnt work on 7.1
https://vborg.vbsupport.ru/showpost....postcount=3671 |
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?) |
Quote:
|
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? |
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. |
Quote:
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. |
Quote:
Then, you have the values of post thanks of your SQL backup. |
Quote:
I have a little bit care import for this post thanks table |
Quote:
|
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 :) |
Quote:
|
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 #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. |
Quote:
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%. |
functions_post_thanks.php
search: Code:
if (empty($postids)) Code:
if (empty($postids)) Code:
<dependency dependencytype="vbulletin" minversion="4.2.0" maxversion="4.2.4" /> Code:
<dependency dependencytype="vbulletin" minversion="4.2.0" maxversion="4.2.8" /> |
Quote:
|
Quote:
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. |
Quote:
Only you need export from old backup database and import in new database. Regards. |
Quote:
|
Quote:
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. |
Quote:
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 |
Quote:
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. |
Quote:
like insert into ....... code should I use ? |
Quote:
I can made some tests, but I need the tables...but I'm not sure If I can set this. |
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.
|
1 Attachment(s)
how i translate to my language ?
|
Quote:
Languages & Phrases > Search in Phrases ... |
Quote:
Thanks giving Thanks Received |
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 |
Quote:
https://vborg.vbsupport.ru/external/2019/09/2.png |
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 | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|