Surpac Posted July 12 Posted July 12 Hello, Manually upgrading from 4.7.16 to 4.7.17 and getting this error during the upgrade. Couldn't find 'core_modules_new' table in database from phpmyadmin. Any help would be appretiated. Thanks!
Jim M Posted July 12 Posted July 12 The table has crashed or has become corrupted. You’ll want to contact your hosting provider to see if it can be repaired. Otherwise, you’ll need to restore a backup when it was not encountering this issue.
Surpac Posted July 12 Author Posted July 12 Thanks for your reply Jim. Unfortunately I'm hosting it in house. I did upgrade MySQL before the Forum software upgrade. MySQL upgrade went fine and the forum 4.7.16 version was functional without error. After mySQL upgrade, I tried to upgrade the forum to 4.7.17 and got this error. Reverting back to 4.7.16 forum works. Do you know how I can find this table from mySQLAdmin side to run a repair on it? I did a search but couldn't find it. Thanks for your support.
teraßyte Posted July 12 Posted July 12 There shouldn't be any table with that name. 🤔 Is your database using utf8mb4 or a different charset? The utf8mb4 database check is about the only function I can remember that creates that kind of _new suffix. Chris59 1
Surpac Posted July 12 Author Posted July 12 Thanks for your respond! Looks like we are using utf8mb4_unicode_ci.
teraßyte Posted July 13 Posted July 13 That's the server collation, not the tables collation. Open the database used by the forum and check the Collation column for all tables on that page.
teraßyte Posted July 13 Posted July 13 Ok, utf8mb3 is the new alias for utf8 in recent MySQL versions. You have to convert your database to utf8mb4 with the tool in the ACP before upgrading to the latest version. There should be a link to the tool on the ACP > Support page. Click the link and start the conversion from there. Alternatively, there is also a tool you can run from SSH if your database is big (GBs of data). Surpac, Marc, media and 1 other 3 1
Surpac Posted July 13 Author Posted July 13 You are amazing. Thanks for all the information!! I'll work on it and see how far I can go. Again, thanks very much for your help! media 1
Surpac Posted August 21 Author Posted August 21 @teraßyte Just wanted to thank you once again for your help. I was able to convert and upgrade mySQL successfully. All the best wishes, Surpac teraßyte 1
Recommended Posts