Good day.
I'm running v1.10.4 (035fd0a) of Osticket on Ubuntu.
Web Server Software: Apache/2.4.7 (Ubuntu)
MySQL Version: 5.5.62
PHP Version: 5.6.37-1+ubuntu14.04.1+deb.sury.org+1

I get the below error daily on my instance of Osticket. Please assist.

DB Error #1054
[SELECT A3.address AS user__default_email__address, null AS number, COUNT(DISTINCT A1.ticket_id) AS tickets FROM ost_ticket A1 JOIN ost_user A2 ON (A1.user_id = A2.id) LEFT JOIN ost_user_email A3 ON (A2.default_email_id = A3.id) WHERE (A1.staff_id = 33 OR A1.team_id IN (SELECT A1.team_id FROM ost_team_member A1 WHERE A1.staff_id = 33) OR A1.dept_id IN ('78', '94', '103', '107', '111', '136')) GROUP BY A3.address ORDER BY relevance DESC LIMIT 25] Unknown column 'relevance' in 'order clause'

---- Backtrace ----
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1054', '[SELECT A3.add...')
#1 (root)/include/class.orm.php(3133): db_query('SELECT A3.
addr...', true, true)
#2 (root)/include/class.orm.php(3180): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(1865): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(1815): HashArrayIterator->{closure}()
#5 (root)/include/class.orm.php(1794): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(1803): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1463): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1480): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1489): CachedResultSet->asArray()
#10 (root)/include/ajax.tickets.php(79): CachedResultSet->getIterator()
#11 [internal function]: TicketsAjaxAPI->lookup()
#12 (root)/include/class.dispatcher.php(145): call_user_func_array(Array, Array)
#13 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('lookup', Array)
#14 (root)/include/class.dispatcher.php(120): Dispatcher->resolve('lookup', Array)
#15 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/tickets/lookup', NULL)
#16 (root)/scp/ajax.php(262): Dispatcher->resolve('/tickets/lookup')
#17 {main}

1.10 reached end of life some time go. I would recommend that you upgrade.

Write a Reply...