Hello I have been getting tons of emails with email below. I dont know what else I can do, can anyone please help me understand what is causing this error?
DB Error #145
[SELECT COUNT(*) FROM (SELECT A1.ticket_id FROM hlp_ticket A1 JOIN hlp_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 ('Follow up 1' IN NATURAL LANGUAGE MODE) AS relevance FROM hlp__search Z1 WHERE MATCH (Z1.title, Z1.content) AGAINST ('Follow up 1' IN NATURAL LANGUAGE MODE) ORDER BY relevance DESC) Z1 LEFT JOIN hlp_thread_entry Z2 ON (Z1.object_type = 'H' AND Z1.object_id = Z2.id) LEFT JOIN hlp_thread Z3 ON (Z2.thread_id = Z3.id AND Z3.object_type = 'T') LEFT JOIN hlp_ticket Z5 ON (Z1.object_type = 'T' AND Z1.object_id = Z5.ticket_id) LEFT JOIN hlp_user Z6 ON (Z6.id = Z1.object_id and Z1.object_type = 'U') LEFT JOIN hlp_organization Z7 ON (Z7.id = Z1.object_id AND Z7.id = Z6.org_id AND Z1.object_type = 'O') LEFT JOIN hlp_ticket Z8 ON (Z8.user_id = Z6.id)) Z1 WHERE NOT A1.dept_id = 4 AND A2.id IN (11, 12, 13, 1, 2) AND A1.source REGEXP '\"?Email(\"|, |$)|\"?Web(\"|, |$)|\"?Other(\"|, |$)' AND NOT A1.dept_id = 4 AND A2.id IN (11, 12, 13, 1, 2) AND A1.source REGEXP '\"?Email(\"|, |$)|\"?Web(\"|, |$)|\"?Other(\"|, |$)' AND A2.id IN (10, 1, 2) AND A1.dept_id = 4 AND A1.source REGEXP '\"?Email(\"|, |$)' AND A1.ticket_id = Z1.ticket_id ORDER BY Z1.relevance ) ] Table './IMHETICKETS/hlpsearch' is marked as crashed and should be repaired
---- Backtrace ----
#0 (root)/include/mysqli.php(199): osTicket->logDBError('DB Error #145', '[SELECT COUNT(...')
#1 (root)/include/class.orm.php(3455): db_query('SELECT COUNT()...', true, true)
#2 (root)/include/class.orm.php(3511): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(2941): MySqlExecutor->getRow()
#4 (root)/include/class.orm.php(1372): MySqlCompiler->compileCount(Object(QuerySet))
#5 (root)/include/class.search.php(857): QuerySet->count()
#6 (root)/include/class.search.php(928): SavedQueue->getTotal()
#7 (root)/include/class.search.php(865): SavedQueue::counts(Object(StaffSession), true)
#8 (root)/include/staff/templates/queue-tickets.tmpl.php(96): SavedQueue->getCount(Object(StaffSession))
#9 (root)/scp/tickets.php(526): require_once('/home/imheadmin...')
#10 (root)/scp/index.php(17): require('/home/imheadmin...')
#11 {main}
