Prisma adapter not working with NextAuth and PlanetScale

[lucferrario]

Adapter type

@next-auth/prisma-adapter

Environment

System:
OS: Windows 10 10.0.22000
CPU: (8) x64 Intel(R) Core(TM) i7-7700HQ CPU @ 2.80GHz
Memory: 8.04 GB / 15.89 GB
Binaries:
Node: 16.17.0 - D:\Programs\NodeJS\node.EXE
npm: 8.15.0 - D:\Programs\NodeJS\npm.CMD
Browsers:
Edge: Spartan (44.22000.120.0), Chromium (105.0.1343.53)
Internet Explorer: 11.0.22000.120
npmPackages:
next: ^12.3.0 => 12.3.0
next-auth: ^4.10.3 => 4.10.3
react: 18.2.0 => 18.2.0
npmPackages:
@next-auth/prisma-adapter: ^1.0.4 => 1.0.4

Reproduction URL

https://app.nite.is/auth/signin

Describe the issue

Im kinda new to NextAuth, and i wanted to try it with Prisma. Everything works perfectly locally, but whenever i try to sign in in my production environment i get a callback error and stay in the signin page.
In my Vercel console i used to get this error:

TypeError: cannot read property findmany of undefined

Now i get no errors anymore, but it still doesn't authenticate me.
Could anyone help?
I'm not using any middleware since it didn't seem to work as well

my [...nextauth].js file looks like this:

import NextAuth from "next-auth";
import GoogleProvider from "next-auth/providers/google";
import { PrismaAdapter } from "@next-auth/prisma-adapter";
import { PrismaClient } from "@prisma/client";

const prisma = new PrismaClient();

export const authOptions = {
database: process.env.DATABASE_URL,
adapter: PrismaAdapter(prisma),

providers: [
GoogleProvider({
clientId: process.env.GOOGLE_CLIENT_ID,
clientSecret: process.env.GOOGLE_CLIENT_SECRET,
}),
],

secret: process.env.JWT_SECRET,
pages: {
signIn: "/auth/signin",
signOut: "/auth/signout",
error: "/auth/error", // Error code passed in query string as ?error=
},
session: {
strategy: "jwt",
},
callbacks: {
async signIn({ user, account, profile, email, credentials }) {
return true;
},
async redirect({ url, baseUrl }) {
return baseUrl;
},
async session({ session, user, token }) {
return session;
},
async jwt({ token, user, account, profile, isNewUser }) {
return token;
},
},
};
export default NextAuth(authOptions);

How to reproduce

1. go to https://app.nite.is/auth/signin
2. try to signin with google provider

Expected behavior

Signing in without redirecting to signin page

[lucferrario]

SOLVED:

i solved by updating some prisma libraries for my application though this command:
npm i --save-dev prisma@latest @prisma/client@latest