Trying to access the web portal for first time and receive the following error:
SELECT data FROM module_xml WHERE id = ‘mod_serialized’ [nativecode=1194 ** Table ‘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=1194 ** Table ‘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:17 sql()
[0]: SELECT data FROM module_xml WHERE id = ‘mod_serialized’
[1]: getOne
I’m guessing the machine crashed whilst installing. It’s in a pretty precarious state, so the easiest option would be to just start again, especially if you haven’t done anything to it.
The error is saying that the freepbx_settings database is invalid. Another indication that the machine crashed before the installation was complete.
You can probably follow the manual installation instructions, but it will be much easier to do a reinstall. Who knows what else is incomplete?
Also, you probably want to find out WHY the machine crashed when it was installing. Maybe it has a hardware issue, in which case there’s no way you want to use it as your phone system 8)
I basically followed most of the manual install instructions.
The four key points:
Drop the existing databases first so they can be recreated properly
Be sure to use the DB password that is in freepbx.conf and not in the instructions
Install all modules using CLI. If there is an error because of a dependency, install the dependent module and then repeat this step until all modules are installed.
Once in GUI, check that modules are installed/active before performing update.
I had to enable commercial modules to install TTSEngines and CertMan Modules, but otherwise, I think everything is a go.
Now I just have to finish tweaking some things, but at least phone calls and be made and received.
I’d still be worried about the state of the machine. WHY did it crash? That’s an important thing to care about, as you don’t want it to randomly start rebooting when calls are going through it.