6 replies

[STRIPE] upgradeSubscription creating multiple database records

What's not working?

When using upgradeSubscription for a new user, i.e. a user with no existing subscription I get two idenitcle records in the

subscriptions

subscriptions

table varying only by the

id

id

column. I correctly only get on subscription in Stripe. Both are marked as

active

active

and have all the same timestamps.

If I then call upgradeSubscription again passing the Stripe subscription Id to upgrade to a new tier one of the records correctly updates, but the other doesn't.

Looking at the DB, I see one record is created in an incomplete state when the initial redirect to Stripe happens. The second record seems to pop into existence when the webhook triggers on completion of the Checkout session, but I can't be 100% sure.

Error messages

No error messages are shown in either the API or the webhook handler

How to reproduce

I'm using a basic Better-Auth install, I've seen this behavior both on the current release and the 1.5-beta.2 release. I'm using Neon and Prisma for the database and running a local NextJS app and Stripe webhook tunnel.

Here's a sample call that causes what I'm seeing:

      <Button onClick={async () => {
        "use server"

        const { url } = await auth.api.upgradeSubscription({
          headers: await nextHeaders(),
          body: {
            successUrl: '/app',
            plan: 'Crystal',
            annual: true,
          }
        })

        redirect(url as string)
      }}>Subscribe via Stripe dudes!</Button>

      <Button onClick={async () => {
        "use server"

        const { url } = await auth.api.upgradeSubscription({
          headers: await nextHeaders(),
          body: {
            successUrl: '/app',
            plan: 'Crystal',
            annual: true,
          }
        })

        redirect(url as string)
      }}>Subscribe via Stripe dudes!</Button>

Better Auth•2mo ago•

6 replies

themagoo_73

[STRIPE] upgradeSubscription creating multiple database records

What's not working?

When using upgradeSubscription for a new user, i.e. a user with no existing subscription I get two idenitcle records in the

subscriptions

subscriptions

table varying only by the

id

id

column. I correctly only get on subscription in Stripe. Both are marked as

active

active

Error messages

No error messages are shown in either the API or the webhook handler

How to reproduce

      <Button onClick={async () => {
        "use server"

        const { url } = await auth.api.upgradeSubscription({
          headers: await nextHeaders(),
          body: {
            successUrl: '/app',
            plan: 'Crystal',
            annual: true,
          }
        })

        redirect(url as string)
      }}>Subscribe via Stripe dudes!</Button>

      <Button onClick={async () => {
        "use server"

        const { url } = await auth.api.upgradeSubscription({
          headers: await nextHeaders(),
          body: {
            successUrl: '/app',
            plan: 'Crystal',
            annual: true,
          }
        })

        redirect(url as string)
      }}>Subscribe via Stripe dudes!</Button>

[STRIPE] upgradeSubscription creating multiple database records

What's not working?

Error messages

How to reproduce

Similar Threads

[STRIPE] upgradeSubscription creating multiple database records

What's not working?

Error messages

How to reproduce

Similar Threads

Similar Threads

Similar Threads