github-starred/vaultwarden
2
0
Fork 0
mirror of https://github.com/dani-garcia/vaultwarden.git synced 2026-05-23 08:32:45 -05:00
Code Issues 307 Packages Projects Releases 83 Wiki Activity

Cannot run migration with sqlite 3.11.0 on Ubuntu #4173

New Issue
Closed
opened 2026-03-07 19:32:11 -06:00 by GiteaMirror · 2 comments
GiteaMirror commented 2026-03-07 19:32:11 -06:00
Owner
Copy Link

Originally created by @timaschew on GitHub (Dec 20, 2019).

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). 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`
GiteaMirror commented 2026-03-07 19:32:11 -06:00
Author
Owner
Copy Link

@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.
GiteaMirror commented 2026-03-07 19:32:11 -06:00
Author
Owner
Copy Link

@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!
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
better for forum
bug
documentation
duplicate
enhancement
future Vault
good first issue
help wanted
low priority
notes
pull-request
Mirrored from GitHub Pull Request
 question
SSO
Third party
troubleshooting
wontfix
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/vaultwarden#4173
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?