DB Error 1194

[sharpedgewv]

Has anyone faced this issue? DB Error #1194. I have about 15 of those messages.

[SELECT count(open.ticket_id) as open, count(answered.ticket_id) as answered ,count(overdue.ticket_id) as overdue, count(assigned.ticket_id) as assigned FROM ost_ticket ticket LEFT JOIN ost_ticket open ON open.ticket_id=ticket.ticket_id AND open.status='open' AND open.isanswered=0 LEFT JOIN ost_ticket answered ON answered.ticket_id=ticket.ticket_id AND answered.status='open' AND answered.isanswered=1 LEFT JOIN ost_ticket overdue ON overdue.ticket_id=ticket.ticket_id AND overdue.status='open' AND overdue.isoverdue=1 LEFT JOIN ost_ticket assigned ON assigned.ticket_id=ticket.ticket_id AND assigned.staff_id=1]

Table 'ost_ticket' is marked as crashed and should be repaired.

[ntozier]

That's not really an OSTicket error. Your mysql table needs to be repaired.

This may be of assistance to you:
http://dev.mysql.com/doc/refman/5.0/...am-repair.html