Apply Config won't run

Today I installed upgrades and now when I click Apply Config it gripes that:
“Reload failed because retrieve_conf encountered an error: 1”

When I click the More Info link I get:
exit: 1
found language dir fr for directory, not installed on system, skipping
found language dir en_UK for directorypro, not installed on system, skipping
found language dir en_UK for pagingpro, not installed on system, skipping
Added to globals: ASTETCDIR = /etc/asterisk
Added to globals: ASTMODDIR = /usr/lib/asterisk/modules
Added to globals: ASTVARLIBDIR = /var/lib/asterisk
Added to globals: ASTAGIDIR = /var/lib/asterisk/agi-bin
Added to globals: ASTSPOOLDIR = /var/spool/asterisk
Added to globals: ASTRUNDIR = /var/run/asterisk
Added to globals: ASTLOGDIR = /var/log/asterisk
Added to globals: CWINUSEBUSY = true
Added to globals: AMPMGRUSER = admin
Added to globals: AMPMGRPASS = amp111
Added to globals: AMPDBENGINE = mysql
Added to globals: AMPDBHOST = localhost
Added to globals: AMPDBNAME = asterisk
Added to globals: AMPDBUSER = freepbxuser
Added to globals: AMPDBPASS = U9PZZDRVVJPW
Added to globals: VMX_CONTEXT = from-internal
Added to globals: VMX_PRI = 1
Added to globals: VMX_TIMEDEST_CONTEXT =
Added to globals: VMX_TIMEDEST_EXT = dovm
Added to globals: VMX_TIMEDEST_PRI = 1
Added to globals: VMX_LOOPDEST_CONTEXT =
Added to globals: VMX_LOOPDEST_EXT = dovm
Added to globals: VMX_LOOPDEST_PRI = 1
Added to globals: MIXMON_DIR =
Added to globals: MIXMON_POST =
Added to globals: DIAL_OPTIONS = Ttr
Added to globals: TRUNK_OPTIONS = Tt
Added to globals: TRUNK_RING_TIMER = 300
Added to globals: MIXMON_FORMAT = wav
Added to globals: REC_POLICY = caller
Added to globals: RINGTIMER_DEFAULT = 15
Added to globals: TRANSFER_CONTEXT = from-internal-xfer
[FATAL] SELECT keyword, data, type, seq FROM sipsettings WHERE type != 1 AND type != 2 ORDER BY type, seq [nativecode=145 ** Table ‘./asterisk/sipsettings’ is marked as crashed and should be repaired]SQL -
SELECT keyword, data, type, seq FROM sipsettings WHERE type != 1 AND type != 2 ORDER BY type, seq

Trace Back:

/var/www/html/admin/libraries/sql.functions.php:25 die_freepbx()
[0]: SELECT keyword, data, type, seq FROM sipsettings WHERE type != 1 AND type != 2 ORDER BY type, seq [nativecode=145 ** Table ‘./asterisk/sipsettings’ is marked as crashed and should be repaired]SQL -
SELECT keyword, data, type, seq FROM sipsettings WHERE type != 1 AND type != 2 ORDER BY type, seq

/var/www/html/admin/modules/sipsettings/functions.inc.php:240 sql()
[0]: SELECT keyword, data, type, seq FROM sipsettings WHERE type != 1 AND type != 2 ORDER BY type, seq
[1]: getAll
[2]: 2

/var/www/html/admin/modules/sipsettings/functions.inc.php:91 sipsettings_get()
[0]: 1

/var/www/html/admin/libraries/BMO/DialplanHooks.class.php:79 sipsettings_hookGet_config()
[0]: asterisk

/var/lib/asterisk/bin/retrieve_conf:722 DialplanHooks->processHooks()
[0]: asterisk
[1]:

Repair your tables

mysqlcheck -r --all-databases

Andrew -

Yes, thank you! That fixed it, and I have my appetite back.

1 Like