disabled MFA after Update 0.16.4.4

[JulZerbe]

Greetings to the developer, it's already a great program. However, I have a problem.after updating to 0.16.4.4, I can't log in via MFA and have locked myself out. A potential issue was announced for previous updates, and I was able to disable MFA in the GUI. Unfortunately, this time the update was triggered automatically. The strange thing is that the recovery codes don't work either. How can I disable MFA in the Docker environments or via the console? I was able to create a new user by making changes in the environments, but I lack access to the existing data in the database. I can't find a solution at the moment and would be very grateful for any help.

[CodeWithCJ]

what version did you upgrade from? I had a script that should have disabled the MFA when auth was not stable when better-auth was introduced.

are you familiar with pgadmin ? if so, you can below query to disable it manually

--  RESET all MFA-related flags to false for a clean start
UPDATE "user" 
SET 
    two_factor_enabled = false,
    mfa_totp_enabled = false,
    mfa_email_enabled = false,
    mfa_enforced = false,
    email_mfa_code = NULL,
    email_mfa_expires_at = NULL;

-- Delete all configured TOTP secrets and backup codes
TRUNCATE TABLE "two_factor";

--  Disable global mandatory MFA policy for a truly fresh start
UPDATE "global_settings" SET mfa_mandatory = false WHERE id = 1;

[JulZerbe]

Hello, thank you for your feedback. The update is from version 0.16.4.3.
Unfortunately, I have no experience with pgAdmin. I wanted to avoid reinstalling sparkyfitness and had hoped to find a solution via the env.

[CodeWithCJ]

were you able to resolve it?
You need to expose DB port, connect to it using PG Admin and then execute those queries.

[JulZerbe]

Not really. I performed a complete reinstallation and added the env through SPARKY_FITNESS_ADMIN_EMAIL:
SPARKY_FITNESS_FORCE_EMAIL_LOGIN:,
which did not work in my previous installation. Now I have an admin account and can also customize the login better in the GUI. I also switched the login to oidc. Everything works perfectly.