Twenty•6mo ago

Unable to link to google mail/calendar after upgrading from v0.20.0 to v0.20.2

Hi Twenty team, congrats on the new minor release, it's looking great! After upgrading I have experienced one bug. I am no longer able to connect to google accounts to pull in my mail and calendar. This worked flawlessly before the upgrade. Now when I click "Connect with Google" I am taken to a google page to choose my account, i select my account and hit continue, then I approve the permissions and hit allow. At this stage I would usually be taken back to the twenty crm page, but instead I am receiving a 500 error and get the following error in my logs...

query failed: SELECT "calendarChannel"."handle" AS "calendarChannel_handle", "calendarChannel"."connectedAccountId" AS "calendarChannel_connectedAccountId", "calendarChannel"."syncStatus" AS "calendarChannel_syncStatus", "calendarChannel"."syncStage" AS "calendarChannel_syncStage", "calendarChannel"."visibility" AS "calendarChannel_visibility", "calendarChannel"."isContactAutoCreationEnabled" AS "calendarChannel_isContactAutoCreationEnabled", "calendarChannel"."isSyncEnabled" AS "calendarChannel_isSyncEnabled", "calendarChannel"."syncCursor" AS "calendarChannel_syncCursor", "calendarChannel"."syncStageStartedAt" AS "calendarChannel_syncStageStartedAt", "calendarChannel"."throttleFailureCount" AS "calendarChannel_throttleFailureCount", "calendarChannel"."id" AS "calendarChannel_id", "calendarChannel"."createdAt" AS "calendarChannel_createdAt", "calendarChannel"."updatedAt" AS "calendarChannel_updatedAt" FROM "workspace_6irr16qioalagnvc5ffeneuhx"."calendarChannel" "calendarChannel" WHERE "calendarChannel"."id" IN ($1) -- PARAMETERS: ["df63f93d-2a2f-4482-9424-67156dc53337"]
error: error: column calendarChannel.syncStatus does not exist

query failed: SELECT "calendarChannel"."handle" AS "calendarChannel_handle", "calendarChannel"."connectedAccountId" AS "calendarChannel_connectedAccountId", "calendarChannel"."syncStatus" AS "calendarChannel_syncStatus", "calendarChannel"."syncStage" AS "calendarChannel_syncStage", "calendarChannel"."visibility" AS "calendarChannel_visibility", "calendarChannel"."isContactAutoCreationEnabled" AS "calendarChannel_isContactAutoCreationEnabled", "calendarChannel"."isSyncEnabled" AS "calendarChannel_isSyncEnabled", "calendarChannel"."syncCursor" AS "calendarChannel_syncCursor", "calendarChannel"."syncStageStartedAt" AS "calendarChannel_syncStageStartedAt", "calendarChannel"."throttleFailureCount" AS "calendarChannel_throttleFailureCount", "calendarChannel"."id" AS "calendarChannel_id", "calendarChannel"."createdAt" AS "calendarChannel_createdAt", "calendarChannel"."updatedAt" AS "calendarChannel_updatedAt" FROM "workspace_6irr16qioalagnvc5ffeneuhx"."calendarChannel" "calendarChannel" WHERE "calendarChannel"."id" IN ($1) -- PARAMETERS: ["df63f93d-2a2f-4482-9424-67156dc53337"]
error: error: column calendarChannel.syncStatus does not exist

Can you please assist me to fix this error and enable google sync again? Thanks!!!

8 Replies

martmull•6mo ago

@charles probably related to the fix we made. Will check that very soon

RobOP•6mo ago

Thanks for taking a look @martmull and @charles (I am loving all the other fixes!!)

martmull•6mo ago

@Rob it is not linked to the fix we made. You probably need to sync your metadata (i imagine that you are self hosting isn't it?)

RobOP•6mo ago

Yes, I am self hosting. How do I sync my metadata? Is that a command to run on the docker container?

martmull•6mo ago

let me just confirm the command with @charles , but it should be npx nx run twenty-server:command workspace:sync-metadata

RobOP•6mo ago

Thank you! If I run that command it asks me to install nx. I hit no and will wait for you to confirm if I should hit yes or not. Thanks so much!

martmull•6mo ago

The proper command is: yarn command:prod workspace:sync-metadata -w WORKSPACE_ID -f we use to have a documentation on version upgrades but i cannot find it, @Félix maybe you know where is it?

RobOP•6mo ago

It works!!! Thanks @martmull !!!

Gaming

Programming

Unable to link to google mail/calendar after upgrading from v0.20.0 to v0.20.2