The other day I was asked to check a hacked trunk in a pbx box. While I was digging through the logs the owner complaint that he couldn't use a tool from the pbx interface, the "Call Event Logging" tool because of some error.
The error was: "General error: 1194 Table 'cel' is marked as crashed and should be repairedFile:/var/www/html/admin/libraries/BMO/Database/PDOStatement.class.php:17"
That is a simple one error to fix, the cel table is in the asteriskcdrdb database:
mysql asteriskcdrdb
repair table cel;
That's all, the table was repaired
+-------------------+--------+----------+-----------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------------+--------+----------+-----------------------------------------------+
| asteriskcdrdb.cel | repair | info | Key 1 - Found wrong stored record at 27271156 |
| asteriskcdrdb.cel | repair | warning | Number of rows changed from 180284 to 180281 |
| asteriskcdrdb.cel | repair | status | OK |
+-------------------+--------+----------+-----------------------------------------------+
3 rows in set (4.98 sec)