SQLite migration fails after updating to v2026.1.0 - missing column UseDisableSmAdsForUsers

[mattredact]

Steps To Reproduce

1. Run Bitwarden Lite with SQLite backend on a version prior to v2026.1.0
2. Pull latest image: docker pull ghcr.io/bitwarden/lite:latest
3. Restart the container: docker compose down && docker compose up -d
4. Open web vault and attempt to add a new vault item

Expected Result

Database migrations should run automatically during container startup and add any new required columns to the SQLite database.

Actual Result

Actual Result

Container starts successfully but operations fail with SQLite errors. Adding new vault items fails. The API log shows:

Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such column: o.UseDisableSmAdsForUsers'.

The application expects columns that don't exist in the database:

• UseDisableSmAdsForUsers
• UsePhishingBlocker
• UseRiskInsights

---

Screenshots or Videos

No response

Additional Context

This appears similar to #2744 where SQLite migrations failed to add new columns. The ValidateOrganizationsJob runs repeatedly and fails each time. Basic vault operations that touch the Organization table fail.

Full error from /var/log/bitwarden/api.log:

fail: Microsoft.EntityFrameworkCore.Database.Command[20102]
      Failed executing DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
fail: Microsoft.EntityFrameworkCore.Query[10100]
      An exception occurred while iterating over the results of a query for context type 'Bit.Infrastructure.EntityFramework.Repositories.DatabaseContext'.
      Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such column: o.UseDisableSmAdsForUsers'.
fail: Bit.Api.Jobs.ValidateOrganizationsJob[2]
      Error performing ValidateOrganizationsJob.

### Githash Version

edde53c1

### Environment Details

- **Deployment:** Bitwarden Lite (Docker)
- **Image:** `ghcr.io/bitwarden/lite:latest` (created 2026-01-22)
- **Host OS:** Linux Debian 13
- **Docker version:** 29.2.0, build 0b9d198

### Database Image

SQLite (`vault.db`) - using built-in SQLite, no external database container

### Issue Tracking Info

- [ ] I understand that work is tracked outside of Github. A PR will be linked to this issue should one be opened to address it, but Bitwarden doesn't use fields like "assigned", "milestone", or "project" to track progress.

[bitwarden-bot]

Thank you for reporting this issue! We've added this to our internal tracking system.
ID: PM-31489
Link (for internal use): https://bitwarden.atlassian.net/browse/PM-31489

[SergeantConfused]

Hello @mattredact,

Thank you for your report. I have flagged this to the Engineering department; please feel free to post additional information, such as screenshots or a screen video recordings, if you wish.

Thank you again,

[mattredact]

Hello @mattredact,

Thank you for your report. I have flagged this to the Engineering department; please feel free to post additional information, such as screenshots or a screen video recordings, if you wish.

Thank you again,

Cheers, thank you!