[AsteriskBrasil] Erro emissão relatórios
jose
jasanchez em terra.com.br
Terça Junho 16 15:24:42 BRT 2009
Pessoal bom dia!!
Estou usando o Meucci da Digivoice e quando fui tirar um relatorio para minha surpresa deu todos esse erros ai abaixo, alguem tem alguma sugestaçao de como corrigir isso sem ter que formatar novamente o servidor??
Database error: Invalid SQL: SELECT calldate, channel, src, clid, dst, case disposition when "BUSY" then "Ocupado" when "ANSWERED" then "Atendido" when "NO ANSWER" then "N?o Atend." end as disposition, duration FROM cdr WHERE disposition = "ANSWERED" AND UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP('2009-06-01') AND UNIX_TIMESTAMP(calldate) <= UNIX_TIMESTAMP('2009-06-05 23:59:59') ORDER BY calldate DESC LIMIT 0,50
MySQL Error: 1194 (Table 'cdr' is marked as crashed and should be repaired)
Database error: Invalid SQL: SELECT substring(calldate,1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE disposition = "ANSWERED" AND UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP('2009-06-01') AND UNIX_TIMESTAMP(calldate) <= UNIX_TIMESTAMP('2009-06-05 23:59:59') GROUP BY substring(calldate,1,10)
MySQL Error: 1194 (Table 'cdr' is marked as crashed and should be repaired)
Database error: Invalid SQL: SELECT count(*) FROM cdr WHERE disposition = "ANSWERED" AND UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP('2009-06-01') AND UNIX_TIMESTAMP(calldate) <= UNIX_TIMESTAMP('2009-06-05 23:59:59')
MySQL Error: 1194 (Table 'cdr' is marked as crashed and should be repaired)
Database error: next_record called with no query pending.
MySQL Error: 1194 (Table 'cdr' is marked as crashed and should be repaired)
-------------- Próxima Parte ----------
Um anexo em HTML foi limpo...
URL: http://listas.asteriskbrasil.org/pipermail/asteriskbrasil/attachments/20090616/4cb4024c/attachment.htm
Mais detalhes sobre a lista de discussão AsteriskBrasil