search

kind-work / two-fa

Two Factor Login for Statamic V3
https://statamic.com/marketplace/addons/2fa
Other
3 stars 5 forks source link

Migration issue with SQLite and PostgreSQL databases #31

Closed henrikawl closed 2 years ago

henrikawl commented 2 years ago

There seems a migration issue with SQLite and PostgreSQL databases, which seems connected to 2FA column. SQLite and PostgreSQL databases have restrictions starting column names with digits which I guess leads this issue. This is the error I get when running a migration which tries to update users table SQLSTATE[HY000]: General error: 1 unrecognized token: "2FA"

jcohlmeyer commented 2 years ago

Thanks for letting me know. I don't personally store my users in a DB. I will take a look into providing a solution soon for this soon.

jcohlmeyer commented 2 years ago

@henrikawl, sorry for the delay with this fix. There is now a fix for this issue with v2.0.0-beta.1; if you could test this and get back to me if it works or if you have any issues, that would be great.

Thanks, Jonathan