Unable to link to google mail/calendar after upgrading from v0.20.0 to v0.20.2 | Twenty | Page 1

atomic eagle Jun 25, 2024, 11:07 AM

#

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

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

hollow lance Jun 25, 2024, 11:24 AM

#

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

atomic eagle Jun 25, 2024, 11:34 AM

#

Thanks for taking a look @hollow lance and @verbal sandal (I am loving all the other fixes!!)

hollow lance Jun 25, 2024, 12:55 PM

#

@atomic eagle 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?)

atomic eagle Jun 25, 2024, 12:56 PM

#

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

hollow lance Jun 25, 2024, 12:59 PM

#

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

atomic eagle Jun 25, 2024, 12:59 PM

#

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!

hollow lance Jun 25, 2024, 1:08 PM

#

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, @safe tapir maybe you know where is it?

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