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

      kel_gorl

      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.

        Write a Reply...