Hey, we stop receiving tickets. So I have check system logs and there is DB Error #1054.
Any ideas how could I fix this? Thanks

[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 = 11 OR A1.team_id IN (SELECT A1.team_id FROM ost_team_member A1 WHERE A1.staff_id = 11) OR A1.dept_id IN ('1', '2', '3')) GROUP BY A3.address ORDER BY relevance DESC LIMIT 25] Unknown column 'relevance' in 'order clause'

---- Backtrace ----

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

hii changed the title to DB Error #1054 - unable to receive.

If you are really running 1.10.x you should know that it is end of life and no longer supported.

Please help us to help you by reading and following the posting guidelines located in this thread: Please read before requesting assistance. The more information you give us the better we will be able to assist you. Thank you.

Environment details? (see Admin panel -> Dashboard -> Information)

The error is correct, there is no column relevance on their of those three tables.

Write a Reply...