OAuthCreateAccount error

[cjdunteman]

I am using Planetscale, the Prisma Adapter, and Vercel. Whenever I try to sign in I receive a "Try signing in with a different account." message. The url then looks like this: https://cjdunteman.com/api/auth/signin?error=OAuthCreateAccount.

I've set the callback url in my GitHub app to https://cjdunteman.com/api/auth/callback/github.

Here is the schema. I just followed the prisma adapter documentation in creating it.

I don't have NEXTAUTH_URL set at all in Vercel re: #5624

I don't have backticks on the DATABASE_URL in Vercel re: #5127

This link says that the OAuthCreateAccount error is due to a failure in creating the user in the database. I can't figure out why this is failing.

The full repo is public if that helps: repo

[cjdunteman]

Got it working. Had some issues changes I made to the schema.

[mendykrauss]

I wish I would know how you fixed it

[jay-cascade]

Me too

[harshilAmbliya]

i have also same error i use postgres database and prisma and i also got it

[harshilAmbliya]

import { NextAuthOptions } from "next-auth";
import GitHubProvider from "next-auth/providers/github";
import { PrismaAdapter } from "@auth/prisma-adapter"
import prisma from "@/prisma";

const authOptions: NextAuthOptions = {
adapter: PrismaAdapter(prisma),
providers: [
GitHubProvider({
clientId: process.env.GITHUB_ID!,
clientSecret: process.env.GITHUB_SECRET!,
profile(profile, tokens) {
return {
id: profile.id,
access_token: profile.access_token,
expires_at: profile.expires_at,
refresh_token: profile.refresh_token,
username: profile.username ?? "",
role:profile.role ??"user",
}
},
allowDangerousEmailAccountLinking: true,

    })
],
secret: process.env.NEXT_SECRET!,
session: {
    strategy: "jwt"
},
debug: true,
callbacks: {
    async signIn({ user, account, profile, email, credentials }) {

        console.log("Sign in", user, account, profile, email, credentials);
        return true
    },
}

}

export default authOptions;