Not Logged in - No Account?
Logging in allows you to post to forums, track new posts, subscribe to threads, pm (private message) other members, and receive periodic news letters. Once logged in this message disappears. No account? Create one by registering here. Lost your password, request a new password. We respect your privacy and collect minimal information when you register and we do not resell that information or use it in any objectionable way. You can review our privacy policy for details.
Under reports no calls but error messages
Hello,
Asterisk@Home version 1.5 when I try and see calls made under reports I get the following message. Does anyone know how to resolve this? There is 31gig left on the disk. Thanks in advance
Database error: Invalid SQL: SELECT calldate, channel, src, clid, dst, disposition, duration FROM cdr WHERE UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP('2008-09-01') ORDER BY calldate DESC LIMIT 0,25
MySQL Error: 1016 (Can't open file: 'cdr.MYD'. (errno: 145))
Database error: Invalid SQL: SELECT substring(calldate,1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP('2008-09-01') GROUP BY substring(calldate,1,10)
MySQL Error: 1016 (Can't open file: 'cdr.MYD'. (errno: 145))
Database error: Invalid SQL: SELECT count(*) FROM cdr WHERE UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP('2008-09-01')
MySQL Error: 1016 (Can't open file: 'cdr.MYD'. (errno: 145))
Database error: next_record called with no query pending.
MySQL Error: 1016 (Can't open file: 'cdr.MYD'. (errno: 145))
Error 145 means that the
Error 145 means that the table cdr is corrupt. This can be caused by using up all of your disk. Type df -h in a shell to see how much disk you have left.
There are only 10 types of people in the world: Those who understand binary, and those who don't
It is also recommended that
It is also recommended that you take a look at upgrading as you are running a VERY old version.
Along the lines of disk cleanup. I don't remember if 1.5 had backups but if it does go into the backups folder and delete the "Old" backup as there is no house cleaning done. Also review the /var/log/asterisk folder for log files. It is possible that your Full log has grown HUGE and never been rotated. If that is the case you can stop asterisk for a minute, delete the file and then start it again.