B_W_P Posted November 4, 2023 Share Posted November 4, 2023 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!) Link to comment Share on other sites More sharing options...
Randy Calvert Posted November 4, 2023 Share Posted November 4, 2023 It sounds like the table might have crashed or corrupted. From phpMyAdmin, try running a repair on it. wegorz23 1 Link to comment Share on other sites More sharing options...
B_W_P Posted November 4, 2023 Author Share Posted November 4, 2023 Thanks Randy. I've set a repair running just now. Fingers crossed... Link to comment Share on other sites More sharing options...
B_W_P Posted November 5, 2023 Author Share Posted November 5, 2023 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. Link to comment Share on other sites More sharing options...
Marc Stridgen Posted November 6, 2023 Share Posted November 6, 2023 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 B_W_P 1 Link to comment Share on other sites More sharing options...
Recommended Posts