Update 4.4.1

[egi.zaberl]

After update from 4.3.1 to 4.4.1 i get this in espo log when i try to open Meeting or Call.

Espo.ERROR: API [GET]:/:controller, Params:Array ( [controller] => Meeting ) , InputData: - SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'date_start' in field list is ambiguous [] []
Espo.ERROR: Display Error: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'date_start' in field list is ambiguous, Code: 23000 URL: /api/v1/Meeting?maxSize=20&offset=0&sortBy=dateStart&asc=f alse [] []

What can i do?

Regards, Egi

[yuri]

Hi Egi,

What mysql version do you have?

[egi.zaberl]

5.6.28-0ubuntu0.15.04.1

mysql Ver 14.14 Distrib 5.6.28, for debian-linux-gnu (x86_64) using EditLine wrapper

[tanya]

Hello

Did you do any customization with Meeting? Could you attach custom/Espo/Custom/Resources/metadata/entityDefs/Meeting.json?

[egi.zaberl]

Nothing special. Just added some fields ...

[yuri]

Can you try the fix:

In application/Espo/Modules/Crm/Resources/metadata/entityDefs/Meeting.json

change

TIMESTAMPDIFF(SECOND, date_start, date_end)

to

TIMESTAMPDIFF(SECOND, meeting.date_start, meeting.date_end)

and clear cache. Please let me know if it worked.

[egi.zaberl]

Yeah! That did it! Thank you for your realy quick response and working fix!