Database errors when trying to upgrade from 4.6.10

[B_W_P]

Hello all. I'm trying to upgrade from 4.6.10 to 4.7.14 with no success. I've tried the automatic and manual options

I'm getting 19 similar database errors, such as:

Incorrect key file for table 'core_members'; try to repair it

I assume it's because it's a big jump between versions so the database schema will have changed along the upgrade chain at some point.

Any suggestions? (and thanks in advance!)

[Randy Calvert]

It sounds like the table might have crashed or corrupted. From phpMyAdmin, try running a repair on it. 

[B_W_P]

Thanks Randy. I've set a repair running just now. Fingers crossed...

[B_W_P]

I ran various repair on the DB but get the following error on several of the tables

Note: The storage engine for the table doesn't support repair

I noticed that the tables were mixture of InnoDB and MyISAM

And there was also a mixture of character sets.

I tried changing all the tables to InnoDB, and all the character sets to utf8mb4_unicode_ci, and running repairs using various apps, but still couldn't get the updater to run without crashing my site and having to revert to a backup.

It always seems to end up with a problem re: 'incorrect key files', and if I proceed beyond there the site ends up offline

Incorrect key file for table 'x_table_name_x'; try to repair it

Hey ho, I've run out of time for now - I'll maybe get a chance to have another run at it in a week or so.

[Marc]

You would be best to contact your hosting company on this issue, as it seems you have real problems there with the database. We would advise all tables being in INNODB format, but of course you will need to correct the broken items first