Asterisk foci error in freepbx_ Fatal error: Call to undefined function: numrows() in /var/www/html/admin/cdr/lib/Class.Table.php on line 85

Cause: the full file was deleted.

Troubleshooting: Go to /var/log/asterisk/

cd /var/log/asterisk

Solution: Run the ff:

touch full

chown asterisk:asterisk full

Access the mysql via command:

mysql -u root -p

At the console of mysql:

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| astercrm |
| asterisk |
| asteriskcdrdb |
| asteriskrealtime |
| default_IVRTracker |
| endpoints |
| mysql |
| queuemetrics |
| sugarcrm |
| sugarcrm.old |
| tbl_ivrtracker-bak |
| teleyapper |
| test |
+--------------------+
13 rows in set (0.00 sec)

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> show tables;
+-------------------------+
| Tables_in_asteriskcdrdb |
+-------------------------+
| cdr |
+-------------------------+
1 row in set (0.00 sec)

mysql> select * from cdr;
ERROR 1016 (HY000): Can't open file: 'cdr.MYI' (errno: 144)

Repair the table cdr:

 mysql> repair table cdr;
+-------------------+--------+----------+------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------------+--------+----------+------------------------------------------------+
| asteriskcdrdb.cdr | repair | warning | Number of rows changed from 2576744 to 5794538 |
| asteriskcdrdb.cdr | repair | status | OK |
+-------------------+--------+----------+------------------------------------------------+
2 rows in set (9 min 7.34 sec)


The reports now are okay. There is no error anymore!