0004045: issue search using substring 'ldap' fails on bugs.mantisbt.org - MantisBT

ID	Project	Category	View Status	Date Submitted	Last Update
0004045	mantisbt	sql	public	2004-07-08 12:30	2004-07-18 11:35

Reporter	kaipingj	Assigned To	Narcissus
Priority	normal	Severity	major	Reproducibility	always
Status	closed	Resolution	duplicate
Product Version	0.19.0a1
Fixed in Version	0.19.0a2

Summary	0004045: issue search using substring 'ldap' fails on bugs.mantisbt.org
Description	Hi, I was looking for any ldap issues that may exist in the bugs.mantisbt.org because I'm seeing issues with the 18.3 version when I set $g_login_method to LDAP. (I'll open another ticket for this.) Anyway, when going to bugs.mantisbt.org I: created new login clicked on "View Issues" typed 'ldap' into the bug search field and got the message listed in the "Additional Information" field. tried hitting the back button, but was not taken back to the search page and now whenever I hit the "View Issues" link to try a new search, I don't get the search page, but instead keep getting the error mentioned above.
Additional Information	APPLICATION ERROR 0000401 Database query failed. Error received from database was 0001064: You have an error in your SQL syntax near '(mantis_bug_table LEFT JOIN mantis_bugnote_table ON mantis_bugnote_table.bug_id ' at line 1 for the query: SELECT COUNT( DISTINCT mantis_bug_table.id ) as count FROM mantis_bug_text_table, mantis_project_table ,(mantis_bug_table LEFT JOIN mantis_bugnote_table ON mantis_bugnote_table.bug_id = mantis_bug_table.id) LEFT JOIN mantis_bugnote_text_table ON mantis_bugnote_text_table.id = mantis_bugnote_table.bugnote_text_id WHERE mantis_project_table.enabled = 1 AND mantis_project_table.id = mantis_bug_table.project_id AND (mantis_bug_table.project_id='1') AND (mantis_bug_table.view_state='10' OR mantis_bug_table.reporter_id='5036') AND ((mantis_bug_table.status='10') OR (mantis_bug_table.status='20') OR (mantis_bug_table.status='30') OR (mantis_bug_table.status='40') OR (mantis_bug_table.status='50') OR (mantis_bug_table.status='80')) AND ((summary LIKE '%ldap%') OR (mantis_bug_text_table.description LIKE '%ldap%') OR (mantis_bug_text_table.steps_to_reproduce LIKE '%ldap%') OR (mantis_bug_text_table.additional_information LIKE '%ldap%') OR (mantis_bug_table.id LIKE '%ldap%') OR (mantis_bugnote_text_table.note LIKE '%ldap%')) AND (mantis_bug_text_table.id = mantis_bug_table.bug_text_id)
Tags	No tags attached.