Call Log Fails for FreePBX 2.1.2 on Trixbox 1.2

General Help
1

** I fixed it myself but others still might not be so lucky **

After following the instructions on how to upgrade FreePBX I now have the following errors when I go to look at my Call Log Reports.

Database error: Invalid SQL: SELECT calldate, channel, src, clid, dst, disposition, duration FROM cdr WHERE UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP(‘2006-09-01’) ORDER BY calldate DESC LIMIT 0,25
MySQL Error: 1016 (Can’t open file: ‘cdr.MYI’ (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(‘2006-09-01’) GROUP BY substring(calldate,1,10)
MySQL Error: 1016 (Can’t open file: ‘cdr.MYI’ (errno: 145))
Database error: Invalid SQL: SELECT count() FROM cdr WHERE UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP(‘2006-09-01’)
MySQL Error: 1016 (Can’t open file: ‘cdr.MYI’ (errno: 145))
Database error: next_record called with no query pending.
MySQL Error: 1016 (Can’t open file: ‘cdr.MYI’ (errno: 145))

Anybody have a solution for this?

Here is a screen capture:

2

Since I had a backup that I created using the Backup & Restore module I just restored the Restore Call Detail Report and now everything is happy again. I lost my old data but at least its working now…

3

Either something’s locked that table, or it’s corrupt.

Got phpMyAdmin? Have a look at the database and see if you can do anything
with that table

-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Aaton
Sent: Friday, 22 September 2006 12:03 PM
To: [email protected]
Subject: [Amportal-users] Call Log Fails for FreePBX 2.1.2 on Trixbox 1.2

After following the instructions on how to upgrade FreePBX
(http://www.aussievoip.com/wiki/freePBX-UpgradeNeeded) I now have the
following errors when I go to look at my Call Log Reports.

Database error: Invalid SQL: SELECT calldate, channel, src, clid, dst,
disposition, duration FROM cdr WHERE UNIX_TIMESTAMP(calldate) >=
UNIX_TIMESTAMP(‘2006-09-01’) ORDER BY calldate DESC LIMIT 0,25
MySQL Error: 1016 (Can’t open file: ‘cdr.MYI’ (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(‘2006-09-01’) GROUP BY
substring(calldate,1,10)
MySQL Error: 1016 (Can’t open file: ‘cdr.MYI’ (errno: 145))
Database error: Invalid SQL: SELECT count() FROM cdr WHERE
UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP(‘2006-09-01’)
MySQL Error: 1016 (Can’t open file: ‘cdr.MYI’ (errno: 145))
Database error: next_record called with no query pending.
MySQL Error: 1016 (Can’t open file: ‘cdr.MYI’ (errno: 145))

Anybody have a solution for this?

Here is a screen capture:

Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net’s Techsay panel and you’ll get the chance to share your
opinions on IT & business topics through brief surveys – and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

Amportal-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amportal-users

Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net’s Techsay panel and you’ll get the chance to share your
opinions on IT & business topics through brief surveys – and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

Amportal-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amportal-users

Post generated using Mail2Forum (http://www.mail2forum.com)