I been having this for quite some time and was unable to solve it . I've been waiting for a version (my current is v1.12.5 (933bb1f) ) that solves it.
Here is the log
[SELECT A1.number AS number, A1.ticket_id AS ticket_id, A1.source AS source, A1.created AS created, A3.subject AS cdata__subject, A1.isoverdue AS isoverdue, A4.name AS user__name, A3.priority AS cdata__priority, A5.firstname AS staff__firstname, A5.lastname AS staff__lastname, A6.name AS team__name, A1.team_id AS team_id, A1.isanswered = '0' AS 2GkBZxz, (SELECT COUNT(R0.id) AS count FROM ost_thread Q7 JOIN ost_ticket Q8 ON (Q7.object_type = 'T' AND Q7.object_id = Q8.ticket_id) LEFT JOIN ost_thread_entry R0 ON (Q7.id = R0.thread_id) WHERE Q8.ticket_id = A1.ticket_id AND NOT R0.flags & 4 != 0) AS _thread_count, (SELECT COUNT(R1.id) AS count FROM ost_thread Q7 JOIN ost_ticket Q8 ON (Q7.object_type = 'T' AND Q7.object_id = Q8.ticket_id) LEFT JOIN ost_thread_entry R0 ON (Q7.id = R0.thread_id) LEFT JOIN ost_attachment R1 ON (R1.type = 'H' AND R0.id = R1.object_id) WHERE Q8.ticket_id = A1.ticket_id AND R1.inline = 0) AS _att_count, COALESCE(A5.firstname, A5.lastname, A6.name, 'zzz') AS assignee FROM ost_ticket A1 JOIN (SELECT Q7.ticket_id, Z1.relevance AS relevance FROM ost_ticket Q7 JOIN ost_ticket_status Q8 ON (Q7.status_id = Q8.id) LEFT JOIN ost_thread R0 ON (R0.object_type = 'T' AND Q7.ticket_id = R0.object_id) LEFT JOIN ost_thread_referral R1 ON (R0.id = R1.thread_id) LEFT JOIN ost_staff R2 ON (R1.object_type = 'S' AND R1.object_id = R2.staff_id) LEFT JOIN ost_team R3 ON (R1.object_type = 'E' AND R1.object_id = R3.team_id) LEFT JOIN ost_department R4 ON (R1.object_type = 'D' AND R1.object_id = R4.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 (930130 IN NATURAL LANGUAGE MODE) AS relevance FROM ost__search Z1 WHERE MATCH (Z1.title, Z1.content) AGAINST (930130 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') 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 Q7.ticket_id = Z1.ticket_id AND ((Q8.state = 'open' AND (Q7.staff_id = 20 OR R2.staff_id = 20 OR Q7.team_id IN (1) OR R3.team_id IN (1))) OR Q7.dept_id IN (14, 8, 6, 5, 9) OR R4.id IN (14, 8, 6, 5, 9)) ORDER BY Z1.relevance LIMIT 500) A2 LEFT JOIN ost_ticket__cdata A3 ON (A1.ticket_id = A3.ticket_id) JOIN ost_user A4 ON (A1.user_id = A4.id) LEFT JOIN ost_staff A5 ON (A1.staff_id = A5.staff_id) LEFT JOIN ost_team A6 ON (A1.team_id = A6.team_id) WHERE A1.ticket_id = A2.ticket_id GROUP BY A1.ticket_id ORDER BY relevance DESC LIMIT 30] Table 'osticket.ost__search' doesn't exist