Script URL: http://ccandp.net/helpdesk/admin/admin_main.php
Version of script:
Hosting company: Country Computers and Publishing
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:
Write your message below: I can log into Hesk fine, all tabs work except for "Home". I can see the number of active entries, the number of tickets, the knowledge base and etc. but using "debug" I get this error message when clicking "Home"....
Can't execute SQL: SELECT * FROM `hesk_tickets` WHERE 1 AND `status` IN ('0','1','2','4','5') ORDER BY CASE WHEN `priority` = '0' THEN 1 ELSE 0 END DESC , `status` ASC , `priority` ASC LIMIT 0 , 20
MySQL said:
Table 'hesk_tickets' is marked as crashed and should be repaired
What does this mean? How do I fix this?
Cannot open "Home" tab.. SQL error
Moderator: mkoch227
Re: Cannot open "Home" tab.. SQL error
Ok.. got it fixed. Went into MySQL > PhpMyAdmin and found Hesk, found the "Hesk_Tickets" item and clicked on it, scrolled down the screen to "Table Maintenance" and clicked "Repair Table" and viola, issue fixed!! Now time to back-up... 
