greptile-apps[bot]
commented
1 month ago The issue appears to be related to a missing relation in the database schema. Specifically, the relation 'workspace_1tijfbhq4kpru5g3bwbr1anui.calendarEvent' does not exist. Here are the steps to resolve this:
-
Check Database Schema: Ensure that the
calendarEventtable exists in the specified workspace schema (workspace_1tijfbhq4kpru5g3bwbr1anui). -
Verify Entity Configuration: Confirm that the
CalendarEventWorkspaceEntityis correctly configured in/packages/twenty-server/src/modules/calendar/common/standard-objects/calendar-event.workspace-entity.ts. -
Update Schema if Necessary: If the table or relation is missing, update the database schema to include the
calendarEventtable. You may need to run migrations or manually create the table. -
Check Repository Usage: Ensure that the
calendarEventRepositoryis correctly injected and used in/packages/twenty-server/src/engine/core-modules/calendar/timeline-calendar-event.service.ts. -
Review GraphQL Queries: Verify that the GraphQL queries in
/packages/twenty-front/src/modules/activities/calendar/queries/getTimelineCalendarEventsFromPersonId.tsand/packages/twenty-front/src/modules/activities/calendar/queries/getTimelineCalendarEventsFromCompanyId.tsare correctly formed and match the expected schema.
By following these steps, you should be able to identify and resolve the issue with the missing timeline events.
References
/packages/twenty-server/src/engine/core-modules/calendar/timeline-calendar-event.resolver.ts /packages/twenty-server/src/engine/core-modules/calendar/timeline-calendar-event.service.ts /packages/twenty-server/src/engine/core-modules/calendar/dtos/timeline-calendar-event.dto.ts /packages/twenty-server/src/engine/core-modules/calendar/dtos/timeline-calendar-event-participant.dto.ts /packages/twenty-server/src/engine/core-modules/calendar/dtos/timeline-calendar-events-with-total.dto.ts /packages/twenty-front/src/modules/activities/calendar/queries/getTimelineCalendarEventsFromPersonId.ts /packages/twenty-front/src/modules/activities/calendar/queries/getTimelineCalendarEventsFromCompanyId.ts /packages/twenty-front/src/modules/activities/calendar/queries/fragments/timelineCalendarEventParticipantFragment.ts /packages/twenty-front/src/modules/activities/calendar/queries/fragments /packages/twenty-server/src/modules/calendar/repositories/calendar-event /packages/twenty-server/src/engine/core-modules/calendar/dtos
FelixMalfait
mnbro
Hi,
For all v0.21.x of twentycrm for Any selected object there is No Event in TimeLine.
I think is related to this:
GraphQLError:relation "workspace_1tijfbhq4kpru5g3bwbr1anui.calendarEvent" does not exist File "/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js", line 219, col 19, in PostgresQueryRunner.query throw new QueryFailedError_1.QueryFailedError(query, parameters, err); File "node:internal/process/task_queues", line 95, col 5, in process.processTicksAndRejections File "/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js", line 2192, col 25, in SelectQueryBuilder.loadRawResults const results = await queryRunner.query(sql, parameters, true); File "/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js", line 646, col 29, in SelectQueryBuilder.getRawMany const results = await this.loadRawResults(queryRunner); File "/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js", line 1979, col 26, in SelectQueryBuilder.executeEntitiesAndRawResults rawResults = await new SelectQueryBuilder(this.connection, queryRunner) File "/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js", line 684, col 29, in SelectQueryBuilder.getRawAndEntities const results = await this.executeEntitiesAndRawResults(queryRunner); File "/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js", line 750, col 25, in SelectQueryBuilder.getMany const results = await this.getRawAndEntities(); File "/app/packages/twenty-server/dist/src/engine/twenty-orm/repository/workspace.repository.js", line 24, col 24, in WorkspaceRepository.find const result = await manager.find(this.target, computedOptions); File "/app/packages/twenty-server/dist/src/engine/core-modules/calendar/timeline-calendar-event.service.js", line 43, col 34, in TimelineCalendarEventService.getCalendarEventsFromPersonIds const calendarEventIds = await this.calendarEventRepository.find({ File "/app/packages/twenty-server/dist/src/engine/core-modules/calendar/timeline-calendar-event.resolver.js", line 74, col 40, in TimelineCalendarEventResolver.getTimelineCalendarEventsFromPersonId const timelineCalendarEvents = await this.timelineCalendarEventService.getCalendarEventsFromPersonIds([Additional Info(I have no Google Account Integration configured):
query GetTimelineCalendarEventsFromPersonId($personId: UUID!, $page: Int!, $pageSize: Int!) { getTimelineCalendarEventsFromPersonId( personId: $personId page: $page pageSize: $pageSize ) { ...TimelineCalendarEventsWithTotalFragment __typename } } fragment TimelineCalendarEventsWithTotalFragment on TimelineCalendarEventsWithTotal { totalNumberOfCalendarEvents timelineCalendarEvents { ...TimelineCalendarEventFragment __typename } __typename } fragment TimelineCalendarEventFragment on TimelineCalendarEvent { id title description location startsAt endsAt isFullDay visibility participants { ...TimelineCalendarEventParticipantFragment __typename } __typename } fragment TimelineCalendarEventParticipantFragment on TimelineCalendarEventParticipant { personId workspaceMemberId firstName lastName displayName avatarUrl handle __typename }Do you need other related info?