We have a help desk program (helpdesk pilot) and we are getting errors when we log in.
error select count(distinct(hdp_tickets.ticket_id)) from hdp_tickets left outer join hdp_ticket_priorities on hdp_tickets.priority_id=hdp_ticket_priorities.priority_id , hdp_ticket_status , hdp_departments ,hdp_staff_departments , hdp_clients where hdp_tickets.status=hdp_ticket_status.status_key and hdp_tickets.dept_id=hdp_departments.dept_id and hdp_tickets.dept_id=hdp_staff_departments.dept_id and hdp_tickets.client_id=hdp_clients.client_id and hdp_staff_departments.staff_id='1' and hdp_tickets.status='O' Table 'hdp_tickets' is marked as crashed and should be repaired , 1194
This occurred after a seemingly unrelated directory was deleted via ftp.
We've since restored the deleted directory, but the backup was over a month old, when our server had a different IP address.
I need someone to quickly trouble shoot this and fix the issue.
First person to fix it will get $30.
Please only bid if you can start right away.