[Eric1776]

When trying to do a search I get this error.

Database error in vBulletin 3.0.5:

Invalid SQL: 
	SELECT DISTINCT vbug_severity.severityname, vbug_type.typename, vbug_version.versionname, vbug_status.statusname, vbugs.*, admin.username AS adminname, user.username, user.usertitle, lastreply.username AS lastreplyname 
	FROM vbugs
	LEFT JOIN vbug_status ON (vbugs.vbug_statusid = vbug_status.vbug_statusid)
	LEFT JOIN user AS admin ON (vbugs.adminid = admin.userid)
	LEFT JOIN user ON (vbugs.userid = user.userid)
	LEFT JOIN user AS lastreply ON (vbugs.lastreplyuid = lastreply.userid)
	LEFT JOIN vbug_type ON (vbugs.vbug_typeid = vbug_type.vbug_typeid)
	LEFT JOIN vbug_version ON (vbugs.vbug_versionid = vbug_version.vbug_versionid)
	LEFT JOIN vbug_severity ON (vbugs.vbug_severityid = vbug_severity.vbug_severityid)
	
	WHERE 1 AND MATCH (title, description) LIKE '%test%'  AND vbugs.vbug_typeid = '18' AND vbugs.vbug_statusid = '2'
	ORDER BY lastedit desc
	LIMIT 0, 20
	
mysql error: You have an error in your SQL syntax near 'LIKE '%test%'  AND vbugs.vbug_typeid = '18' AND vbugs.vbug_statusid = '2'
	ORDER' at line 12

mysql error number: 1064

Date: Friday 07th of January 2005 01:43:20 PM
Script: http://www.ezresources.net/forums/vbugs.php?do=list&s=&textsearch=test&vbug_typeid=18&vbug_statusid=2&vbug_severityid=0&vbug_versionid=0&assignment=0&sortfield=lastedit&sortorder=desc
Referer: http://www.ezresources.net/forums/vbugs.php?do=list&s=&textsearch=&vbug_typeid=18&vbug_statusid=2&vbug_severityid=0&vbug_versionid=0&assignment=0&sortfield=lastedit&sortorder=desc
Username: Aragorn
IP Address: 160.136.49.104