It just stopped working

now shows type error

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘asterisk.freepbx_settings’ doesn’t exist in file /var/www/html/admin/libraries/BMO/Config.class.php on line 218

I checked the database and saw that all tables were corrupted.

MariaDB [asterisk]> check table zulu_tokens;
+----------------------+-------+----------+--------------------------------------------+
| Table                | Op    | Msg_type | Msg_text                                   |
+----------------------+-------+----------+--------------------------------------------+
| asterisk.zulu_tokens | check | Error    | Table 'asterisk.zulu_tokens' doesn't exist |
| asterisk.zulu_tokens | check | status   | Operation failed                           |
+----------------------+-------+----------+--------------------------------------------+
2 rows in set (0.00 sec)

MariaDB [asterisk]> repair table zulu_tokens;
+----------------------+--------+----------+--------------------------------------------+
| Table                | Op     | Msg_type | Msg_text                                   |
+----------------------+--------+----------+--------------------------------------------+
| asterisk.zulu_tokens | repair | Error    | Table 'asterisk.zulu_tokens' doesn't exist |
| asterisk.zulu_tokens | repair | status   | Operation failed                           |
+----------------------+--------+----------+--------------------------------------------+
2 rows in set (0.00 sec)

is possible to recreate the asterisk database? and how to this do it?

P.S. I don’t need data. I need just need a working PBX with a web interface and settings

Do you have recent backups? (using FreePBX Backup & Restore module)

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.