Cannot open "Home" tab.. SQL error

Helpdesk for my helpdesk software

Moderator: mkoch227

Post Reply
jakkieb
Posts: 2
Joined: Wed Aug 31, 2016 3:21 pm

Cannot open "Home" tab.. SQL error

Post by jakkieb »

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?
jakkieb
Posts: 2
Joined: Wed Aug 31, 2016 3:21 pm

Re: Cannot open "Home" tab.. SQL error

Post by jakkieb »

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... :)
Post Reply