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


this is a fresh install version FreePBX

why is that table no there?

please advise

thank you

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

1 Like

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.