Database error in vBulletin 4.2.4:

[flox80]

We are getting a lot of error messages like the one below:


Database error in vBulletin 4.2.4:

Invalid SQL:

SELECT pmtextid, COUNT(pmtextid) AS total
FROM pm AS pm
WHERE pmid IN ()
GROUP BY pmtextid;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
GROUP BY pmtextid' at line 3
Error Number : 1064
Request Date : Tuesday, July 18th 2017 @ 04:45:01 AM
Error Date : Tuesday, July 18th 2017 @ 04:45:01 AM
Script : http://www.siteurl.com/private.php?d...&pmid=24060551
Referrer : https://www.siteurl.com/private.php?...&pmid=24060551
IP Address : 213.188.19.170
Username : Bjarte64
Classname : vB_Database_MySQLi
MySQL Version :

has anyone else encountered this? what is your opinion on why it happens?

any pointer about how to fix this is really welcomed.

Thanks.

[Wayne Luke]

What version of PHP are you using?

[flox80]

PHP Version 5.6.30-1~dotdeb+7.1

[Wayne Luke]

Hmmm... It is trying to delete a private message but there is no pmid value being transferred to the query. This typically is due to a variable that is out of scope and not processed properly. 4.2.4 should work with PHP 5.6. Do you have any addons installed that deal with Private Messages? It may need to be updated.