Call Event Logging seems to not be working.

[mapal123 (Belbel)]

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
File:/var/www/html/admin/modules/cel/Cel.class.php:349

• 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

hello

[jphilip (Philip Joseph)]

Hi,
Please make sure that you are using cel 14.0.2.X branch and your cel table has all the columns .

+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| id          | int(11)      | NO   | PRI | NULL    | auto_increment |
| eventtype   | varchar(30)  | NO   |     | NULL    |                |
| eventtime   | datetime     | NO   |     | NULL    |                |
| cid_name    | varchar(80)  | NO   |     | NULL    |                |
| cid_num     | varchar(80)  | NO   |     | NULL    |                |
| cid_ani     | varchar(80)  | NO   |     | NULL    |                |
| cid_rdnis   | varchar(80)  | NO   |     | NULL    |                |
| cid_dnid    | varchar(80)  | NO   |     | NULL    |                |
| exten       | varchar(80)  | NO   |     | NULL    |                |
| context     | varchar(80)  | NO   | MUL | NULL    |                |
| channame    | varchar(80)  | NO   |     | NULL    |                |
| appname     | varchar(80)  | NO   |     | NULL    |                |
| appdata     | varchar(255) | NO   |     | NULL    |                |
| amaflags    | int(11)      | NO   |     | NULL    |                |
| accountcode | varchar(20)  | NO   |     | NULL    |                |
| uniqueid    | varchar(32)  | NO   | MUL | NULL    |                |
| linkedid    | varchar(32)  | NO   | MUL | NULL    |                |
| peer        | varchar(80)  | NO   |     | NULL    |                |
| userdeftype | varchar(255) | NO   |     | NULL    |                |
| extra       | varchar(512) | NO   |     | NULL    |                |
+-------------+--------------+------+-----+---------+----------------+