Jump to content

Recommended Posts

Posted

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!


Could contain: File, Webpage, Text, Page

Posted

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. 

Posted

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.

 

Posted

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.

Posted

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.

Posted

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).

Posted

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!

  • 1 month later...
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...