The following results in an SQL error when opening a ticket:
- Create a company with a bracket in the ID '(' and/or ')'
Create a customer linked to this company
Create a ticket for this customer
When opening this ticket, an error is placed in the log
Example error:
Code: Select all
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 '((st.customer_id = 'CustomerAlias') ))) LIMIT 10000' at line 1, SQL: 'SELECT COUNT(DISTINCT(st.id)) FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( 1, 4, 6, 7, 8 ) AND sq.group_id IN (1, 1, 2, 2, 3, 3, 4, 4, 5, 5, 6, 6, 7, 7, 8, 8, 9, 9, 10, 10, 11, 11, 12, 12, 13, 13, 15, 15, 16, 16, 17, 17) AND (((st.customer_id = 'CustomerName') ((st.customer_id = 'CustomerAlias') ))) LIMIT 10000'