Skip to content

fix(core): restore workspace.project_id for project ID remaps - #42169

Closed
DatScreamer wants to merge 4 commits into
anomalyco:devfrom
DatScreamer:fix/migrate-project-id-missing-column
Closed

fix(core): restore workspace.project_id for project ID remaps#42169
DatScreamer wants to merge 4 commits into
anomalyco:devfrom
DatScreamer:fix/migrate-project-id-missing-column

Conversation

@DatScreamer

@DatScreamer DatScreamer commented Aug 12, 2026 •
edited
Loading

Copy link
Copy Markdown

Issue for this PR

Closes #42170

Type of change

  • Bug fix
  • New feature
  • Refactor / code improvement
  • Documentation

What does this PR do?

Desktop crashed on session load with Error: no such column: project_id in Project.migrateProjectId.

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 500s and takes the renderer down.

This adds a migration that rebuilds the control-plane workspace table when project_id is missing, and skips the workspace remap if that column is still absent. Session remaps still run.

How did you verify your code works?

  • bun test test/database-migration.test.ts in packages/core
  • bun test test/project/project.test.ts in packages/opencode
  • Reproduced the crash against the local DB, then confirmed desktop boots and sessions load with this change

Screenshots / recordings

If this is a UI change, please include a screenshot or recording.

Checklist

  • I have tested my changes locally
  • I have not included unrelated changes in this PR

@DatScreamer
fix(core): restore workspace.project_id for project ID remaps
199b248 
Some builds replaced the workspace table with a provider/binding schema
and dropped project_id. Desktop then returned 500 from
Project.migrateProjectId while loading sessions.

Rebuild the control-plane workspace table when that column is missing,
and skip the workspace remap if it is still absent.
@github-actions github-actions Bot added needs:compliance This means the issue will auto-close after 2 hours. needs:issue labels Aug 12, 2026
@github-actions

github-actions Bot commented Aug 12, 2026

Copy link
Copy Markdown
Contributor

Thanks for your contribution!

This PR doesn't have a linked issue. All PRs must reference an existing issue.

Please:

  1. Open an issue describing the bug/feature (if one doesn't exist)
  2. Add Fixes #<number> or Closes #<number> to this PR description

See CONTRIBUTING.md for details.

@github-actions github-actions Bot removed the needs:compliance This means the issue will auto-close after 2 hours. label Aug 12, 2026
@github-actions

github-actions Bot commented Aug 12, 2026

Copy link
Copy Markdown
Contributor

Thanks for updating your PR! It now meets our contributing guidelines. 👍

@github-actions

github-actions Bot commented Sep 13, 2026

Copy link
Copy Markdown
Contributor

Automated PR Cleanup

Thank you for contributing to opencode.

Due to the high volume of PRs from users and AI agents, we periodically close older PRs using automated criteria so maintainers can focus review time on the most active and community-supported contributions.

This PR was closed because it matched the following cleanup criteria:

  • The PR was created more than 1 month ago
  • The PR had fewer than 2 positive reactions
  • Positive reactions are counted as thumbs-up, heart, celebration, or rocket reactions on the PR

PRs created within the last month are not affected by this cleanup.

If you believe this PR was closed incorrectly, or if you are still actively working on it, please leave a comment explaining why it should be reopened. A maintainer can review and reopen it if appropriate.

Thanks again for taking the time to contribute.

@github-actions github-actions Bot closed this Sep 13, 2026
@AAGavrilov AAGavrilov mentioned this pull request Oct 5, 2026
Closed
@igorjpimenta igorjpimenta mentioned this pull request Oct 19, 2026
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

@Hona Hona Awaiting requested review from Hona
@Brendonovich Brendonovich Awaiting requested review from Brendonovich

Assignees

No one assigned

Labels

automated-pr-cleanup

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

Desktop fails to load sessions: no such column: project_id

1 participant

@DatScreamer