Mysql> select count(*) from cdr; ERROR 1146 (42S02): Table 'asterisk.cdr' doesn't exist

General Help
1

hi,

this is a fresh install version FreePBX 2.11.0.24

why is that table no there?

please advise

thank you

2

Because you are looking in the wrong database, it is asteriskcdrdb not asterisk

1 Like
3

In the future you need to supply complete information.

There are literally hundreds if not thousands of ways you can install FreePBX. If you installed via anything other than the official distro figuring out why a table is missing means troubleshooting your install.

In this case you were looking in wrong DB.

In the future supply installation type and version, Asterisk version, FreePBX version, OS and Version and logs are helpful too.