Update Error Version 4.7.4 of Invision Community - Incorrect key file for table 'core_edit_history'

[Tobi111]

Hello there,

I am trying to update to Version 4.7.4 of Invision community and it gives me the following error message:

EX1034 Something went wrong. Please try again.
mysqli_sql_exception: Incorrect key file for table 'core_edit_history'; try to repair it (1034)

The automatic repair does not work. Could you give me advice of how to solve this problem?

Looking forward to any helpful answers. Thanks a lot!

Tobias

[Nathan Explosion]

As per the message displayed - try to repair the table

https://www.nexcess.net/help/how-to-repair-mysql-tables/

[Marc Stridgen]

If the above is something you are unsure on, you would really need to contact your hosting company on this, as something has unfortunately gone wrong on your mysql instance that has caused a table to break

[Miss_B]

2 hours ago, Tobi111 said:

The automatic repair does not work.

Did you get any errors at all when trying to repair the table?

I am asking because I 've seen this error almost always happening when the server is running out of disk space where /tmp is located.

2 hours ago, Tobi111 said:

Could you give me advice of how to solve this problem?

The location of MySQL's temporary folder, which is '/tmp' in most cases, should be changed to a location with a bigger disk space.

That is done in mysql's config file. If you don't manage your own dedicated/vps box, you should bring this to your host 's attention. 

Hope it helps.

[Marc Stridgen]

As mentioned at the end of the message there, you really would need to contact your hosting company if this is something you are unable to resolve yourself. Your alternative would be to restore that table from your latest backup