[SirFlash]

I installed this on vb3.6.4, made the template change included in the file, and it didn't work. The script appears in place, but when i enter a keyword on the pm search form, it returns an SQL error page with this message:

Database error in vBulletin 3.6.4:

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=1
AND pm.folderid= AND MATCH(pmtext.title) AGAINST ('+testkeyword' 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) AGAINST ('+testkeyword' IN BOOLEAN MODE)
ORDER BY pmtext.d' at line 7
Error Number : 1064
Date : Thursday, June 28th 2007 @ 10:48:04 PM
Script : http://mywebsite.com/private.php?folderid=0
Referrer : http://mywebsite.com/private.php
IP Address : 192.168.1.1
Username : SirFlash
Classname : vB_Database_MySQLi

I thought maybe changing a line of code as Thaliada suggested may work, but i still get an error. The code below didn't fix the problem for me.

change <div><input type="text" class="bginput" name="query" size="35" value="$query" style="width:250px" />

to

<div><input type="text" class="bginput" name="query" size="35" value="" style="width:250px" />

I don't know if this has something to do with a conflict in value="$query" or what.

So for now i can't use this mod because it won't work, although the PM search is an excellent tool and i concur with others that this should absolutely be vb default in future versions. If anyone has any ideas on what i can do to get this to work, that would be much appreciated.