[GH-ISSUE #1488] Upgrade to new version 2.19 #981

New issue

Closed

opened 2026-03-03 02:05:16 +03:00 by kerem · 4 comments

kerem commented

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

Owner

Originally created by @gkl1368 on GitHub (Mar 15, 2021).
Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/1488

Running migration 20210311190243
BitWarden | Executing migration script 20210311190243/up.sql
BitWarden | [2021-03-15 10:39:46.977][bitwarden_rs::util][WARN] Can't connect to database, retrying: DieselMigError.
BitWarden | [CAUSE] QueryError(
BitWarden | DatabaseError(
BitWarden | __Unknown,
BitWarden | "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NOT NULL,\n password_hash BLOB,\n password_salt BLOB,\n password_iter...' at line 11",

I have this problem when I upgrade to 2.19，I use docker with MySQL. It work ok before update.

Originally created by @gkl1368 on GitHub (Mar 15, 2021). Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/1488 Running migration 20210311190243 BitWarden | Executing migration script 20210311190243/up.sql BitWarden | [2021-03-15 10:39:46.977][bitwarden_rs::util][WARN] Can't connect to database, retrying: DieselMigError. BitWarden | [CAUSE] QueryError( BitWarden | DatabaseError( BitWarden | __Unknown, BitWarden | "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'NOT NULL,\n password_hash BLOB,\n password_salt BLOB,\n password_iter...\' at line 11", I have this problem when I upgrade to 2.19，I use docker with MySQL. It work ok before update.

kerem closed this issue

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

kerem commented

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

Author

Owner

@BlackDex commented on GitHub (Mar 15, 2021):

Please check your database Collation.
See: https://github.com/dani-garcia/bitwarden_rs/issues/1305#issuecomment-774558466 for some info.
This could cause some strange issues when it has a different collation, it could very well be this issue.

@BlackDex commented on GitHub (Mar 15, 2021): Please check your database Collation. See: https://github.com/dani-garcia/bitwarden_rs/issues/1305#issuecomment-774558466 for some info. This could cause some strange issues when it has a different collation, it could very well be this issue.

kerem commented

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

Author

Owner

@dani-garcia commented on GitHub (Mar 15, 2021):

I think MySQL doesn’t allow using key as a column name, might need to rename it to akey like with the user table.

We’ll need to modify the existing MySQL migration and create two new ones for the other two.

@dani-garcia commented on GitHub (Mar 15, 2021): I think MySQL doesn’t allow using key as a column name, might need to rename it to akey like with the user table. We’ll need to modify the existing MySQL migration and create two new ones for the other two.

kerem commented

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

Author

Owner

@gkl1368 commented on GitHub (Mar 15, 2021):

I think MySQL doesn’t allow using key as a column name, might need to rename it to akey like with the user table.

We’ll need to modify the existing MySQL migration and create two new ones for the other two.

OK. I will wait for your modify. Thanks

@gkl1368 commented on GitHub (Mar 15, 2021): > I think MySQL doesn’t allow using key as a column name, might need to rename it to akey like with the user table. > > > > We’ll need to modify the existing MySQL migration and create two new ones for the other two. OK. I will wait for your modify. Thanks

kerem commented

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

Author

Owner

@gkl1368 commented on GitHub (Mar 16, 2021):

After upgrade to new docker image, it works. Thanks.

@gkl1368 commented on GitHub (Mar 16, 2021): After upgrade to new docker image, it works. Thanks.

kerem referenced this issue

2026-03-03 02:06:06 +03:00

[GH-ISSUE #1849] Organization — Two-step login enforcement doesn't work #1078