Error Can't execute SQL

[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

[Klemen]

Sounds like a corrupt (damaged) mySQL table.

Go to MySQL (for example, phpMyAdmin) and run a

Code: Select all

REPAIR TABLE `hesk_tickets`;

SQL query (or, in phpMyAdmin, select table then Operations > Repair table)

[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

[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.

[Klemen]

Also see here, Steps 1 and 3:
https://www.stellarinfo.com/blog/how-to ... orruption/