Hi, I have a freepbx 14 install set up. Running on Ubuntu 18.04.
I do not know why Call Event Logging seems to not be working.
I used it in the past, but changed machine and after restore changed version from 13 to 14. Probably something wrong.
Everything else works peachy, no warning no errors in the interface nor elsewhere that I have noticed
It seems some php / mysql error, but I am not great in that regard.
Here is the error
SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column
‘asteriskcdrdb.cel.eventtime’ which is not in SELECT list; this is incompatible with DISTINCT
Tried error fixing in tables with fwconsole util tablefix
Tried “repair table cel” in mysql
The storage engine for the table doesn’t support repair