Announcement

Collapse
No announcement yet.

AdvancedPack Meeting -> parent

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

  • AdvancedPack Meeting -> parent

    Hello Teams,
    strange :
    advancedPack 2.4.1

    i have meeting outOfBox with some basic custom field .

    i create a grid report with just "parent" as group .. and count:
    - on demo2.espocrm.com : good no problem
    - on another espoCrm where i work : good no problem
    - on my espoCrm : "Espo.ERROR: (500) ORM: Repository '' does not exist.; GET /api/v1/Report/action/run?id=5de97fa4d8746ba5d&where=; line: 165, file: /home/crm/public_html/application/Espo/ORM/EntityManager.php "

    Any idea ? where i can look ? entityDefs is good for me.

    Regards





  • #2
    Hello,
    please provide the steps to reproduce, and a whole error log's records that linked to this issue.

    Comment


    • #3
      Hello Maximus,
      nothing special...and parent is always custom entity type Person. (maybe this, because in other instance of espoCRM..parent it's outOfBox entity)

      and error "[2019-12-05 22:26:46] Espo.ERROR: (500) ORM: Repository '' does not exist.; GET /api/v1/Report/action/run?id=5de97fa4d8746ba5d&where=; line: 165, file: /home/crm/public_html/application/Espo/ORM/EntityManager.php [] []
      [2019-12-05 22:26:57] Espo.ERROR: (500) ORM: Repository '' does not exist.; GET /api/v1/Report/action/run?id=5de97fa4d8746ba5d&where=; line: 165, file: /home/crm/public_html/application/Espo/ORM/EntityManager.php [] []"

      Strange, if you can say me where i can look ?
      Another help : one instance of espoCRM (before split extension without VoIP) .. other instance : splitted extension (Advanced, outlook, VoiP)

      Regards

      Comment


      • #4
        Hello Maximus,
        found the problem
        some data where imported from another crm provider .. so sometime i have meeting without data in "parentType" but data in "parentID".
        the sql is perfect (i have put log on report.php line 1805) ..
        PHP Code:
        SELECT YEAR(CONVERT_TZ(meeting.date_end'+00:00''+01:00')) AS `YEAR:TZ:(dateEnd,1)`, meeting.parent_type AS `parentType`, meeting.parent_id AS `parentId`, COUNT(meeting.id) AS `COUNT:idFROM `meetingWHERE (((meeting.parent_id IS NOT NULL) AND (meeting.parent_type 'CustomEntity'))) AND meeting.deleted '0' GROUP BY YEAR(CONVERT_TZ(meeting.date_end'+00:00''+01:00')), meeting.parent_idmeeting.parent_type 

        so i have make a update empty "parentType" by "customEntity" .. and have "parent" in report => give "error 500". => seek bad id in bad entity i suppose. (this is out of my competence ) but certainly because parentType and parentId
        when a remove "parent" .. report is OK and rendered.

        Thanks you



        Comment

        Working...
        X