Unable to sign up using email / password

I keep getting this error when I sign up using email password in my next.js app

TypeError: The "payload" argument must be of type object. Received null
    at async signUpAction (actions/auth.ts:26:17)
  24 | export async function signUpAction(formData: FormData) {
  25 |   try {
> 26 |     const data = await auth.api.signUpEmail({
     |                 ^
  27 |       body: {
  28 |         name: formData.get("name") as string,
  29 |         email: formData.get("email") as string, {
  code: 'ERR_INVALID_ARG_TYPE'
}
 POST /sign-up 200 in 660ms

TypeError: The "payload" argument must be of type object. Received null
    at async signUpAction (actions/auth.ts:26:17)
  24 | export async function signUpAction(formData: FormData) {
  25 |   try {
> 26 |     const data = await auth.api.signUpEmail({
     |                 ^
  27 |       body: {
  28 |         name: formData.get("name") as string,
  29 |         email: formData.get("email") as string, {
  code: 'ERR_INVALID_ARG_TYPE'
}
 POST /sign-up 200 in 660ms

auth.ts

export const auth = betterAuth({
  database: prismaAdapter(db, {
    provider: "postgresql",
  }),
  // baseURL,
  emailAndPassword: {
    enabled: true,
  },
  plugins: [nextCookies()],
})

export const auth = betterAuth({
  database: prismaAdapter(db, {
    provider: "postgresql",
  }),
  // baseURL,
  emailAndPassword: {
    enabled: true,
  },
  plugins: [nextCookies()],
})

db.ts

const projectDir = process.cwd()
loadEnvConfig(projectDir)
neonConfig.webSocketConstructor = WebSocket
const connectionString = `${env.DATABASE_URL}`

const pool = new Pool({ connectionString })
const adapter = new PrismaNeon(pool)
export const db = new PrismaClient({ adapter })

const projectDir = process.cwd()
loadEnvConfig(projectDir)
neonConfig.webSocketConstructor = WebSocket
const connectionString = `${env.DATABASE_URL}`

const pool = new Pool({ connectionString })
const adapter = new PrismaNeon(pool)
export const db = new PrismaClient({ adapter })

23 Replies

roguesherlockOP•3mo ago

schema.prisma

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

model User {
  id            String    @id
  email         String    @unique
  password_hash String
  createdAt     DateTime  @default(now())
  updatedAt     DateTime  @updatedAt
  name          String
  emailVerified Boolean
  image         String?
  sessions      Session[]
  accounts      Account[]

  @@map("user")
}

model Session {
  id        String   @id
  expiresAt DateTime
  token     String
  createdAt DateTime
  updatedAt DateTime
  ipAddress String?
  userAgent String?
  userId    String
  user      User     @relation(fields: [userId], references: [id], onDelete: Cascade)

  @@unique([token])
  @@map("session")
}

model Account {
  id                    String    @id
  accountId             String
  providerId            String
  userId                String
  user                  User      @relation(fields: [userId], references: [id], onDelete: Cascade)
  accessToken           String?
  refreshToken          String?
  idToken               String?
  accessTokenExpiresAt  DateTime?
  refreshTokenExpiresAt DateTime?
  scope                 String?
  password              String?
  createdAt             DateTime
  updatedAt             DateTime

  @@map("account")
}

model Verification {
  id         String    @id
  identifier String
  value      String
  expiresAt  DateTime
  createdAt  DateTime?
  updatedAt  DateTime?

  @@map("verification")
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

model User {
  id            String    @id
  email         String    @unique
  password_hash String
  createdAt     DateTime  @default(now())
  updatedAt     DateTime  @updatedAt
  name          String
  emailVerified Boolean
  image         String?
  sessions      Session[]
  accounts      Account[]

  @@map("user")
}

model Session {
  id        String   @id
  expiresAt DateTime
  token     String
  createdAt DateTime
  updatedAt DateTime
  ipAddress String?
  userAgent String?
  userId    String
  user      User     @relation(fields: [userId], references: [id], onDelete: Cascade)

  @@unique([token])
  @@map("session")
}

model Account {
  id                    String    @id
  accountId             String
  providerId            String
  userId                String
  user                  User      @relation(fields: [userId], references: [id], onDelete: Cascade)
  accessToken           String?
  refreshToken          String?
  idToken               String?
  accessTokenExpiresAt  DateTime?
  refreshTokenExpiresAt DateTime?
  scope                 String?
  password              String?
  createdAt             DateTime
  updatedAt             DateTime

  @@map("account")
}

model Verification {
  id         String    @id
  identifier String
  value      String
  expiresAt  DateTime
  createdAt  DateTime?
  updatedAt  DateTime?

  @@map("verification")
}

cc: @bekacru

bekacru•3mo ago

you have password_hash field that's required in your user table first you should remove that. passwords are stored in the account table.

roguesherlockOP•3mo ago

I have not generate this schema, it's generated by better auth cli should I manually modify it?

bekacru•3mo ago

No better auth cli wouldn’t add that field.

roguesherlockOP•3mo ago

And when I try using it github i get this error,

 GET /api/auth/get-session 200 in 217ms
 GET /api/auth/get-session 200 in 55ms
 POST /api/auth/sign-in/social 200 in 1118ms
 GET /api/auth/get-session 200 in 26ms
2025-01-27T12:46:32.529Z ERROR [Better Auth]: unable_to_create_user
 GET /api/auth/callback/github?code=afab850b423d791cd85b&state=dEI2Hz3Bi9MZ7X4qgj8ZceOElx5o_3FA 302 in 1788ms
 GET /api/auth/error?error=unable_to_create_user 200 in 37ms

 GET /api/auth/get-session 200 in 217ms
 GET /api/auth/get-session 200 in 55ms
 POST /api/auth/sign-in/social 200 in 1118ms
 GET /api/auth/get-session 200 in 26ms
2025-01-27T12:46:32.529Z ERROR [Better Auth]: unable_to_create_user
 GET /api/auth/callback/github?code=afab850b423d791cd85b&state=dEI2Hz3Bi9MZ7X4qgj8ZceOElx5o_3FA 302 in 1788ms
 GET /api/auth/error?error=unable_to_create_user 200 in 37ms

bekacru•3mo ago

Maybe you have defined it as additional field Remove the field, push and regenerate the client

roguesherlockOP•3mo ago

let me just remove it and create it from scratch you were right, it removed that field! but weirdly now i get 500 error as soon as I hit my sign in page,

[TypeError: The "payload" argument must be of type object. Received null] {
  code: 'ERR_INVALID_ARG_TYPE'
}
 GET /sign-in?redirect=http%3A%2F%2Flocalhost%3A3000%2F 500 in 1931ms
[TypeError: The "payload" argument must be of type object. Received null] {
  code: 'ERR_INVALID_ARG_TYPE'
}
 GET /api/auth/get-session 500 in 105ms
[TypeError: The "payload" argument must be of type object. Received null] {
  code: 'ERR_INVALID_ARG_TYPE'
}
 GET /sign-in?redirect=http%3A%2F%2Flocalhost%3A3000%2F 500 in 100ms

[TypeError: The "payload" argument must be of type object. Received null] {
  code: 'ERR_INVALID_ARG_TYPE'
}
 GET /sign-in?redirect=http%3A%2F%2Flocalhost%3A3000%2F 500 in 1931ms
[TypeError: The "payload" argument must be of type object. Received null] {
  code: 'ERR_INVALID_ARG_TYPE'
}
 GET /api/auth/get-session 500 in 105ms
[TypeError: The "payload" argument must be of type object. Received null] {
  code: 'ERR_INVALID_ARG_TYPE'
}
 GET /sign-in?redirect=http%3A%2F%2Flocalhost%3A3000%2F 500 in 100ms

I do have a check in my page for the user and it redirect users if they're logged in. I'm assume it's failing to check for the user

export default async function SignIn() {
  const session = await auth.api.getSession({
    headers: await headers(),
  })
  if (session && session.user) {
    redirect("/")
  }
  return (
    <div className="grid h-full min-h-[80vh] place-items-center">
      {/* <SignInForm /> */}
      <SignInWithGithub />
    </div>
  )
}

export default async function SignIn() {
  const session = await auth.api.getSession({
    headers: await headers(),
  })
  if (session && session.user) {
    redirect("/")
  }
  return (
    <div className="grid h-full min-h-[80vh] place-items-center">
      {/* <SignInForm /> */}
      <SignInWithGithub />
    </div>
  )
}

bekacru•3mo ago

Have you pushed and generated the client?

roguesherlockOP•3mo ago

@bekacru that worked! I feel so stupid now lol thank you so much for your help! My only feedback would be that a better error messages when schema/db doesn't match better auth's schema would be nice. Other than it has been awesome experience so far from api design, feature set, tooling, docs, to support

bekacru•3mo ago

thanks and will definitely consider that!

Chandra•3mo ago

I am also facing same issue, can you help me?

Chandra•3mo ago

This is the code

message.txt

bekacru•3mo ago

can you share your prisma schema

Chandra•3mo ago

it is in the file

import { PrismaClient } from '@prisma/client';
import { betterAuth } from 'better-auth';
import { prismaAdapter } from 'better-auth/adapters/prisma';
import { nextCookies } from 'better-auth/next-js';
import { admin, multiSession, username } from 'better-auth/plugins';

import { UserRole } from '@/lib/enums';
import { sendPasswordResetEmail } from '@/lib/next-auth/mail';

import { env } from '@/env.mjs';

const prisma = new PrismaClient();
export const auth = betterAuth({
  appName: 'Valuemetrix',
  database: prismaAdapter(prisma, {
    provider: 'mongodb',
  }),
  user: {
    modelName: 'User',
  },
  logger: {
    disabled: process.env.NODE_ENV === 'production',
    level: 'debug',
  },
  account: {
    fields: {
      accountId: 'providerAccountId',
      refreshToken: 'refreshToken',
      accessToken: 'accessToken',
      idToken: 'idToken',
      accessTokenExpiresAt: 'access_token_expires',
    },
    accountLinking: {
      enabled: true,
      trustedProviders: ['google'],
    },
  },
  emailAndPassword: {
    enabled: true,
    async sendResetPassword(data) {
      await sendPasswordResetEmail(data.user.email, data.token);
    },
  },
  socialProviders: {
    google: {
      clientId: env.GOOGLE_CLIENT_ID,
      clientSecret: env.GOOGLE_CLIENT_SECRET,
      redirectUri: env.NEXT_PUBLIC_APP_URL + '/api/auth/callback/google',
      enabled: true,
    },
  },
  plugins: [
    nextCookies(),
    admin({
      defaultRole: UserRole.USER,
      adminRole: UserRole.ADMIN,
    }),
    multiSession(),
    username(),
  ],
  trustedOrigins: ['localhost:3000'],
});

import { PrismaClient } from '@prisma/client';
import { betterAuth } from 'better-auth';
import { prismaAdapter } from 'better-auth/adapters/prisma';
import { nextCookies } from 'better-auth/next-js';
import { admin, multiSession, username } from 'better-auth/plugins';

import { UserRole } from '@/lib/enums';
import { sendPasswordResetEmail } from '@/lib/next-auth/mail';

import { env } from '@/env.mjs';

const prisma = new PrismaClient();
export const auth = betterAuth({
  appName: 'Valuemetrix',
  database: prismaAdapter(prisma, {
    provider: 'mongodb',
  }),
  user: {
    modelName: 'User',
  },
  logger: {
    disabled: process.env.NODE_ENV === 'production',
    level: 'debug',
  },
  account: {
    fields: {
      accountId: 'providerAccountId',
      refreshToken: 'refreshToken',
      accessToken: 'accessToken',
      idToken: 'idToken',
      accessTokenExpiresAt: 'access_token_expires',
    },
    accountLinking: {
      enabled: true,
      trustedProviders: ['google'],
    },
  },
  emailAndPassword: {
    enabled: true,
    async sendResetPassword(data) {
      await sendPasswordResetEmail(data.user.email, data.token);
    },
  },
  socialProviders: {
    google: {
      clientId: env.GOOGLE_CLIENT_ID,
      clientSecret: env.GOOGLE_CLIENT_SECRET,
      redirectUri: env.NEXT_PUBLIC_APP_URL + '/api/auth/callback/google',
      enabled: true,
    },
  },
  plugins: [
    nextCookies(),
    admin({
      defaultRole: UserRole.USER,
      adminRole: UserRole.ADMIN,
    }),
    multiSession(),
    username(),
  ],
  trustedOrigins: ['localhost:3000'],
});

import {
  adminClient,
  multiSessionClient,
  twoFactorClient,
  usernameClient,
} from 'better-auth/client/plugins';
import { createAuthClient } from 'better-auth/react';

import { env } from '@/env.mjs';

export const authClient = createAuthClient({
  baseURL: env.NEXT_PUBLIC_APP_URL,
  plugins: [
    usernameClient(),
    adminClient(),
    multiSessionClient(),
    twoFactorClient(),
  ],
});

export const { signIn, signOut, signUp, useSession } = authClient;

import {
  adminClient,
  multiSessionClient,
  twoFactorClient,
  usernameClient,
} from 'better-auth/client/plugins';
import { createAuthClient } from 'better-auth/react';

import { env } from '@/env.mjs';

export const authClient = createAuthClient({
  baseURL: env.NEXT_PUBLIC_APP_URL,
  plugins: [
    usernameClient(),
    adminClient(),
    multiSessionClient(),
    twoFactorClient(),
  ],
});

export const { signIn, signOut, signUp, useSession } = authClient;

Chandra•3mo ago

message.txt

bekacru•3mo ago

basically the error is thrown from prisma not better auth. It happens cause when better auth tries to create a user (most likely) prisma is throwing error. First remove where you changed the model name to User. Email verified needs to be boolean field. and cross check or your remaining schema with what better auth expects in the docs.

Chandra•3mo ago

i have done fresh setup https://github.com/Chandraprakash-Darji/better-auth-test. But still don't work

bekacru•3mo ago

https://github.com/Chandraprakash-Darji/better-auth-test/blob/main/lib/auth.ts#L21-L27 remove this from your config

GitHub

better-auth-test/lib/auth.ts at main · Chandraprakash-Darji/better-...

Contribute to Chandraprakash-Darji/better-auth-test development by creating an account on GitHub.

Chandra•3mo ago

thanks it worked, now stuck unable_to_create_user haha

bekacru•3mo ago

I think it's related to the admin plugin try to signup without it the problem is enums can't be set as strings in prisma

Chandra•3mo ago

I removed all the plugins but still don't work and simplified the prisma schema I think Goggle auth gives emailVerified as time, not boolean so just asking if there might be issue is there anyway to have better logs, ?

bekacru•3mo ago

no it returns boolean. It might be releated to the object id. Disbale the default id by setting advanced.generateId to false

Chandra•3mo ago

Worked by updating the generateId

Gaming

Programming

Unable to sign up using email / password

Did you find this page helpful?