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.
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
