Twenty CRM update on Cloudron fails – database schema mismatch (missing column)

[david.opalia]

Error logs

QueryFailedError: column core.workspace.useRecommendedModels does not exist
code: '42703'
routine: 'errorMissingColumn'

This happens during a query when checking user existence (CheckUserExists).

What I understand

It looks like the application expects new fields in the core.workspace table, but the database schema was not updated accordingly.

What I tried

I manually added one missing column:

ALTER TABLE core.workspace 
ADD COLUMN "enabledAiModelIds" jsonb;

But the app still fails due to another missing column:

useRecommendedModels

Additional issue

I tried to run migrations manually:

npm run typeorm migration:run

But the script does not exist.

[james]

Hello @david.opalia
The app is still marked as unstable.
We have recently made a big change to the app.
Could you please try to uninstall the app and install it again?

[david.opalia]

@james yes, it works.

After investigation, the issue appears to be related to a version gap:

Current instance version: 1.18
Upgrade attempted directly to 1.21
The system requires at least 1.20 for workspace migrations to proceed

As a result, at least one workspace (my unique workspace) seems to still be at a version below 1.20 (1.18 here), which blocks the global upgrade process.

@nebulon @james Going forward, could we consider performing updates step-by-step to avoid this kind of issue?

[james]

Hello @david.opalia

@david.opalia said:

@nebulon @james Going forward, could we consider performing updates step-by-step to avoid this kind of issue?

This is the case for all apps that are not marked as unstable.

Unstable apps are subjected to changes that can break the app. Like you have experienced here.
We do this with unstable apps so we can get them into a stable state as fast as possible.
Since there can be major issues with previous versions of an unstable app, a breaking version that gets us faster to a stable release is sometimes more efficient than handling the issues of the previous version into the next version and so on.