[GH-ISSUE #1647] sqlite: NOT NULL constraint failed: new_ciphers.name #1024

New issue

Closed

opened 2026-03-03 02:05:37 +03:00 by kerem · 2 comments

kerem commented

2026-03-03 02:05:37 +03:00

Owner

Originally created by @luckydonald on GitHub (Apr 30, 2021).
Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/1647

#1645, which was rudely closed and locked, so I'm sadly forced to create a new issue.

I am using (as stated in that already twice but apparently ignored) sqlite, not mysql. Those two are not the same thing, and sqlite was the default for quite some time and I think still is.

Therefore the SQL update proposed in https://github.com/dani-garcia/vaultwarden/discussions/1492#discussioncomment-544064 doesn't work.

# In bruceforce/bw_backup, as the vaultwarden one has no sqlite executable.
#  docker-compose exec bw_backup  sh

/ $ sqlite3 /data/db.sqlite3 
SQLite version 3.34.1 2021-01-20 14:10:07
Enter ".help" for usage hints.
sqlite> ALTER DATABASE `bitwarden_rs` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
Error: near "DATABASE": syntax error

Originally created by @luckydonald on GitHub (Apr 30, 2021). Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/1647 #1645, which was rudely closed and locked, so I'm sadly forced to create a new issue. I am using (as stated in that already twice but apparently ignored) **sqlite**, not mysql. Those two are not the same thing, and sqlite was the default for quite some time and I think still is. Therefore the SQL update proposed in https://github.com/dani-garcia/vaultwarden/discussions/1492#discussioncomment-544064 doesn't work. ```sh # In bruceforce/bw_backup, as the vaultwarden one has no sqlite executable. # docker-compose exec bw_backup sh / $ sqlite3 /data/db.sqlite3 SQLite version 3.34.1 2021-01-20 14:10:07 Enter ".help" for usage hints. sqlite> ALTER DATABASE `bitwarden_rs` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; Error: near "DATABASE": syntax error ```

kerem closed this issue

2026-03-03 02:05:37 +03:00

kerem commented

2026-03-03 02:05:38 +03:00

Author

Owner

@luckydonald commented on GitHub (Apr 30, 2021):

Okey, sorry.
I missed that GitHub discussion thing on the old ticket. I don't see the reason why that doesn't show that more prominently.
For me it just displayed that it was locked and closed.

@luckydonald commented on GitHub (Apr 30, 2021): Okey, sorry. I missed that GitHub discussion thing on the old ticket. I don't see the reason why that doesn't show that more prominently. For me it just displayed that it was locked and closed.

kerem commented

2026-03-03 02:05:38 +03:00

Author

Owner

@luckydonald commented on GitHub (Apr 30, 2021):

So this can now found here: https://github.com/dani-garcia/vaultwarden/discussions/1646#discussioncomment-679644

@luckydonald commented on GitHub (Apr 30, 2021): So this can now found here: https://github.com/dani-garcia/vaultwarden/discussions/1646#discussioncomment-679644