I fixed it, added a comment with what worked. Thanks for pointing me in the right direction!

Fixed this by setting totp_2fa_secret and totp_2fa_url to null in the postgres database for my local user!