Cannot read properties of undefined (reading 'findUnique') TypeError: Cannot read properties of undefined (reading 'findUnique') at getUserByAccount

[Steravy]

Question 💬

I am having this error trying to implement next-auth in my next app:
Cannot read properties of undefined (reading 'findUnique') TypeError: Cannot read properties of undefined (reading 'findUnique') at getUserByAccount
Every time i try to sign up using google or github provider i end up having the same problem:

[next-auth][error][adapter_error_getUserByAccount]
https://next-auth.js.org/errors#adapter_error_getuserbyaccount Cannot read properties of undefined (reading 'findUnique') {
message: "Cannot read properties of undefined (reading 'findUnique')",
stack: "TypeError: Cannot read properties of undefined (reading 'findUnique')\n" +
' at getUserByAccount (webpack-internal:///(sc_server)/./node_modules/@auth/prisma-adapter/index.js:220:45)\n' +
' at _callee2$ (webpack-internal:///(sc_server)/./node_modules/next-auth/core/errors.js:301:43)\n' +
' at tryCatch (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/regeneratorRuntime.js:36:25)\n' +
' at Generator.eval (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/regeneratorRuntime.js:120:30)\n' +
' at Generator.eval [as next] (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/regeneratorRuntime.js:64:29)\n' +
' at asyncGeneratorStep (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:4:28)\n' +
' at _next (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:22:17)\n' +
' at eval (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:27:13)\n' +
' at new Promise ()\n' +
' at eval (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:19:16)\n' +
' at Object.callback (webpack-internal:///(sc_server)/./node_modules/next-auth/core/routes/callback.js:42:49)\n' +
' at async AuthHandler (webpack-internal:///(sc_server)/./node_modules/next-auth/core/index.js:202:38)\n' +
' at async NextAuthRouteHandler (webpack-internal:///(sc_server)/./node_modules/next-auth/next/index.js:49:30)\n' +
' at async NextAuth._args$ (webpack-internal:///(sc_server)/./node_modules/next-auth/next/index.js:83:24)\n' +
' at async eval (webpack-internal:///(sc_server)/./node_modules/next/dist/server/future/route-modules/app-route/module.js:265:37)',
name: 'TypeError'
}
[next-auth][error][OAUTH_CALLBACK_HANDLER_ERROR]
https://next-auth.js.org/errors#oauth_callback_handler_error Cannot read properties of undefined (reading 'findUnique') TypeError: Cannot read properties of undefined (reading 'findUnique')
at getUserByAccount (webpack-internal:///(sc_server)/./node_modules/@auth/prisma-adapter/index.js:220:45)
at _callee2$ (webpack-internal:///(sc_server)/./node_modules/next-auth/core/errors.js:301:43)
at tryCatch (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/regeneratorRuntime.js:36:25)
at Generator.eval (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/regeneratorRuntime.js:120:30)
at Generator.eval [as next] (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/regeneratorRuntime.js:64:29)
at asyncGeneratorStep (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:4:28)
at _next (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:22:17)
at eval (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:27:13)
at new Promise ()
at eval (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:19:16)
at Object.callback (webpack-internal:///(sc_server)/./node_modules/next-auth/core/routes/callback.js:42:49)
at async AuthHandler (webpack-internal:///(sc_server)/./node_modules/next-auth/core/index.js:202:38)
at async NextAuthRouteHandler (webpack-internal:///(sc_server)/./node_modules/next-auth/next/index.js:49:30)
at async NextAuth._args$ (webpack-internal:///(sc_server)/./node_modules/next-auth/next/index.js:83:24)
at async eval (webpack-internal:///(sc_server)/./node_modules/next/dist/server/future/route-modules/app-route/module.js:265:37) {
name: 'GetUserByAccountError',
code: undefined
}

THIS IS THE authOptions object:
https://github.com/Steravy/Airbnb-clone/blob/main/src/app/utils/authOptions.ts
THE PRISMA SCHEMA:
https://github.com/Steravy/Airbnb-clone/blob/main/prisma/schema.prisma
The CredentialsProvider is working just fine

How to reproduce ☕️

[next-auth][error][adapter_error_getUserByAccount]
https://next-auth.js.org/errors#adapter_error_getuserbyaccount Cannot read properties of undefined (reading 'findUnique') {
message: "Cannot read properties of undefined (reading 'findUnique')",
stack: "TypeError: Cannot read properties of undefined (reading 'findUnique')\n" +
' at getUserByAccount (webpack-internal:///(sc_server)/./node_modules/@auth/prisma-adapter/index.js:220:45)\n' +
' at _callee2$ (webpack-internal:///(sc_server)/./node_modules/next-auth/core/errors.js:301:43)\n' +
' at tryCatch (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/regeneratorRuntime.js:36:25)\n' +
' at Generator.eval (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/regeneratorRuntime.js:120:30)\n' +
' at Generator.eval [as next] (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/regeneratorRuntime.js:64:29)\n' +
' at asyncGeneratorStep (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:4:28)\n' +
' at _next (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:22:17)\n' +
' at eval (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:27:13)\n' +
' at new Promise ()\n' +
' at eval (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:19:16)\n' +
' at Object.callback (webpack-internal:///(sc_server)/./node_modules/next-auth/core/routes/callback.js:42:49)\n' +
' at async AuthHandler (webpack-internal:///(sc_server)/./node_modules/next-auth/core/index.js:202:38)\n' +
' at async NextAuthRouteHandler (webpack-internal:///(sc_server)/./node_modules/next-auth/next/index.js:49:30)\n' +
' at async NextAuth._args$ (webpack-internal:///(sc_server)/./node_modules/next-auth/next/index.js:83:24)\n' +
' at async eval (webpack-internal:///(sc_server)/./node_modules/next/dist/server/future/route-modules/app-route/module.js:265:37)',
name: 'TypeError'
}
[next-auth][error][OAUTH_CALLBACK_HANDLER_ERROR]
https://next-auth.js.org/errors#oauth_callback_handler_error Cannot read properties of undefined (reading 'findUnique') TypeError: Cannot read properties of undefined (reading 'findUnique')
at getUserByAccount (webpack-internal:///(sc_server)/./node_modules/@auth/prisma-adapter/index.js:220:45)
at _callee2$ (webpack-internal:///(sc_server)/./node_modules/next-auth/core/errors.js:301:43)
at tryCatch (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/regeneratorRuntime.js:36:25)
at Generator.eval (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/regeneratorRuntime.js:120:30)
at Generator.eval [as next] (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/regeneratorRuntime.js:64:29)
at asyncGeneratorStep (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:4:28)
at _next (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:22:17)
at eval (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:27:13)
at new Promise ()
at eval (webpack-internal:///(sc_server)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:19:16)
at Object.callback (webpack-internal:///(sc_server)/./node_modules/next-auth/core/routes/callback.js:42:49)
at async AuthHandler (webpack-internal:///(sc_server)/./node_modules/next-auth/core/index.js:202:38)
at async NextAuthRouteHandler (webpack-internal:///(sc_server)/./node_modules/next-auth/next/index.js:49:30)
at async NextAuth._args$ (webpack-internal:///(sc_server)/./node_modules/next-auth/next/index.js:83:24)
at async eval (webpack-internal:///(sc_server)/./node_modules/next/dist/server/future/route-modules/app-route/module.js:265:37) {
name: 'GetUserByAccountError',
code: undefined
}

Contributing 🙌🏽

Yes, I am willing to help answer this question in a PR

[salvaoo]

Any solution for this? I'm having the same problem and I can't find the solution.... 🤦🏻‍♂️

[Steravy]

see the @ZekeGan solution, i did something similar, its something between the user and Account models

[ZekeGan]

I added model Account and modified model User in my schema.prisma, and it worked.

...
model User {
  id             String    @id @default(auto()) @map("_id") @db.ObjectId
  name           String?
  hashedPassword String?
  email          String?   @unique
  emailVerified  DateTime?
  image          String?
  createdAt      DateTime  @default(now())
  updatedAt      DateTime  @updatedAt

  @@map("user")
}

model Account {
  id                String  @id @default(auto()) @map("_id") @db.ObjectId
  type              String
  provider          String
  providerAccountId String
  token_type        String?
  refresh_token     String? @db.String
  access_token      String? @db.String
  id_token          String? @db.String
  scope             String?
  session_state     String?
  expires_at        Int?

  user   User   @relation(fields: [userId], references: [id], onDelete: Cascade)
  userId String @db.ObjectId

  @@unique([provider, providerAccountId])
  @@map("account")
}
...

[Steravy]

Yes i did something similar, it was something with my schema, but i edited the prisma schema and it worked just fine

[Akalabete]

awsome , effectively i was missing an Account object in relation with my user DB thanks !

[jithesh-poojari]

Any solution for this error.
[next-auth][error][adapter_error_getSessionAndUser]
https://next-auth.js.org/errors#adapter_error_getsessionanduser Cannot read properties of undefined (reading 'findUnique') {
message: "Cannot read properties of undefined (reading 'findUnique')",
stack: "TypeError: Cannot read properties of undefined (reading 'findUnique')\n" +
' at getSessionAndUser (webpack-internal:///(rsc)/./node_modules/@next-auth/prisma-adapter/dist/index.js:224:52)\n' +
' at _callee2$ (webpack-internal:///(rsc)/./node_modules/next-auth/core/errors.js:365:29)\n' +
' at tryCatch (webpack-internal:///(rsc)/./node_modules/@babel/runtime/helpers/regeneratorRuntime.js:45:16)\n' +
' at Generator.eval (webpack-internal:///(rsc)/./node_modules/@babel/runtime/helpers/regeneratorRuntime.js:133:17)\n' +
' at Generator.eval [as next] (webpack-internal:///(rsc)/./node_modules/@babel/runtime/helpers/regeneratorRuntime.js:74:21)\n' +
' at asyncGeneratorStep (webpack-internal:///(rsc)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:3:24)\n' +
' at _next (webpack-internal:///(rsc)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:22:9)\n' +
' at eval (webpack-internal:///(rsc)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:27:7)\n' +
' at new Promise ()\n' +
' at eval (webpack-internal:///(rsc)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:19:12)\n' +
' at Object.session (webpack-internal:///(rsc)/./node_modules/next-auth/core/routes/session.js:92:34)\n' +
' at AuthHandler (webpack-internal:///(rsc)/./node_modules/next-auth/core/index.js:165:40)\n' +
' at async NextAuthRouteHandler (webpack-internal:///(rsc)/./node_modules/next-auth/next/index.js:69:28)\n' +
' at async NextAuth._args$ (webpack-internal:///(rsc)/./node_modules/next-auth/next/index.js:105:16)\n' +
' at async D:\Projects\college_project_url_shortner\node_modules\next\dist\compiled\next-server\app-route.runtime.dev.js:6:63809\n' +
' at async eU.execute (D:\Projects\college_project_url_shortner\node_modules\next\dist\compiled\next-server\app-route.runtime.dev.js:6:53964)\n' +
' at async eU.handle (D:\Projects\college_project_url_shortner\node_modules\next\dist\compiled\next-server\app-route.runtime.dev.js:6:65062)\n' +
' at async doRender (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\base-server.js:1315:42)\n' +
' at async cacheEntry.responseCache.get.routeKind (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\base-server.js:1525:40)\n' +
' at async DevServer.renderToResponseWithComponentsImpl (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\base-server.js:1445:28)\n' +
' at async DevServer.renderPageComponent (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\base-server.js:1842:24)\n' +
' at async DevServer.renderToResponseImpl (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\base-server.js:1880:32)\n' +
' at async DevServer.pipeImpl (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\base-server.js:893:25)\n' +
' at async NextNodeServer.handleCatchallRenderRequest (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\next-server.js:269:17)\n' +
' at async DevServer.handleRequestImpl (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\base-server.js:789:17)\n' +
' at async D:\Projects\college_project_url_shortner\node_modules\next\dist\server\dev\next-dev-server.js:331:20\n' +
' at async Span.traceAsyncFn (D:\Projects\college_project_url_shortner\node_modules\next\dist\trace\trace.js:151:20)\n' +
' at async DevServer.handleRequest (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\dev\next-dev-server.js:328:24)\n' +
' at async invokeRender (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\lib\router-server.js:174:21)\n' +
' at async handleRequest (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\lib\router-server.js:353:24)\n' +
' at async requestHandlerImpl (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\lib\router-server.js:377:13)\n' +
' at async Server.requestListener (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\lib\start-server.js:140:13)',
name: 'TypeError'
}
[next-auth][error][SESSION_ERROR]
https://next-auth.js.org/errors#session_error Cannot read properties of undefined (reading 'findUnique') TypeError: Cannot read properties of undefined (reading 'findUnique')
at getSessionAndUser (webpack-internal:///(rsc)/./node_modules/@next-auth/prisma-adapter/dist/index.js:224:52)
at _callee2$ (webpack-internal:///(rsc)/./node_modules/next-auth/core/errors.js:365:29)
at tryCatch (webpack-internal:///(rsc)/./node_modules/@babel/runtime/helpers/regeneratorRuntime.js:45:16)
at Generator.eval (webpack-internal:///(rsc)/./node_modules/@babel/runtime/helpers/regeneratorRuntime.js:133:17)
at Generator.eval [as next] (webpack-internal:///(rsc)/./node_modules/@babel/runtime/helpers/regeneratorRuntime.js:74:21)
at asyncGeneratorStep (webpack-internal:///(rsc)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:3:24)
at _next (webpack-internal:///(rsc)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:22:9)
at eval (webpack-internal:///(rsc)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:27:7)
at new Promise ()
at eval (webpack-internal:///(rsc)/./node_modules/@babel/runtime/helpers/asyncToGenerator.js:19:12)
at Object.session (webpack-internal:///(rsc)/./node_modules/next-auth/core/routes/session.js:92:34)
at AuthHandler (webpack-internal:///(rsc)/./node_modules/next-auth/core/index.js:165:40)
at async NextAuthRouteHandler (webpack-internal:///(rsc)/./node_modules/next-auth/next/index.js:69:28)
at async NextAuth._args$ (webpack-internal:///(rsc)/./node_modules/next-auth/next/index.js:105:16)
at async D:\Projects\college_project_url_shortner\node_modules\next\dist\compiled\next-server\app-route.runtime.dev.js:6:63809
at async eU.execute (D:\Projects\college_project_url_shortner\node_modules\next\dist\compiled\next-server\app-route.runtime.dev.js:6:53964)
at async eU.handle (D:\Projects\college_project_url_shortner\node_modules\next\dist\compiled\next-server\app-route.runtime.dev.js:6:65062)
at async doRender (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\base-server.js:1315:42)
at async cacheEntry.responseCache.get.routeKind (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\base-server.js:1525:40)
at async DevServer.renderToResponseWithComponentsImpl (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\base-server.js:1445:28)
at async DevServer.renderPageComponent (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\base-server.js:1842:24)
at async DevServer.renderToResponseImpl (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\base-server.js:1880:32)
at async DevServer.pipeImpl (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\base-server.js:893:25)
at async NextNodeServer.handleCatchallRenderRequest (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\next-server.js:269:17)
at async DevServer.handleRequestImpl (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\base-server.js:789:17)
at async D:\Projects\college_project_url_shortner\node_modules\next\dist\server\dev\next-dev-server.js:331:20
at async Span.traceAsyncFn (D:\Projects\college_project_url_shortner\node_modules\next\dist\trace\trace.js:151:20)
at async DevServer.handleRequest (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\dev\next-dev-server.js:328:24)
at async invokeRender (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\lib\router-server.js:174:21)
at async handleRequest (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\lib\router-server.js:353:24)
at async requestHandlerImpl (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\lib\router-server.js:377:13)
at async Server.requestListener (D:\Projects\college_project_url_shortner\node_modules\next\dist\server\lib\start-server.js:140:13) {
name: 'GetSessionAndUserError',
code: undefined
}

My Schema:
generator client {
provider = "prisma-client-js"
}

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

model User {
id String @id @default(cuid())
name String?
email String? @unique
emailVerified DateTime?
hashedPassword String?
image String?
private Boolean @default(false)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
accounts Account[]
urls Url[]
}

model Url {
id String @id @default(cuid())
url String
shortid String @unique
expiry String @default("never")
active Boolean @default(true)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
userId String
user User @relation(fields: [userId], references: [id])
clicks Click[]
}

model Click {
id String @id @default(cuid())
urlId String
url Url @relation(fields: [urlId], references: [id], onDelete: Cascade)
createdAt DateTime @default(now())
deviceType String?
browser String?
referrer String?
location String?
ip String?
}

model Account {
id String @id @default(cuid())
userId String
type String
provider String
providerAccountId String
refresh_token String? @db.Text
access_token String? @db.Text
expires_at Int?
token_type String?
scope String?
id_token String? @db.Text
session_state String?

user User @relation(fields: [userId], references: [id], onDelete: Cascade)

@@unique([provider, providerAccountId])
}

[ayowaaab]

check this Docs

you need to make a model Account with the same fields name just copy it exactly this will fix your problem
https://next-auth.js.org/v3/adapters/prisma#setup

PS: I was writing refresh_token field like this -> refreshToken | this made my code return the same error you provided