6 replies

How to update the 'phoneVerified' field in authAccounts table after a successful phone verification?

I implemented the Twilio phone provider example as showed here: https://github.com/get-convex/convex-auth-example/blob/main/convex/otp/TwilioVerify.ts

The phone number and later the code (OTP) verification is working without an issue and a user (if not existing) and also an account are successfully created.

However I've noticed that in the

authAccounts

authAccounts

authAccounts

authAccounts table, the

phoneVerified

phoneVerified

phoneVerified

phoneVerifiedremains to be set to

unset

unset

unset

unsetvalue, which of course it shouldn't be, because I made sure that the phone is verified.

I have tried using the following code to update, but it only updates the

user

user

table accordingly:

    const { user } = await createAccount(ctx, {
      provider: "phone",
      account: {
        id: phone,
      },
      profile: {
        phone,
        isAnonymous: false,
        phoneVerificationTime: Date.now(),
      },
      shouldLinkViaPhone: true,
    });

    const { user } = await createAccount(ctx, {
      provider: "phone",
      account: {
        id: phone,
      },
      profile: {
        phone,
        isAnonymous: false,
        phoneVerificationTime: Date.now(),
      },
      shouldLinkViaPhone: true,
    });

    const { user } = await createAccount(ctx, {
      provider: "phone",
      account: {
        id: phone,
      },
      profile: {
        phone,
        isAnonymous: false,
        phoneVerificationTime: Date.now(),
      },
      shouldLinkViaPhone: true,
    });

    const { user } = await createAccount(ctx, {
      provider: "phone",
      account: {
        id: phone,
      },
      profile: {
        phone,
        isAnonymous: false,
        phoneVerificationTime: Date.now(),
      },
      shouldLinkViaPhone: true,
    });

As in the example code is also described, this implementation uses