I installed FreePBX on Ubuntu 18.04 following the official guide. Now everythig is up and running and handling calls properly. Even CDR and CEL data are correclty stored into database, I’ve checked manually. CDR report module works perfectly, but CDR always throws the following 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
Call Event Logging version:188.8.131.52
What can I do to solve the issue ? Uninstalling and reinstalling module did not help, nor did downgrading.