Announcement

Collapse
No announcement yet.

Update 4.4.1

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Update 4.4.1

    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

  • #2
    Hi Egi,

    What mysql version do you have?

    Comment


    • #3
      5.6.28-0ubuntu0.15.04.1

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

      Comment


      • #4
        Hello

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

        Comment


        • #5
          Nothing special. Just added some fields ...
          Attached Files

          Comment


          • #6
            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.

            Comment


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

              Comment

              Working...
              X