- Edited
This hasn't caused any noticable problems as far as i have seen. Anyone else seeing the same thing? Our setup is almost pure stock with no .php changes made to the system. The only thing we did do was import some data via mysql scripts.
You have an error in your SQL syntax; check the manual
that corresponds to your MariaDB server version for the right syntax to use
near 'ON (B1.ticket_id = search.object_id and search.object_type = 'T') LEFT
JOIN (sel' at line 2<br /> <br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(177):
osTicket->logDBError('DB Error #1064', '[SELECT DISTINC...')<br />
#1 (root)/include/class.search.php(418): db_query('SELECT
DISTINCT...', Object(Closure))<br />
#2 (root)/include/class.search.php(66):
MysqlSearchBackend->find('', Array, 'Ticket', Array)<br />
#3 (root)/include/ajax.tickets.php(239):
SearchInterface->find(' ', Array, 'Ticket')<br />
#4 (root)/include/ajax.tickets.php(261):
TicketsAjaxAPI->_search(Array)<br />
#5 : TicketsAjaxAPI->search()<br
/>
#6 (root)/include/class.dispatcher.php(145):
call_user_func_array(Array, Array)<br />
#7 (root)/include/class.dispatcher.php(38):
UrlMatcher->dispatch('search', Array)<br />
#8 (root)/include/class.dispatcher.php(120):
Dispatcher->resolve('search', Array)<br />
#9 (root)/include/class.dispatcher.php(38):
UrlMatcher->dispatch('/tickets/search', NULL)<br />
#10 (root)/scp/ajax.php(186):
Dispatcher->resolve('/tickets/search')<br />
#11 {main}