Getting a ton of db errors especially 1066.
Anyone have an idea of what causes this and/or how to fix? Any insight would be welcome.
Disclaimer: I am not IT, but the IT dept seems to be ignoring that fact I've told them to upgrade for the last 8 months.
[SELECT COUNT(*) FROM (SELECT A1.ticket_id FROM ost5h_ticket A1 JOIN ost5h_ticket_status A2 ON (A1.status_id = A2.id) 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 ('status name' IN NATURAL LANGUAGE MODE) AS relevance FROM ost5h__search Z1 WHERE MATCH (Z1.title, Z1.content) AGAINST ('status name' IN NATURAL LANGUAGE MODE) ORDER BY relevance DESC) Z1 LEFT JOIN ost5h_thread_entry Z2 ON (Z1.object_type = 'H' AND Z1.object_id = Z2.id) LEFT JOIN ost5h_thread Z3 ON (Z2.thread_id = Z3.id AND (Z3.object_type = 'T' OR Z3.object_type = 'C')) LEFT JOIN ost5h_ticket Z5 ON (Z1.object_type = 'T' AND Z1.object_id = Z5.ticket_id) LEFT JOIN ost5h_user Z6 ON (Z6.id = Z1.object_id and Z1.object_type = 'U') LEFT JOIN ost5h_organization Z7 ON (Z7.id = Z1.object_id AND Z7.id = Z6.org_id AND Z1.object_type = 'O') LEFT JOIN ost5h_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 ('status name' IN NATURAL LANGUAGE MODE) AS relevance FROM ost5h__search Z1 WHERE MATCH (Z1.title, Z1.content) AGAINST ('status name' IN NATURAL LANGUAGE MODE) ORDER BY relevance DESC) Z1 LEFT JOIN ost5h_thread_entry Z2 ON (Z1.object_type = 'H' AND Z1.object_id = Z2.id) LEFT JOIN ost5h_thread Z3 ON (Z2.thread_id = Z3.id AND (Z3.object_type = 'T' OR Z3.object_type = 'C')) LEFT JOIN ost5h_ticket Z5 ON (Z1.object_type = 'T' AND Z1.object_id = Z5.ticket_id) LEFT JOIN ost5h_user Z6 ON (Z6.id = Z1.object_id and Z1.object_type = 'U') LEFT JOIN ost5h_organization Z7 ON (Z7.id = Z1.object_id AND Z7.id = Z6.org_id AND Z1.object_type = 'O') LEFT JOIN ost5h_ticket Z8 ON (Z8.user_id = Z6.id)) Z1 WHERE A1.dept_id IN (4, 14) AND NOT A1.team_id IN (10) AND A2.id IN (1, 6) AND A1.ticket_id = Z1.ticket_id AND A1.dept_id IN (4, 14) AND A2.id IN (1, 6) AND A1.staff_id IN (45, 47, 46) AND A1.dept_id IN (4, 14) AND NOT A1.team_id IN (10) AND A2.id IN (1, 6) AND A1.ticket_id = Z1.ticket_id AND A1.dept_id IN (4, 14) AND A2.id IN (1, 6) AND A1.staff_id IN (45, 47, 46) AND A2.id IN (1, 6) AND A1.dept_id IN (4, 14) AND A1.staff_id IN (45, 47, 46) ORDER BY Z1.relevance , Z1.relevance ) __] Not unique table/alias: 'Z1'
---- Backtrace ----
#0 (root)/include/mysqli.php(201): osTicket->logDBError('DB Error #1066', '[SELECT COUNT(...')
#1 (root)/include/class.orm.php(3466): db_query('SELECT COUNT()...', true, true)
#2 (root)/include/class.orm.php(3522): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(2952): MySqlExecutor->getRow()
#4 (root)/include/class.orm.php(1380): MySqlCompiler->compileCount(Object(QuerySet))
#5 (root)/include/class.search.php(904): QuerySet->count()
#6 (root)/include/class.search.php(997): SavedQueue->getTotal()
#7 (root)/include/ajax.search.php(398): SavedQueue::counts(Object(StaffSession), true, Array)
#8 (root)/include/class.dispatcher.php(145): SearchAjaxAPI->collectQueueCounts()
#9 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('counts', Array)
#10 (root)/include/class.dispatcher.php(120): Dispatcher->resolve('counts', Array)
#11 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/queue/counts', NULL)
#12 (root)/scp/ajax.php(314): Dispatcher->resolve('/queue/counts')
#13 {main}
