Desktop fails to load sessions: no such column: project_id

[DatScreamer]

Description

Desktop 1.18.17 dies on launch while loading sessions. The sidecar returns 500 from Project.migrateProjectId:

Error: no such column: project_id

Some builds replaced the workspace table with a provider/binding schema and dropped project_id. Current dev still remaps project IDs with UPDATE workspace SET project_id = ..., which fails and takes the renderer down.

Plugins

No response

OpenCode version

1.18.17

Steps to reproduce

1. Have an OpenCode DB whose workspace table has provider/binding and no project_id (after a build that ran the workspace-domain migration).
2. Open Desktop 1.18.17 / current dev.
3. Session load returns 500 and the app shows a fatal renderer error.

Screenshot and/or share link

No response

Operating System

macOS

Terminal

Desktop app

[github-actions]

This issue might be a duplicate of existing issues. Please check:

• Desktop upgrade can fail on workspace migration #32430: Desktop upgrade can fail on workspace migration — also involves a workspace table migration failure with a "no such column" error during Desktop upgrades; the root cause and symptom are very similar to what you're describing.

[DatScreamer]

Not a duplicate. Same area, different bug.

Related family (workspace schema drift), not the same issue; do not close as a duplicate.