Page 1 of 1
Error Can't execute SQL
Posted: Wed Sep 08, 2021 7:26 am
by boang311
Error:
Can't execute SQL: SELECT * FROM `hesk_tickets` WHERE `status` = '2' AND `lastchange` <= '2021-09-01 15:23:53'
MySQL said:
Incorrect file format 'hesk_tickets'
Is anyone experiencing this phenomena of mine? Please share your thoughts
Re: Error Can't execute SQL
Posted: Wed Sep 08, 2021 7:32 pm
by Klemen
Sounds like a corrupt (damaged) mySQL table.
Go to MySQL (for example, phpMyAdmin) and run a
SQL query (or, in phpMyAdmin, select table then Operations > Repair table)
Re: Error Can't execute SQL
Posted: Fri Sep 10, 2021 6:24 am
by boang311
Sir Klemen, Thank you for the reply. I guess this won't be repairable right?
Code: Select all
Executing SQL command REPAIR TABLE `hesk_tickets`; ..
Table Op Msg_type Msg_text
trackingsys.hesk_tickets repair Error Incorrect file format 'hesk_tickets'
trackingsys.hesk_tickets repair error Corrupt
Re: Error Can't execute SQL
Posted: Fri Sep 10, 2021 10:43 am
by Klemen
Looks like a nasty error in your SQL database. I am not an expert in fixing MySQL corrupted files, but would look at the options in the MySQL documentation:
https://dev.mysql.com/doc/refman/8.0/en ... table.html
If everything fails, the obvious solution would be to restore from a backup.
Re: Error Can't execute SQL
Posted: Fri Sep 10, 2021 10:44 am
by Klemen