Freepbx GUI not connecting: FATAL ERROR

For nearly a month I have been receiving this error and can’t connect to my freePBX GUI:

FATAL ERROR

SELECT data FROM module_xml WHERE id = ‘mod_serialized’ [nativecode=145 ** Table ‘./asterisk/module_xml’ is marked as crashed and should be repaired]SQL -
SELECT data FROM module_xml WHERE id = ‘mod_serialized’

Trace Back

/var/www/html/admin/libraries/sql.functions.php:25 die_freepbx()
[0]: SELECT data FROM module_xml WHERE id = ‘mod_serialized’ [nativecode=145 ** Table ‘./asterisk/module_xml’ is marked as crashed and should be repaired]SQL -
SELECT data FROM module_xml WHERE id = ‘mod_serialized’

/var/www/html/admin/libraries/modulelist.class.php:19 sql()
[0]: SELECT data FROM module_xml WHERE id = ‘mod_serialized’
[1]: getOne

/var/www/html/admin/libraries/modulelist.class.php:12 modulelist->modulelist()
[0]: freepbx_db_mysql: (phptype=mysql, dbsyntax=mysql) [connected]

/var/www/html/admin/libraries/modulefunctions.class.php:602 modulelist::create()
[0]: freepbx_db_mysql: (phptype=mysql, dbsyntax=mysql) [connected]

/var/www/html/admin/libraries/utility.functions.php:1312 module_functions->getinfo()
[0]:
[1]: 2

/var/www/html/admin/libraries/utility.functions.php:1287 _bootstrap_parse_hooks()

/var/www/html/admin/bootstrap.php:167 bootstrap_include_hooks()
[0]: pre_module_load
[1]: all_mods

/etc/freepbx.conf:9 require_once()
[0]: /var/www/html/admin/bootstrap.php

/var/www/html/admin/config.php:99 include_once()
[0]: /etc/freepbx.conf

The answer is right there.

mysqlcheck --auto-repair --check --all-databases

Thanks a lot, Andrew. I should have mentioned my problem earlier. It’s sorted like charm. Cheers.

1 Like