Reports not working

skiet

Joined
Dec 1, 2009
Messages
8
Likes
0
Points
0
#1
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
 

danguiano

Joined
May 14, 2010
Messages
3
Likes
0
Points
0
#2
did u solve the problem?
 

razametal

Joined
Jul 9, 2007
Messages
33
Likes
0
Points
0
#3
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.
 

Members online

No members online now.

Latest posts

Forum statistics

Threads
30,915
Messages
130,920
Members
17,595
Latest member
feparra121
Top