Call Event Logging mysql or php error

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

  • Tried to reinstall Call Event logging module

Error persists !!!

Any help would be greatly appreciated


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.