Regarding the error mentioned in your screenshot: "Incorrect Key File for Table", it usually happens because of either a disk space issue or a corruption in the aforementioned table.
The disk space issue is caused when the sql query is fetching data greater than the /tmp folder 's size. That 's the folder used for storing temporary tables btw. To fix this, you must change the folder location to a disk having enough free space
The corruption issue can be be fixed with the query posted above. If that won't help, you can drop the table altogether from the dataabse then re create it and re insert the data.
But if it is related to the disc space issue, it is best if you talked to your host about this, unless you manage your own vps/dedicated box.