Reports not working

Discussion in 'General' started by skiet, Dec 1, 2009.

  1. skiet

    Joined:
    Dec 1, 2009
    Messages:
    8
    Likes Received:
    0
    Hi, When I go to reports I get the following error.

    SELECT substring(calldate,1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP('2009-12-01') GROUP BY substring(calldate,1,10) [nativecode=145 ** Table './asteriskcdrdb/cdr' is marked as crashed and should be repaired]

    Can someone help.

    Regards
     
  2. danguiano

    Joined:
    May 14, 2010
    Messages:
    3
    Likes Received:
    0
    did u solve the problem?
     
  3. razametal

    Joined:
    Jul 9, 2007
    Messages:
    33
    Likes Received:
    0
    To fix, use myisamchk.

    First stop mysqld service:

    service mysqld stop

    Then run:

    myisamchk -r /var/lib/mysql/asteriskcdrdb/*.MYI

    Then start mysql:

    service mysqld start

    done :) check the reports, must be working again.
     

Share This Page