vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=231666

mahimapu 06 Sep 2018 16:35

Not works with 4.2.5 .. hope someone update this one for latest version :)

gnrx 06 Sep 2018 16:43

What error you have? I have 4.2.5 and work fine.

mahimapu 07 Sep 2018 11:15

@gnrx
Thanks for ur reply.. it shows incompatible with 4.25 . SS Bellow

https://www.vbulletin.org/forum/external/2018/09/1.png

gnrx 07 Sep 2018 11:37

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

mahimapu 07 Sep 2018 11:48

Quote:

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

@gnrx

It worked.. Thanks ! :up:

Pocket Aces 10 Oct 2018 07:04

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

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 Oct 2018 18:36

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

Pocket Aces 11 Oct 2018 08:10

Nope. Been using it since its inception in vB4.

gnrx 11 Oct 2018 08:22

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

Pocket Aces 11 Oct 2018 18:15

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

gnrx 11 Oct 2018 18:17

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

winky8300 23 Oct 2018 19:04

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

x iJailBreak x 23 Oct 2018 20:09

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 05 Nov 2018 16:56

Unless you apply this fix, it doesnt work on 7.1

https://www.vbulletin.org/forum/show...postcount=3671


All times are GMT. The time now is 22:20.

Powered by vBulletin® Version 3.8.12
Copyright © 2018, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.