Hi,
When I try to use the field Attchment count in Advanced Search, I get this error.

DB Error #1054
[SELECT A1.`number` AS `number`, A1.`ticket_id` AS `ticket_id`, A1.`source` AS `source`, 
A1.`created` AS `created`, A2.`subject` AS `cdata__subject`, A1.`isoverdue` AS `isoverdue`, A3.`name` AS `user__name`, A2.`priority` AS `cdata__priority`, A4.`firstname` AS `staff__firstname`, A4.`lastname` AS `staff__lastname`, A5.`name` AS `team__name`, A1.`team_id` AS `team_id`, A1.`isanswered` = '0' AS `2GkBZxz`, (SELECT COUNT(R0.`id`) AS `count` FROM `ost_thread` Q7 JOIN `ost_ticket` Q8 ON (Q7.`object_type` = 'T' AND Q7.`object_id` = Q8.`ticket_id`) LEFT JOIN `ost_thread_entry` R0 ON (Q7.`id` = R0.`thread_id`) WHERE Q8.`ticket_id` = A1.`ticket_id` AND NOT R0.`flags` & 4 != 0) AS _thread_count, (SELECT COUNT(R1.`id`) AS `count` FROM `ost_thread` Q7 JOIN `ost_ticket` Q8 ON (Q7.`object_type` = 'T' AND Q7.`object_id` = Q8.`ticket_id`) LEFT JOIN `ost_thread_entry` R0 ON (Q7.`id` = R0.`thread_id`)
LEFT JOIN `ost_attachment` R1 ON (R1.`type` = 'H' AND R0.`id` = R1.`object_id`) WHERE Q8.`ticket_id` = A1.`ticket_id` AND R1.`inline` = 0) AS _att_count, COALESCE(A4.`firstname`, A4.`lastname`, A5.`name`, 'zzz') AS `assignee` FROM `ost_ticket` A1 LEFT JOIN `ost_ticket__cdata` A2 ON (A1.`ticket_id` = A2.`ticket_id`) JOIN `ost_user` A3 ON (A1.`user_id` = A3.`id`) 
LEFT JOIN `ost_staff` A4 ON (A1.`staff_id` = A4.`staff_id`) LEFT JOIN `ost_team` A5 ON (A1.`team_id` = A5.`team_id`) WHERE A1.`attachment_count` = '2' 
GROUP BY A1.`ticket_id` LIMIT 25] Unknown column 'A1.attachment_count' in 'where clause'

---- Backtrace ----
#0 (root)/include/mysqli.php(199): osTicket->logDBError('DB Error #1054', '[SELECT A1.`num...')
#1 (root)/include/class.orm.php(3455): db_query('SELECT A1.`numb...', true, true)
#2 (root)/include/class.orm.php(3502): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(2085): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(2035): HashArrayIterator->{closure}()
#5 (root)/include/class.orm.php(2014): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(2023): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1695): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1705): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1721): CachedResultSet->asArray()
#10 (root)/include/staff/templates/queue-tickets.tmpl.php(230): CachedResultSet->getIterator()

I get similar error messages when I use fields like Collabortors count or Reopen count.
Here is my system information.

Update: I have tried the same with a fresh installation of v1.14.1. Now I'm getting the same error along with a new error as shown below
Fatal error: Uncaught InconsistentModelException: Unable to prepare query: SELECT A1.numberASnumber, A1.ticket_idASticket_id, A1.sourceASsource, A1.ticket_pidASticket_pid, A1.flagsASflags, A1.createdAScreated, B2.subjectAScdatasubject, A1.isoverdueASisoverdue, B3.nameASusername, B2.priorityAScdatapriority, B4.firstnameASstafffirstname, B4.lastnameASstafflastname, B5.nameASteamname, A1.team_idASteam_id, A1.isanswered= '0' AS2GkBZxz, (SELECT COUNT(R0.id) AScountFROMost_threadQ7 JOINost_ticketQ8 ON (Q7.object_type= 'T' AND Q7.object_id= Q8.ticket_id) LEFT JOINost_thread_entryR0 ON (Q7.id= R0.thread_id) WHERE Q8.ticket_id= A1.ticket_idAND NOT R0.flags& 4 != 0) AS _thread_count, (SELECT COUNT(R1.id) AScountFROMost_threadQ7 JOINost_ticketQ8 ON (Q7.object_type= 'T' AND Q7.object_id= Q8.ticket_id) LEFT JOINost_thread_entryR0 ON (Q7.id= R0.thread_id) LEFT JOIN in ../ost114/include/class.orm.php on line 3460

Write a Reply...