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

[kaykhan]

I'm using the Resend Magic Link email adatpter

Looks like its to do with my @@Map("users") -

Ive used snake case from the start by followign this convention - https://authjs.dev/getting-started/adapters/prisma#naming-conventions

It looks like its not compatible? From below the p.user should be p.users.

[auth][error] AdapterError: Read more at https://errors.authjs.dev#adaptererror
[auth][cause]: TypeError: Cannot read properties of undefined (reading 'findUnique')
at getUserByEmail (webpack-internal:///(rsc)/./node_modules/@auth/prisma-adapter/index.js:13:43)
at acc. [as getUserByEmail] (webpack-internal:///(rsc)/./node_modules/@auth/core/lib/init.js:178:30)
at sendToken (webpack-internal:///(rsc)/./node_modules/@auth/core/lib/actions/signin/send-token.js:20:33)
at Module.signIn (webpack-internal:///(rsc)/./node_modules/@auth/core/lib/actions/signin/index.js:22:93)
at AuthInternal (webpack-internal:///(rsc)/./node_modules/@auth/core/lib/index.js:72:77)
at async Auth (webpack-internal:///(rsc)/./node_modules/@auth/core/index.js:126:34)
at async /home/kay/kay/xyz.trade/frontend/node_modules/next/dist/compiled/next-server/app-route.runtime.dev.js:6:55753
at async eO.execute (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/compiled/next-server/app-route.runtime.dev.js:6:46523)
at async eO.handle (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/compiled/next-server/app-route.runtime.dev.js:6:57007)
at async doRender (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/base-server.js:1359:42)
at async cacheEntry.responseCache.get.routeKind (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/base-server.js:1569:40)
at async DevServer.renderToResponseWithComponentsImpl (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/base-server.js:1489:28)
at async DevServer.renderPageComponent (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/base-server.js:1913:24)
at async DevServer.renderToResponseImpl (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/base-server.js:1951:32)
at async DevServer.pipeImpl (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/base-server.js:917:25)
at async NextNodeServer.handleCatchallRenderRequest (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/next-server.js:272:17)
at async DevServer.handleRequestImpl (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/base-server.js:813:17)
at async /home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/dev/next-dev-server.js:339:20
at async Span.traceAsyncFn (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/trace/trace.js:154:20)
at async DevServer.handleRequest (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/dev/next-dev-server.js:336:24)
at async invokeRender (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/lib/router-server.js:173:21)
at async handleRequest (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/lib/router-server.js:350:24)
at async requestHandlerImpl (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/lib/router-server.js:374:13)
at async Server.requestListener (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/lib/start-server.js:141:13)
[auth][details]: {}
[auth][error] AdapterError: Read more at https://errors.authjs.dev#adaptererror
[auth][cause]: TypeError: Cannot read properties of undefined (reading 'findUnique')
at getUserByEmail (webpack-internal:///(rsc)/./node_modules/@auth/prisma-adapter/index.js:13:43)
at acc. [as getUserByEmail] (webpack-internal:///(rsc)/./node_modules/@auth/core/lib/init.js:178:30)
at sendToken (webpack-internal:///(rsc)/./node_modules/@auth/core/lib/actions/signin/send-token.js:20:33)
at Module.signIn (webpack-internal:///(rsc)/./node_modules/@auth/core/lib/actions/signin/index.js:22:93)
at AuthInternal (webpack-internal:///(rsc)/./node_modules/@auth/core/lib/index.js:72:77)
at async Auth (webpack-internal:///(rsc)/./node_modules/@auth/core/index.js:126:34)
at async /home/kay/kay/xyz.trade/frontend/node_modules/next/dist/compiled/next-server/app-route.runtime.dev.js:6:55753
at async eO.execute (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/compiled/next-server/app-route.runtime.dev.js:6:46523)
at async eO.handle (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/compiled/next-server/app-route.runtime.dev.js:6:57007)
at async doRender (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/base-server.js:1359:42)
at async cacheEntry.responseCache.get.routeKind (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/base-server.js:1569:40)
at async DevServer.renderToResponseWithComponentsImpl (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/base-server.js:1489:28)
at async DevServer.renderPageComponent (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/base-server.js:1913:24)
at async DevServer.renderToResponseImpl (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/base-server.js:1951:32)
at async DevServer.pipeImpl (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/base-server.js:917:25)
at async NextNodeServer.handleCatchallRenderRequest (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/next-server.js:272:17)
at async DevServer.handleRequestImpl (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/base-server.js:813:17)
at async /home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/dev/next-dev-server.js:339:20
at async Span.traceAsyncFn (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/trace/trace.js:154:20)
at async DevServer.handleRequest (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/dev/next-dev-server.js:336:24)
at async invokeRender (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/lib/router-server.js:173:21)
at async handleRequest (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/lib/router-server.js:350:24)
at async requestHandlerImpl (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/lib/router-server.js:374:13)
at async Server.requestListener (/home/kay/kay/xyz.trade/frontend/node_modules/next/dist/server/lib/start-server.js:141:13)

import { PrismaAdapter } from "@auth/prisma-adapter";
import NextAuth, { NextAuthConfig } from "next-auth";
import { prisma } from "@/db/prisma";
import Resend from "next-auth/providers/resend";

export const BASE_PATH = "/api/auth";

const authOptions: NextAuthConfig = {
    adapter: PrismaAdapter(prisma),
    providers: [Resend],
    basePath: BASE_PATH,
    secret: process.env.NEXTAUTH_SECRET,
    debug: true,
};

export const { handlers, auth, signIn, signOut } = NextAuth(authOptions);

schema:

The schema was intrrospected with db pull

model accounts {
  user_id             String
  type                String
  provider            String
  provider_account_id String
  refresh_token       String?
  access_token        String?
  expires_at          Int?
  token_type          String?
  scope               String?
  id_token            String?
  session_state       String?
  createdAt           DateTime @default(now())
  updatedAt           DateTime
  users               users    @relation(fields: [user_id], references: [id], onDelete: Cascade)

  @@id([provider, provider_account_id])
  @@schema("auth")
}

model authenticator {
  credential_id          String  @unique
  user_id                String
  provider_account_id    String
  credential_public_key  String
  counter                Int
  credential_device_type String
  credential_backed_up   Boolean
  transports             String?
  users                  users   @relation(fields: [user_id], references: [id], onDelete: Cascade)

  @@id([user_id, credential_id])
  @@schema("auth")
}

model sessions {
  session_token String   @unique
  user_id       String
  expires       DateTime
  createdAt     DateTime @default(now())
  updatedAt     DateTime
  users         users    @relation(fields: [user_id], references: [id], onDelete: Cascade)

  @@schema("auth")
}

model users {
  id             String          @id
  name           String?
  email          String          @unique
  email_verified DateTime?
  image          String?
  createdAt      DateTime        @default(now())
  updatedAt      DateTime
  accounts       accounts[]
  authenticator  authenticator[]
  sessions       sessions[]

  @@schema("auth")
}

model verification_tokens {
  identifier String
  token      String
  expires    DateTime

  @@id([identifier, token])
  @@schema("auth")
}