FreePBX

jonathanb
Posts: 10
Member Since:
2007-04-23

My Asterisk box crashed and hasn't been right since. The freepbx module doesn't work and more and I get this error message.

FATAL ERROR
DB Error: no such table

So I reinstalled freepbx in the packages section and I got this error.

Checking for PEAR DB..OK
Checking for PEAR Console::Getopt..OK
Running module install.php and install.sql scripts
Checking for /etc/amportal.conf ..OK
Bootstrapping /etc/amportal.conf ..OK
Parsing /etc/amportal.conf ..OK
Parsing /etc/asterisk/asterisk.conf ..OK
Connecting to database..OK
Connecting to Asterisk manager interface..OK
[FATAL] SELECT grpnum, description FROM ringgroups ORDER BY CAST(grpnum as UNSIGNED) [nativecode1146 ** Table 'asterisk.ringgroups' doesn't exist]
Generating AMP configs..OK
Restarting Flash Operator Panel..OK
Checking recordings..
Module successfully installed
installed

I do not know linux at all but from what I gather I should be able to tell Mysql to fix the database. Or is there anouther whay to fix it. Any help is greatly appriciated thanks



jonathanb
Posts: 10
Member Since:
2007-04-23
I will prob upgrade my

I will prob upgrade my version as I am on 2.2. So now I just need to figure out the best way to migrate my settings.



datu503
Posts: 197
Member Since:
2007-06-06
Reinstalling is perhaps easier...

than to rebuilt the damaged freepbx.
You may wish to just download the 2.4 version and reinstall Trixbox from scratch and then BACKUP from your files, (that is hopefully you have a backup)

--

Walden, Certified FtoCC Admin & Tech
www.tech-r-us.com everythingIP
www.citivoip.com everythingVOIP



jonathanb
Posts: 10
Member Since:
2007-04-23
Yes enough to reconstuct it.

Yes enough to reconstuct it. damm server lol oww well.



ja133
Posts: 1881
Member Since:
2006-11-26
Please learn from this.

Please learn from this. Whoever is reading this: make sure you constantly backup FreePBX!! When something like this comes up, and you have no backup, you're going to need to start from scratch

--


New & Improved Site: trixbox Maintenance Guides



Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.