Cannot run migration with sqlite 3.11.0 on Ubuntu #3168

New Issue

MrUnknownDE · 2026-04-06T04:38:28+02:00

MrUnknownDE commented

2026-04-06 04:38:28 +02:00

Originally created by @timaschew on 12/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 12/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`

MrUnknownDE closed this issue

2026-04-06 04:38:29 +02:00

Sign in to join this conversation.

No Label

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github/vaultwarden#3168