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 all,


To day I got this message from server, my system:


Server Information

osTicket Version v1.10 (901e5ea)
Web Server Software Apache/2.4.17 (Win32) OpenSSL/1.0.2d PHP/5.5.38
MySQL Version 10.1.13
PHP Version 5.5.38


Detail error:

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` = 4 OR A1.`team_id` IN (SELECT A1.`team_id` FROM `ost_team_member` A1 WHERE A1.`staff_id` = 4) OR A1.`dept_id` IN ('4')) GROUP BY A3.`address` ORDER BY __relevance__ DESC LIMIT 25]

 

Unknown column '__relevance__' in 'order clause'<br /> <br />

---- Backtrace ----<br />

#0 D:\Xampp\htdocs\ticket\include\mysqli.php(204): osTicket->logDBError('DB Error #1054', '[SELECT A3.`add...')<br />

#1 D:\Xampp\htdocs\ticket\include\class.orm.php(3133): db_query('SELECT A3.`addr...', true, true)<br />

#2 D:\Xampp\htdocs\ticket\include\class.orm.php(3180): MySqlExecutor->execute()<br />

#3 D:\Xampp\htdocs\ticket\include\class.orm.php(1865): MySqlExecutor->getArray()<br />

#4 D:\Xampp\htdocs\ticket\include\class.orm.php(1815): HashArrayIterator->{closure}()<br />

#5 D:\Xampp\htdocs\ticket\include\class.orm.php(1794): CallbackSimpleIterator->next()<br />

#6 D:\Xampp\htdocs\ticket\include\class.orm.php(1803): CallbackSimpleIterator->rewind()<br />

#7 D:\Xampp\htdocs\ticket\include\class.orm.php(1463): CallbackSimpleIterator->valid()<br />

#8 D:\Xampp\htdocs\ticket\include\class.orm.php(1480): CachedResultSet->fillTo(2147483647)<br />

#9 D:\Xampp\htdocs\ticket\include\class.orm.php(1489): CachedResultSet->asArray()<br />

#10 D:\Xampp\htdocs\ticket\include\ajax.tickets.php(79): CachedResultSet->getIterator()<br />

#11 [internal function]: TicketsAjaxAPI->lookup()<br />

#12 D:\Xampp\htdocs\ticket\include\class.dispatcher.php(145): call_user_func_array(Array, Array)<br />

#13 D:\Xampp\htdocs\ticket\include\class.dispatcher.php(38): UrlMatcher->dispatch('lookup', Array)<br />

#14 D:\Xampp\htdocs\ticket\include\class.dispatcher.php(120): Dispatcher->resolve('lookup', Array)<br />

#15 D:\Xampp\htdocs\ticket\include\class.dispatcher.php(38): UrlMatcher->dispatch('/tickets/lookup', NULL)<br />

#16 D:\Xampp\htdocs\ticket\scp\ajax.php(262): Dispatcher->resolve('/tickets/lookup')<br />

#17 {main}

So, what's the problem?


Comments

Sign In or Register to comment.