[The Wise One]

real nice hack. been looking for something like this for quite awhile.

i am xperiencing a couple of problems...

when viewing vbugs.php? in the browser, i enter a text search term in the "Enter a bug ID or terms to search for:" box and get an error. i know the exact search term exists in one of the bug posts.

this is the error:

Database error in vBulletin 3.0.3:

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 '%search error%' 
	ORDER BY lastedit desc
	LIMIT 0, 15
	
mysql error: You have an error in your SQL syntax near 'LIKE '%search error%' 
	ORDER BY lastedit desc
	LIMIT 0, 15
	' at line 12

mysql error number: 1064

Date: Thursday 25th of November 2004 02:33:21 PM
Script: http://forums.pcper.com/vbugs.php?s=&do=list&textsearch=search+error
Referer: http://forums.pcper.com/vbugs.php?s=&do=list&textsearch=
Username: The Wise One
IP Address: *********

i get the same error if i use the EXACT title of a bug...word for word. searching using the options below the bug list works fine except if i try to use the field to enter text to search by.

also...even tho i (and others) have ticked the subscribed box...email notifies dont function when someone replies.

what i think would be great to add to this would be a way to edit the content of individual posts in the tracker.

any ideas?