Hi,
I would like to know why does our osTicket is encountering this error [please see first image: system logs] when we tried to search for a ticket but it does not display the ticket we are looking for? [see second and third image] Kindly help us
Hi,
I would like to know why does our osTicket is encountering this error [please see first image: system logs] when we tried to search for a ticket but it does not display the ticket we are looking for? [see second and third image] Kindly help us
KevinTheJedi hi, this is the complete error
DB Error #144
[(SELECT B5.address
AS user__default_email__address
, A1.number
AS number
, B6.subject
AS cdata__subject
, B4.name
AS user__name
, A1.ticket_id
AS ticket_id
, A3.id
AS thread__id
, A1.flags
AS flags
, 1 AS tickets, COUNT(DISTINCT B7.id
) AS tasks
, COUNT(DISTINCT B8.id
) AS collaborators
, COUNT(DISTINCT C0.id
) AS entries
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_team
B0 ON (A4.object_type
= 'E' AND A4.object_id
= B0.team_id
) LEFT JOIN ost_team
B1 ON (A7.object_type
= 'E' AND A7.object_id
= B1.team_id
) LEFT JOIN ost_department
B2 ON (A4.object_type
= 'D' AND A4.object_id
= B2.id
) LEFT JOIN ost_department
B3 ON (A7.object_type
= 'D' AND A7.object_id
= B3.id
) JOIN ost_user
B4 ON (A1.user_id
= B4.id
) LEFT JOIN ost_user_email
B5 ON (B4.default_email_id
= B5.id
) LEFT JOIN ost_ticket__cdata
B6 ON (A1.ticket_id
= B6.ticket_id
) LEFT JOIN ost_task
B7 ON (A1.ticket_id
= B7.object_id
) LEFT JOIN ost_thread_collaborator
B8 ON (A3.id
= B8.thread_id
) LEFT JOIN ost_thread_entry
C0 ON (A3.id
= C0.thread_id
) WHERE ((A2.state
= 'open' AND (A1.staff_id
= 109 OR A5.staff_id
= 109 OR A6.object_type
= 'C' AND A8.staff_id
= 109 OR A1.team_id
IN (1, 68) OR B0.team_id
IN (1, 68) OR A6.object_type
= 'C' AND B1.team_id
IN (1, 68))) OR A1.dept_id
IN (1) OR B2.id
IN (1) OR A6.object_type
= 'C' AND B3.id
IN (1)) AND A1.number
LIKE ' ICTR0000023536%' GROUP BY A1.ticket_id ORDER BY A1.number
ASC) UNION ALL (SELECT B5.address
AS user__default_email__address
, B6.subject
AS cdata__subject
, B4.name
AS user__name
, A1.ticket_id
AS ticket_id
, A3.id
AS thread__id
, A1.flags
AS flags
, null AS number, COUNT(DISTINCT A1.ticket_id
) AS tickets
, COUNT(DISTINCT B7.id
) AS tasks
, COUNT(DISTINCT B8.id
) AS collaborators
, COUNT(DISTINCT C0.id
) AS entries
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_team
B0 ON (A4.object_type
= 'E' AND A4.object_id
= B0.team_id
) LEFT JOIN ost_team
B1 ON (A7.object_type
= 'E' AND A7.object_id
= B1.team_id
) LEFT JOIN ost_department
B2 ON (A4.object_type
= 'D' AND A4.object_id
= B2.id
) LEFT JOIN ost_department
B3 ON (A7.object_type
= 'D' AND A7.object_id
= B3.id
) JOIN ost_user
B4 ON (A1.user_id
= B4.id
) LEFT JOIN ost_user_email
B5 ON (B4.default_email_id
= B5.id
) LEFT JOIN ost_ticket__cdata
B6 ON (A1.ticket_id
= B6.ticket_id
) LEFT JOIN ost_task
B7 ON (A1.ticket_id
= B7.object_id
) LEFT JOIN ost_thread_collaborator
B8 ON (A3.id
= B8.thread_id
) LEFT JOIN ost_thread_entry
C0 ON (A3.id
= C0.thread_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 ('ICTR0000023536' IN NATURAL LANGUAGE MODE) AS relevance
FROM ost__search
Z1 WHERE MATCH (Z1.title, Z1.content) AGAINST ('ICTR0000023536' 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 ((A2.state
= 'open' AND (A1.staff_id
= 109 OR A5.staff_id
= 109 OR A6.object_type
= 'C' AND A8.staff_id
= 109 OR A1.team_id
IN (1, 68) OR B0.team_id
IN (1, 68) OR A6.object_type
= 'C' AND B1.team_id
IN (1, 68))) OR A1.dept_id
IN (1) OR B2.id
IN (1) OR A6.object_type
= 'C' AND B3.id
IN (1)) AND A1.ticket_id
= Z1.ticket_id
GROUP BY A1.ticket_id ORDER BY Z1.relevance LIMIT 25) LIMIT 25] Table '.\tklsupport\ost__search' is marked as crashed and last (automatic?) repair failed
---- Backtrace ----
#0 C:\inetpub\wwwroot\tklservicedesk\include\mysqli.php(200): osTicket->logDBError()
#1 C:\inetpub\wwwroot\tklservicedesk\include\class.orm.php(3459): db_query()
#2 C:\inetpub\wwwroot\tklservicedesk\include\class.orm.php(3506): MySqlExecutor->execute()
#3 C:\inetpub\wwwroot\tklservicedesk\include\class.orm.php(2093): MySqlExecutor->getArray()
#4 C:\inetpub\wwwroot\tklservicedesk\include\class.orm.php(2043): HashArrayIterator->{closure}()
#5 C:\inetpub\wwwroot\tklservicedesk\include\class.orm.php(2022): CallbackSimpleIterator->next()
#6 C:\inetpub\wwwroot\tklservicedesk\include\class.orm.php(2031): CallbackSimpleIterator->rewind()
#7 C:\inetpub\wwwroot\tklservicedesk\include\class.orm.php(1703): CallbackSimpleIterator->valid()
#8 C:\inetpub\wwwroot\tklservicedesk\include\class.orm.php(1713): CachedResultSet->fillTo()
#9 C:\inetpub\wwwroot\tklservicedesk\include\class.orm.php(1729): CachedResultSet->asArray()
#10 C:\inetpub\wwwroot\tklservicedesk\include\ajax.tickets.php(78): CachedResultSet->getIterator()
#11 C:\inetpub\wwwroot\tklservicedesk\include\class.dispatcher.php(145): TicketsAjaxAPI->lookup()
#12 C:\inetpub\wwwroot\tklservicedesk\include\class.dispatcher.php(38): UrlMatcher->dispatch()
#13 C:\inetpub\wwwroot\tklservicedesk\include\class.dispatcher.php(120): Dispatcher->resolve()
#14 C:\inetpub\wwwroot\tklservicedesk\include\class.dispatcher.php(38): UrlMatcher->dispatch()
#15 C:\inetpub\wwwroot\tklservicedesk\scp\ajax.php(308): Dispatcher->resolve()
#16 {main}
This is the error we are encountering upon opening of ost_search in HeidiSQL of our VM
Yea something happened to your install or environment causing that table to crash. You can look online for guides on how to repair it or you can drop it, recreate it, go to _config table, set value = 1
where key = reindex
, and run cron a bunch of times until it’s done repopulating and it sets reindex back to 0 automatically.
Cheers.
KevinTheJedi Thank you, will try this first!