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


I've been seeing this error pop up up every so often, but not too often, I'm running osTicket 1.10 stable and would like to know if I can get help figuring out what causes it. Here is the log for the 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` = 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 ('24', '21', '4', '22', '18', '11', '20', '19', '23', '26')) GROUP BY A3.`address` ORDER BY __relevance__ DESC LIMIT 25]

Unknown column '__relevance__' in 'order clause'


  • Version of MySQL?
    Version of PHP?
  • Sorry about that, should of known those would be needed.

    MySQL = 5.5.24

    PHP = 5.4.3
  • Please make sure to update your PHP to 5.6.x. I see a lot of issues with anything below 5.6.x and osticket v1.10. 
  • edited June 2017
    Buenas tardes soy nuevo con this application, Instale osTicket Pero Al Momento de Hacer las que me da el error # 1054, adjunto pantallazos, ojala me puedan Ayudar gracias.
  • edited June 2017
    Good afternoon I'm new with this application, Install osTicket But at the moment of doing the one that gives me the error # 1054, attached screenshots, I hope they can help me thanks.

    @Jtito, please open your own thread and not post your issue in someone else's post. Your fix may be different than theirs.

    Abra su propio hilo y no publique su problema en la publicación de otra persona. Su arreglo puede ser diferente del de ellos.

    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. 

    Por favor, ayúdenos a ayudarle leyendo y siguiendo las pautas de publicación ubicadas en este hilo: Por favor, lea antes de solicitar ayuda. Cuanta más información nos dé, mejor podremos ayudarle. Gracias.
Sign In or Register to comment.