osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now
Table 'gift_support.ost_ticket_lock' doesn't exist
I am using osticket 1.7, and i get this message in regular inverval of time, my front section is working properly, but in admin section when try to check open tickets, it doesn't open also closed tickets doesn't open. Following is the error that i got. Second thing yesterday, i upgraded the system from 1.7 to 1.9 but still having problem, open and closed tickets are not opening, please check them and tell me the issue.
[SELECT ticket.*, lock_id, dept_name, priority_desc ,IF(sla.id IS NULL, NULL, DATE_ADD(ticket.created, INTERVAL sla.grace_period HOUR)) as sla_duedate ,count(attach.attach_id) as attachments FROM ost_ticket ticket LEFT JOIN ost_department dept ON (ticket.dept_id=dept.dept_id) LEFT JOIN ost_sla sla ON (ticket.sla_id=sla.id AND sla.isactive=1) LEFT JOIN ost_ticket_priority pri ON (ticket.priority_id=pri.priority_id) LEFT JOIN ost_ticket_lock tlock ON (ticket.ticket_id=tlock.ticket_id AND tlock.expire>NOW()) LEFT JOIN ost_ticket_attachment attach ON (ticket.ticket_id=attach.ticket_id) WHERE ticket.ticket_id=47 GROUP BY ticket.ticket_id]Table 'gift_support.ost_ticket_lock' doesn't exist
Thanks in advance