Vaultwarden fails to start after update – DB migration error (SSO)

[Teiluj]

This seems to fix the issue indeed - At least from my side, there was a table collection charset mismatch.
The other question is how it came to be.

[joseph]

@Teiluj this was a bug in vaultwarden a while go (which is why they maintain a wiki article on how to fix it up). https://github.com/search?q=repo%3Adani-garcia%2Fvaultwarden charset&type=issues

[p44]

Same problem here. Restored to 1.24.4 and stopped automatic updates.

[jdaviescoates]

I also had a not responding app and have reverted. Guess I need to look at that guide...

[p44]

@jdaviescoates @joseph Thanks for your advice. I followed this guide: https://github.com/dani-garcia/vaultwarden/wiki/Using-the-MariaDB-(MySQL)-Backend#foreign-key-errors-collation-and-charset and problem now is fixed.

thanks a lot

[BetaBreak]

Is there a step by step instruction to solve this issue, for me it is unclear how to fix this issue. Thanks!

[jayonrails]

The above posted link to the GitHub wiki seems to be the step by step instruction. Which is the part where you don't get forward?

[BetaBreak]

Thanks, when I run the queries I don't get out put..
Should I do it before upgrading, and or in recovery mode?

[james]

Hello @d19dotca @teiluj @ikalou @p44 @jdaviescoates @betabreak @jayonrails
This issue was discussed before, and I did create a handy script to fix the issue.
Please see: https://forum.cloudron.io/topic/14812/vaultwarden-fails-to-start-after-update-db-migration-error-sso/24?_=1778581136537

I have also merged this topic into the original topic so there is no duplicate.

[BetaBreak]

@james it works, thanks!

[james]

Hello @BetaBreak
Great to read that it resolved your issue.
Always happy to help.

If possible, give the solution I linked also an upvote to improve the forum search.