Originally Posted by gnrx (Post 2596266)

Ok, use the product I attach in this post.

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?