[GH-ISSUE #775] Cannot run migration with sqlite 3.11.0 on Ubuntu #534

New issue

Closed

opened 2026-03-03 01:30:16 +03:00 by kerem · 2 comments

kerem commented

2026-03-03 01:30:16 +03:00

Owner

Originally created by @timaschew on GitHub (Dec 20, 2019).
Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/775

I have sqlite3 version 3.11.0 (Ubuntu doesn't have any newer version) and all the migrations scrips where a column is renamed are not working (syntax error).

On StackOverflow I found this: https://stackoverflow.com/a/56260765/736518
So can I just rename the table and create a new one and copy the rows?

With these four steps you can manually change any SQLite table. Keep in mind that you will also need to recreate any indexes, viewers or triggers on the new table as well.

Do I need to recreate any indexes, viewers or triggers? If yes, how do I do this?

BTW: I've tried to install the Precompiled Binaries for Linux but could not execute them: bash: ./sqlite3: No such file or directory

Originally created by @timaschew on GitHub (Dec 20, 2019). Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/775 I have sqlite3 version 3.11.0 (Ubuntu doesn't have any newer version) and all the migrations scrips where a column is renamed are not working (syntax error). On StackOverflow I found this: https://stackoverflow.com/a/56260765/736518 So can I just rename the table and create a new one and copy the rows? > With these four steps you can manually change any SQLite table. Keep in mind that you will also need to recreate any indexes, viewers or triggers on the new table as well. Do I need to recreate any indexes, viewers or triggers? If yes, how do I do this? BTW: I've tried to install [the Precompiled Binaries for Linux](https://sqlite.org/download.html) but could not execute them: `bash: ./sqlite3: No such file or directory`

kerem closed this issue

2026-03-03 01:30:17 +03:00

kerem commented

2026-03-03 01:30:18 +03:00

Author

Owner

@dani-garcia commented on GitHub (Dec 23, 2019):

We are using a bundled SQLite version that supports that functionality, are you trying to run the scripts by hand? Bitwarden_rs runs them automatically.

@dani-garcia commented on GitHub (Dec 23, 2019): We are using a bundled SQLite version that supports that functionality, are you trying to run the scripts by hand? Bitwarden_rs runs them automatically.

kerem commented

2026-03-03 01:30:18 +03:00

Author

Owner

@timaschew commented on GitHub (Dec 23, 2019):

🤣 yes I've tried to run them manually.

Great then I will just upgrade the Dockerfile. Thanks!

@timaschew commented on GitHub (Dec 23, 2019): 🤣 yes I've tried to run them manually. Great then I will just upgrade the Dockerfile. Thanks!