Page History

When accessing the web interface,  the error displayed in the picture below might appear. 

1. Interface error MySQL ERROR: Query error: 144 Table './voipnow/call_history#P#p2011010'
 

   This interface error is marked as crashed and last (automatic?) repair failed. To solve this, the call_history table must be repaired using the following command:

   Code Block
   repair table call_history;

2. Interface error MySQL ERROR: Query error: 1267 Illegal mix of collations (ascii_general_ci,IMPLICIT)
 

   In this case, it is very likely that something was pasted and unicode chars were being used.

   Note
   If this is the case, please contact Helpdesk and report this issue.

3. Possible disk space issue
    

   Verify you have enough free disk space (especially to the partition where /var/lib/mysql exists).

4. Interface error MySQL ERROR: Query error: 1728 Cannot load from mysql.proc.
   
   This appears due to failed upgrade. To solve this, run the following:

   Code Block
   /etc/voipnow/.sqldb

   then this:

   Code Block
   mysql_upgrade -u`cat /etc/voipnow/.sqldb|awk -F ":" '{print $2}'` -p`cat /etc/voipnow/.sqldb|awk -F ":" '{print $3}'`

   Note
   For any other reported error, please contact Helpdesk.