We have been getting hundreds of these errors in our log files and I cannot figure out why this is happening.
Can any please advise on why this maybe happening?

DB Error #1054
[SELECT COUNT(DISTINCT CASE WHEN A1.topic_id = 16 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q18, COUNT(DISTINCT CASE WHEN A1.topic_id = 16 AND A1.topic_id = 16 AND A1.topic_id = 16 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q19, COUNT(DISTINCT CASE WHEN A1.ticket_id = Z1.ticket_id AND A3.object_type = 'T' THEN A1.ticket_id END) AS q22, COUNT(DISTINCT CASE WHEN A1.ticket_id = Z1.ticket_id AND A1.ticket_id = Z1.ticket_id AND A1.ticket_id = Z1.ticket_id AND A3.object_type = 'T' THEN A1.ticket_id END) AS q23, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q1, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.isanswered = '0' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q2, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.isanswered = '1' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q3, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.isoverdue = '1' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q4, COUNT(DISTINCT CASE WHEN A1.staff_id IN (25) AND A2.state = 'open' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q5, COUNT(DISTINCT CASE WHEN A1.staff_id IN (25) AND A2.state = 'open' AND A1.staff_id IN (25) AND A2.state = 'open' AND A1.staff_id IN (25) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q6, COUNT(DISTINCT CASE WHEN A1.staff_id IN (25) AND A2.state = 'open' AND A1.staff_id IN (25) AND A2.state = 'open' AND NOT A1.staff_id IN (25) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q7, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q8, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2021-03-14 00:00:00' AND '2021-03-14 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q9, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2021-03-13 00:00:00' AND '2021-03-13 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q10, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2021-03-08 00:00:00' AND '2021-03-14 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q11, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2021-03-01 00:00:00' AND '2021-03-31 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q12, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2021-01-01 00:00:00' AND '2021-03-31 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q13, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2021-01-01 00:00:00' AND '2021-12-31 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q14 FROM ost_ticket A1 JOIN ost_ticket_status A2 ON (A1.status_id = A2.id) LEFT JOIN ost_thread A3 ON (A3.object_type = 'T' AND A1.ticket_id = A3.object_id) LEFT JOIN ost_thread_referral A4 ON (A3.id = A4.thread_id) LEFT JOIN ost_staff A5 ON (A4.object_type = 'S' AND A4.object_id = A5.staff_id) LEFT JOIN ost_thread A6 ON (A1.ticket_id = A6.object_id AND A6.object_type = 'C') LEFT JOIN ost_thread_referral A7 ON (A6.id = A7.thread_id) LEFT JOIN ost_staff A8 ON (A7.object_type = 'S' AND A7.object_id = A8.staff_id) LEFT JOIN ost_department B0 ON (A4.object_type = 'D' AND A4.object_id = B0.id) LEFT JOIN ost_department B1 ON (A7.object_type = 'D' AND A7.object_id = B1.id) WHERE ((A2.state = 'open' AND (A1.staff_id = 25 OR A5.staff_id = 25 OR A6.object_type = 'C' AND A8.staff_id = 25)) OR (A2.state IN ('open', 'closed') AND (A1.dept_id IN (1, 2, 4, 5, 6, 9) OR B0.id IN (1, 2, 4, 5, 6, 9))) OR A6.object_type = 'C' AND B1.id IN (1, 2, 4, 5, 6, 9))] Unknown column 'Z1.ticket_id' in 'field list'

---- Backtrace ----
#0 (root)/include/mysqli.php(200): osTicket->logDBError('DB Error #1054', '[SELECT COUNT(D...')
#1 (root)/include/class.orm.php(3459): db_query('SELECT COUNT(DI...', true, true)
#2 (root)/include/class.orm.php(3506): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(2093): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(2043): HashArrayIterator->{closure}()
#5 (root)/include/class.orm.php(2022): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(2031): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1703): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1713): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1336): CachedResultSet->asArray()
#10 (root)/include/class.orm.php(1359): QuerySet->all()
#11 (root)/include/class.search.php(973): QuerySet->one()
#12 (root)/scp/autocron.php(43): SavedQueue::counts(Object(StaffSession), false)
#13 {main}

and then this one, both at the same time.

DB Error #1066
[SELECT COUNT(*) FROM (SELECT A1.ticket_id FROM ost_ticket A1 JOIN (SELECT COALESCE(Z3.object_id, Z5.ticket_id, Z8.ticket_id) as ticket_id, Z1.relevance FROM (SELECT Z1.object_id, Z1.object_type, MATCH (Z1.title, Z1.content) AGAINST ('Call Center' IN NATURAL LANGUAGE MODE) AS relevance FROM ost__search Z1 WHERE MATCH (Z1.title, Z1.content) AGAINST ('Call Center' IN NATURAL LANGUAGE MODE) ORDER BY relevance DESC) Z1 LEFT JOIN ost_thread_entry Z2 ON (Z1.object_type = 'H' AND Z1.object_id = Z2.id) LEFT JOIN ost_thread Z3 ON (Z2.thread_id = Z3.id AND (Z3.object_type = 'T' OR Z3.object_type = 'C')) LEFT JOIN ost_ticket Z5 ON (Z1.object_type = 'T' AND Z1.object_id = Z5.ticket_id) LEFT JOIN ost_user Z6 ON (Z6.id = Z1.object_id and Z1.object_type = 'U') LEFT JOIN ost_organization Z7 ON (Z7.id = Z1.object_id AND Z7.id = Z6.org_id AND Z1.object_type = 'O') LEFT JOIN ost_ticket Z8 ON (Z8.user_id = Z6.id)) Z1 JOIN (SELECT COALESCE(Z3.object_id, Z5.ticket_id, Z8.ticket_id) as ticket_id, Z1.relevance FROM (SELECT Z1.object_id, Z1.object_type, MATCH (Z1.title, Z1.content) AGAINST ('Call Center' IN NATURAL LANGUAGE MODE) AS relevance FROM ost__search Z1 WHERE MATCH (Z1.title, Z1.content) AGAINST ('Call Center' IN NATURAL LANGUAGE MODE) ORDER BY relevance DESC) Z1 LEFT JOIN ost_thread_entry Z2 ON (Z1.object_type = 'H' AND Z1.object_id = Z2.id) LEFT JOIN ost_thread Z3 ON (Z2.thread_id = Z3.id AND (Z3.object_type = 'T' OR Z3.object_type = 'C')) LEFT JOIN ost_ticket Z5 ON (Z1.object_type = 'T' AND Z1.object_id = Z5.ticket_id) LEFT JOIN ost_user Z6 ON (Z6.id = Z1.object_id and Z1.object_type = 'U') LEFT JOIN ost_organization Z7 ON (Z7.id = Z1.object_id AND Z7.id = Z6.org_id AND Z1.object_type = 'O') LEFT JOIN ost_ticket Z8 ON (Z8.user_id = Z6.id)) Z1 JOIN (SELECT COALESCE(Z3.object_id, Z5.ticket_id, Z8.ticket_id) as ticket_id, Z1.relevance FROM (SELECT Z1.object_id, Z1.object_type, MATCH (Z1.title, Z1.content) AGAINST ('Call Center' IN NATURAL LANGUAGE MODE) AS relevance FROM ost__search Z1 WHERE MATCH (Z1.title, Z1.content) AGAINST ('Call Center' IN NATURAL LANGUAGE MODE) ORDER BY relevance DESC) Z1 LEFT JOIN ost_thread_entry Z2 ON (Z1.object_type = 'H' AND Z1.object_id = Z2.id) LEFT JOIN ost_thread Z3 ON (Z2.thread_id = Z3.id AND (Z3.object_type = 'T' OR Z3.object_type = 'C')) LEFT JOIN ost_ticket Z5 ON (Z1.object_type = 'T' AND Z1.object_id = Z5.ticket_id) LEFT JOIN ost_user Z6 ON (Z6.id = Z1.object_id and Z1.object_type = 'U') LEFT JOIN ost_organization Z7 ON (Z7.id = Z1.object_id AND Z7.id = Z6.org_id AND Z1.object_type = 'O') LEFT JOIN ost_ticket Z8 ON (Z8.user_id = Z6.id)) Z1 WHERE A1.ticket_id = Z1.ticket_id AND A1.ticket_id = Z1.ticket_id AND A1.ticket_id = Z1.ticket_id ORDER BY Z1.relevance , Z1.relevance , Z1.relevance ) __] Not unique table/alias: 'Z1'

---- Backtrace ----
#0 (root)/include/mysqli.php(200): osTicket->logDBError('DB Error #1066', '[SELECT COUNT(...')
#1 (root)/include/class.orm.php(3459): db_query('SELECT COUNT()...', true, true)
#2 (root)/include/class.orm.php(3515): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(2945): MySqlExecutor->getRow()
#4 (root)/include/class.orm.php(1380): MySqlCompiler->compileCount(Object(QuerySet))
#5 (root)/include/class.search.php(897): QuerySet->count()
#6 (root)/include/class.search.php(976): SavedQueue->getTotal()
#7 (root)/scp/autocron.php(43): SavedQueue::counts(Object(StaffSession), false)
#8 {main}

Server Information
osTicket Version v1.14.1 (f1e9e88) — v1.14.5 is available
Web Server Software nginx/1.10.3
MySQL Version 5.6.44
PHP Version 7.0.33-0+deb9u6
PHP Extensions
gdlib Used for image manipulation and PDF printing
imap Used for email fetching
xml XML API
xml-dom Used for HTML email processing
json Improves performance creating and processing JSON
mbstring Highly recommended for non western european language content
phar Highly recommended for plugins and language packs
intl Highly recommended for non western european language content
fileinfo Used to detect file types for uploads
zip Used for ticket and task exporting
APCu Improves overall performance
Zend Opcache Improves overall performance
PHP Settings
cgi.fix_pathinfo "1" is recommended if AJAX is not working
date.timezone America/New_York

    You have what two different errors in this thread.

    The first Error is:

    Danielc1234 Unknown column 'Z1.ticket_id' in 'field list'

    This appears to correspond with

    Danielc1234 Z1.ticket_id AND A3.object_type = 'T' THEN A1.ticket_id END) AS q22

    Queue 22 appears to have an issue. You can either edit it and see what it does or delete it.

    The second error appears to be a cascading error (ie is happening because of the first one). Once you delete Queue 22 we can see if it goes away.

        Write a Reply...