Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

DB Error #1054

Hi,

I suddenly received DB error #1054. Please help.


 DB Error #1054

[SELECT A3.`address` AS `user__default_email__address`, null AS number, COUNT(DISTINCT A1.`ticket_id`) AS `tickets` FROM `osdb_ticket` A1 JOIN `osdb_user` A2 ON (A1.`user_id` = A2.`id`) LEFT JOIN `osdb_user_email` A3 ON (A2.`default_email_id` = A3.`id`) WHERE (A1.`staff_id` = 4 OR A1.`team_id` IN (SELECT A1.`team_id` FROM `osdb_team_member` A1 WHERE A1.`staff_id` = 4) OR A1.`dept_id` IN ('1')) 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 (root)/include/class.dispatcher.php(145): TicketsAjaxAPI->lookup()
#12 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('lookup', Array)
#13 (root)/include/class.dispatcher.php(120): Dispatcher->resolve('lookup', Array)
#14 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/tickets/lookup', NULL)
#15 (root)/scp/ajax.php(262): Dispatcher->resolve('/tickets/lookup')
#16 {main}



Comments

Sign In or Register to comment.