[Silviu]

Installed the mod and love it, but some of our users recently started reporting that both Search functions are inoperable. If they try to use them, they get the following errors:

Search by Username:

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM pm AS pm
LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=4877
AND pm.folderid= AND fromuserid IN (618, 17103, 17921, 29550, 31022, 31200, 37237, 43083, 56188, 59939, 61094, 64280, 73683, 87463, 95220)
ORDER BY pmtext.dateline DESC;

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 'AND fromuserid IN (618, 17103, 17921, 29550, 31022, 31200, 37237, 43083, 56188, ' at line 7
Error Number : 1064
Date : Friday, October 12th 2007 @ 12:19:38 PM
Script : http://forum.computergames.ro/private.php?folderid=0
Referrer : http://forum.computergames.ro/private.php
IP Address : 193.111.120.28
Username : Bossman
Classname : vB_Database_MySQLi

Normal search:

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM pm AS pm
LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=4877
AND pm.folderid= AND MATCH(pmtext.title, pmtext.message) AGAINST ('+moderator' IN BOOLEAN MODE)
ORDER BY pmtext.dateline DESC;

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 'AND MATCH(pmtext.title, pmtext.message) AGAINST ('+moderator' IN BOOLEAN MODE)
' at line 7
Error Number : 1064
Date : Friday, October 12th 2007 @ 12:22:57 PM
Script : http://forum.computergames.ro/private.php?folderid=0
Referrer : http://forum.computergames.ro/private.php
IP Address : 193.111.120.28
Username : Bossman
Classname : vB_Database_MySQLi

Any ideas why this is happening?

From what I can tell, there seems to be a problem with the pm.folderid= bit in the query