Hi everybody. I think I've found a bug in the search engine: it fails if you try to search for a long subject (32+ chars) and you use parenthesis at the end. I'm trying searching for tickets with subjetct like this example as only condition: "SEARCH FOR A LONG SUBJECT WITH PARENTHESIS (ISSUE)" The search engine returns nothing (even if there are tickets with this subject) and you obtain this error in the log: [Tue Apr 6 16:30:47 2010][Error][Kernel::System::Ticket::TicketSearch][4752] 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 '((LOWER(art.a_subject) LIKE LOWER ('%ISSUE%')) )(LOWER(art.a_subject) LIKE LOWER(' at line 1, SQL: 'SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st, queue sq , article art WHERE sq.id = st.queue_id AND st.id = art.ticket_id AND sq.group_id IN (1, 2, 3, 3, 4, 5, 6, 7, 8, 9, 12, 13, 14, 15) AND (((LOWER (art.a_subject) LIKE LOWER('%SEARCHFORALONGSUBJECTWITHPARENTHESIS%')) ((LOWER(art.a_subject) LIKE LOWER('%ISSUE%')) )(LOWER(art.a_subject) LIKE LOWER('%')) )) ORDER BY st.create_time_unix DESC LIMIT 2000' IMHO, the problem is the long subject (that probably means there are more than like comparison in the query) and parenthesis use. I don't understand the query where part so I am not be able to fix it. Could someone help me? Thank you very much in advance. Regards. Jesus.