Upgrade vaultwarden 2024.6.2 to 2025.12.1 #6166

New Issue

GiteaMirror · 2026-03-07T20:53:26-06:00

GiteaMirror commented

2026-03-07 20:53:26 -06:00

Originally created by @DFO-WAT on GitHub (Jan 20, 2026).

Prerequisites

I have searched the existing Closed AND Open Issues AND Discussions
I have searched and read the documentation

Vaultwarden Support String

NO DIAG

Vaultwarden Build Version

2024.6.2 + 2025.12.1

Deployment method

Official Container Image

Custom deployment method

No response

Reverse Proxy

NGINX

Host/Server Operating System

Linux

Operating System Version

Debian 12.13 + Docker 5

Clients

Web Vault

Client Version

No response

Steps To Reproduce

Go to '...'
Click on '....'
Scroll down to '....'
Click on '...'
Etc '...'

Expected Result

Hello
I don't know if I chose the right type of object (bug, discussion) please excuse me in advance.

First of all, thank you for your work, it's really great!

Sorry if my English isn't perfect, I'm using a translation.

I wanted to try updating my Vaultwarden from version 2024.6.2 to the latest 2025.12.1 (I know... why I waited so long... lack of time).

I wanted to keep it simple: a fresh install of Vaultwarden with a backup/import from the MariaDB backup, but I'm having a problem when I try to import it (character collapse issue). I've tried modifying it, but it doesn't change anything, or maybe I'm missing something.

I could really use a little help; that would be great.

Thank you!

MariaDB [(none)]> SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = "vaultwarden";
+----------------------------+------------------------+
| DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME |
+----------------------------+------------------------+
| utf8mb4 | utf8mb4_unicode_ci |
+----------------------------+------------------------+

Mix with utf8mb4_unicode_ci and utf8mb4_uca1400_ai_ci,
how do I modify all the tables?

When I try to import the dump, I get this error.:

CREATE TABLE `attachments` (
`id` char(36) NOT NULL,
`cipher_uuid` char(36) NOT NULL,
`file_name` text NOT NULL,
`file_size` bigint(20) NOT NULL,
`akey` text DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `cipher_uuid` (`cipher_uuid`),
CONSTRAINT `attachments_ibfk_1` FOREIGN KEY (`cipher_uuid`) REFERENCES `ciphers` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

ERROR 1005 (HY000) at line 104: Can't create table vaultwarden.attachments (errno: 150 "Foreign key constraint is incorrectly formed")

I tried modifying the charset and collapse settings, but I must have missed something.

Actual Result

Hello
I don't know if I chose the right type of object (bug, discussion) please excuse me in advance.

First of all, thank you for your work, it's really great!

Sorry if my English isn't perfect, I'm using a translation.

I wanted to try updating my Vaultwarden from version 2024.6.2 to the latest 2025.12.1 (I know... why I waited so long... lack of time).

I wanted to keep it simple: a fresh install of Vaultwarden with a backup/import from the MariaDB backup, but I'm having a problem when I try to import it (character collapse issue). I've tried modifying it, but it doesn't change anything, or maybe I'm missing something.

I could really use a little help; that would be great.

Thank you!

MariaDB [(none)]> SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = "vaultwarden";
+----------------------------+------------------------+
| DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME |
+----------------------------+------------------------+
| utf8mb4 | utf8mb4_unicode_ci |
+----------------------------+------------------------+

Mix with utf8mb4_unicode_ci and utf8mb4_uca1400_ai_ci,
how do I modify all the tables?

When I try to import the dump, I get this error.:

CREATE TABLE `attachments` (
`id` char(36) NOT NULL,
`cipher_uuid` char(36) NOT NULL,
`file_name` text NOT NULL,
`file_size` bigint(20) NOT NULL,
`akey` text DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `cipher_uuid` (`cipher_uuid`),
CONSTRAINT `attachments_ibfk_1` FOREIGN KEY (`cipher_uuid`) REFERENCES `ciphers` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

ERROR 1005 (HY000) at line 104: Can't create table vaultwarden.attachments (errno: 150 "Foreign key constraint is incorrectly formed")

I tried modifying the charset and collapse settings, but I must have missed something.

Logs

Screenshots or Videos

No response

Additional Context

No response

Originally created by @DFO-WAT on GitHub (Jan 20, 2026). ### Prerequisites - [x] I have searched the existing **Closed _AND_ Open** [Issues](https://github.com/dani-garcia/vaultwarden/issues?q=is%3Aissue%20) **_AND_** [Discussions](https://github.com/dani-garcia/vaultwarden/discussions?discussions_q=) - [x] I have searched and read the [documentation](https://github.com/dani-garcia/vaultwarden/wiki/) ### Vaultwarden Support String NO DIAG ### Vaultwarden Build Version 2024.6.2 + 2025.12.1 ### Deployment method Official Container Image ### Custom deployment method _No response_ ### Reverse Proxy NGINX ### Host/Server Operating System Linux ### Operating System Version Debian 12.13 + Docker 5 ### Clients Web Vault ### Client Version _No response_ ### Steps To Reproduce 1. Go to '...' 2. Click on '....' 3. Scroll down to '....' 4. Click on '...' 5. Etc '...' ### Expected Result Hello I don't know if I chose the right type of object (bug, discussion) please excuse me in advance. First of all, thank you for your work, it's really great! Sorry if my English isn't perfect, I'm using a translation. I wanted to try updating my Vaultwarden from version 2024.6.2 to the latest 2025.12.1 (I know... why I waited so long... lack of time). I wanted to keep it simple: a fresh install of Vaultwarden with a backup/import from the MariaDB backup, but I'm having a problem when I try to import it (character collapse issue). I've tried modifying it, but it doesn't change anything, or maybe I'm missing something. I could really use a little help; that would be great. Thank you! MariaDB [(none)]> SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = "vaultwarden"; +----------------------------+------------------------+ | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | +----------------------------+------------------------+ | utf8mb4 | utf8mb4_unicode_ci | +----------------------------+------------------------+ MariaDB [(none)]> SELECT CHARACTER_SET_NAME, COLLATION_NAME FROM information_schema.`COLUMNS` WHERE TABLE_SCHEMA = "vaultwarden" AND CHARACTER_SET_NAME IS NOT NULL; +--------------------+-----------------------+ | CHARACTER_SET_NAME | COLLATION_NAME | +--------------------+-----------------------+ | utf8mb4 | utf8mb4_uca1400_ai_ci | | utf8mb4 | utf8mb4_uca1400_ai_ci | | utf8mb4 | utf8mb4_uca1400_ai_ci | | utf8mb4 | utf8mb4_uca1400_ai_ci | | utf8mb4 | utf8mb4_uca1400_ai_ci | | utf8mb4 | utf8mb4_uca1400_ai_ci | | utf8mb4 | utf8mb4_unicode_ci | Mix with utf8mb4_unicode_ci and utf8mb4_uca1400_ai_ci, how do I modify all the tables? When I try to import the dump, I get this error.: CREATE TABLE `attachments` ( `id` char(36) NOT NULL, `cipher_uuid` char(36) NOT NULL, `file_name` text NOT NULL, `file_size` bigint(20) NOT NULL, `akey` text DEFAULT NULL, PRIMARY KEY (`id`), KEY `cipher_uuid` (`cipher_uuid`), CONSTRAINT `attachments_ibfk_1` FOREIGN KEY (`cipher_uuid`) REFERENCES `ciphers` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci -------------- ERROR 1005 (HY000) at line 104: Can't create table `vaultwarden`.`attachments` (errno: 150 "Foreign key constraint is incorrectly formed") I tried modifying the charset and collapse settings, but I must have missed something. ### Actual Result Hello I don't know if I chose the right type of object (bug, discussion) please excuse me in advance. First of all, thank you for your work, it's really great! Sorry if my English isn't perfect, I'm using a translation. I wanted to try updating my Vaultwarden from version 2024.6.2 to the latest 2025.12.1 (I know... why I waited so long... lack of time). I wanted to keep it simple: a fresh install of Vaultwarden with a backup/import from the MariaDB backup, but I'm having a problem when I try to import it (character collapse issue). I've tried modifying it, but it doesn't change anything, or maybe I'm missing something. I could really use a little help; that would be great. Thank you! MariaDB [(none)]> SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = "vaultwarden"; +----------------------------+------------------------+ | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | +----------------------------+------------------------+ | utf8mb4 | utf8mb4_unicode_ci | +----------------------------+------------------------+ MariaDB [(none)]> SELECT CHARACTER_SET_NAME, COLLATION_NAME FROM information_schema.`COLUMNS` WHERE TABLE_SCHEMA = "vaultwarden" AND CHARACTER_SET_NAME IS NOT NULL; +--------------------+-----------------------+ | CHARACTER_SET_NAME | COLLATION_NAME | +--------------------+-----------------------+ | utf8mb4 | utf8mb4_uca1400_ai_ci | | utf8mb4 | utf8mb4_uca1400_ai_ci | | utf8mb4 | utf8mb4_uca1400_ai_ci | | utf8mb4 | utf8mb4_uca1400_ai_ci | | utf8mb4 | utf8mb4_uca1400_ai_ci | | utf8mb4 | utf8mb4_uca1400_ai_ci | | utf8mb4 | utf8mb4_unicode_ci | Mix with utf8mb4_unicode_ci and utf8mb4_uca1400_ai_ci, how do I modify all the tables? When I try to import the dump, I get this error.: CREATE TABLE `attachments` ( `id` char(36) NOT NULL, `cipher_uuid` char(36) NOT NULL, `file_name` text NOT NULL, `file_size` bigint(20) NOT NULL, `akey` text DEFAULT NULL, PRIMARY KEY (`id`), KEY `cipher_uuid` (`cipher_uuid`), CONSTRAINT `attachments_ibfk_1` FOREIGN KEY (`cipher_uuid`) REFERENCES `ciphers` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci -------------- ERROR 1005 (HY000) at line 104: Can't create table `vaultwarden`.`attachments` (errno: 150 "Foreign key constraint is incorrectly formed") I tried modifying the charset and collapse settings, but I must have missed something. ### Logs ```text ``` ### Screenshots or Videos _No response_ ### Additional Context _No response_

GiteaMirror added the bug label 2026-03-07 20:53:26 -06:00

GiteaMirror closed this issue