Fatal Errors after upgrading some modules

We are running CentOS 6.3 and FreePBX 2.11.0.24. This was built from AsteriskNow, as we have found that this provides the best support for Digium phones. We have about 75 of those.

Upon upgrading a few modules today, we found that many of them now give “Fatal Error” when trying to acces via the GUI. FOr example, when clicking on an extension I get the dump at the end of this post.

In Module Admin I see four broken modules: Directory, Time Conditions, Queues, Parking. I have tried to uninstall/reinstall a couple of these but cannot do either because it creates another FATAL ERROR.

Tried to download an earlier version of one of the broken modules to downgrade it in case that might “unbreak” it. But I would have to go way back because checking this URL:

http://mirror.freepbx.org/modules/release/2.10

gives me this response:

This Location is no longer accurate. 
We Will have something soon. 

Here is the screen dump I get when clicking on an Extension to modify. Any suggestions would be greatly appreciated.


FATAL ERROR
SELECT featurecodes.modulename, featurecodes.featurename, featurecodes.description AS featuredescription, featurecodes.enabled AS featureenabled, featurecodes.defaultcode, featurecodes.customcode, modules.enabled AS moduleenabled, featurecodes.providedest FROM featurecodes INNER JOIN modules ON modules.modulename = featurecodes.modulename ORDER BY featurecodes.modulename, featurecodes.description [nativecode=126 ** Incorrect key file for table ‘./asterisk/featurecodes.MYI’; try to repair it]SQL -
SELECT featurecodes.modulename, featurecodes.featurename, featurecodes.description AS featuredescription, featurecodes.enabled AS featureenabled, featurecodes.defaultcode, featurecodes.customcode, modules.enabled AS moduleenabled, featurecodes.providedest FROM featurecodes INNER JOIN modules ON modules.modulename = featurecodes.modulename ORDER BY featurecodes.modulename, featurecodes.description
Trace Back
/var/www/html/admin/libraries/sql.functions.php:25 die_freepbx()
[0]: SELECT featurecodes.modulename, featurecodes.featurename, featurecodes.description AS featuredescription, featurecodes.enabled AS featureenabled, featurecodes.defaultcode, featurecodes.customcode, modules.enabled AS moduleenabled, featurecodes.providedest FROM featurecodes INNER JOIN modules ON modules.modulename = featurecodes.modulename ORDER BY featurecodes.modulename, featurecodes.description [nativecode=126 ** Incorrect key file for table ‘./asterisk/featurecodes.MYI’; try to repair it]SQL -
SELECT featurecodes.modulename, featurecodes.featurename, featurecodes.description AS featuredescription, featurecodes.enabled AS featureenabled, featurecodes.defaultcode, featurecodes.customcode, modules.enabled AS moduleenabled, featurecodes.providedest FROM featurecodes INNER JOIN modules ON modules.modulename = featurecodes.modulename ORDER BY featurecodes.modulename, featurecodes.description

/var/www/html/admin/libraries/featurecodes.functions.php:34 sql()
[0]: SELECT featurecodes.modulename, featurecodes.featurename, featurecodes.description AS featuredescription, featurecodes.enabled AS featureenabled, featurecodes.defaultcode, featurecodes.customcode, modules.enabled AS moduleenabled, featurecodes.providedest FROM featurecodes INNER JOIN modules ON modules.modulename = featurecodes.modulename ORDER BY featurecodes.modulename, featurecodes.description
[1]: getAll
[2]: 2

/var/www/html/admin/modules/featurecodeadmin/functions.inc.php:166 featurecodes_getAllFeaturesDetailed()

/var/www/html/admin/modules/featurecodeadmin/functions.inc.php:136 featurecodeadmin_destinations()

/var/www/html/admin/libraries/usage_registry.functions.php:145 featurecodeadmin_check_destinations()
[0]:

/var/www/html/admin/libraries/usage_registry.functions.php:243 framework_check_destination_usage()
[0]:
[1]:

/var/www/html/admin/modules/fax/functions.inc.php:103 framework_display_destination_usage()
[0]:

/var/www/html/admin/libraries/components.class.php:448 fax_configpageload()
[0]: extensions

/var/www/html/admin/config.php:283 component->processconfigpage()

Try:

mysqlcheck --repair --all-databases