FreePBX Showing DB Error

Following is the error screen –

If you all the while no problem on FreePBX recording, and out of sudden not able to retrieve the  recording and shows “DB Error: Unknow error” , this mostly due to DB table corruptions, this can be fix using following –

mysql -h localhost -u asteriskuser -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.0.77 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>  USE asteriskcdrdb
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> optimize table cdr;

Done. You try again and it should work.