Middleware error: PrismaClientKnownRequestError

On localhost it works all fine no error, nothing, but on vercel there is this issue "Middleware error: PrismaClientKnownRequestError:
Invalid

prisma.subdomain.findFirst()

prisma.subdomain.findFirst()

invocation:

Error validating datasource

db

db

: the URL must start with the protocol

prisma://

prisma://

" i dont know why, my env is

DATABASE_URL="prisma://accelerate.prisma-data.net/?api_key=..."
DIRECT_DATABASE_URL="postgres://avnadmin:...pg-236b6581-....k.aivencloud.com:14028/defaultdb?sslmode=require"

My prisma.ts is

import { PrismaClient } from "@prisma/client/edge";
// test
import { withAccelerate } from "@prisma/extension-accelerate";

// Learn more about instantiating PrismaClient in Next.js here: https://www.prisma.io/docs/data-platform/accelerate/getting-started

const prismaClientSingleton = () => {
  return new PrismaClient().$extends(withAccelerate());
};

declare const globalThis: {
  prismaGlobal: ReturnType<typeof prismaClientSingleton>;
} & typeof global;

const prisma = globalThis.prismaGlobal ?? prismaClientSingleton();

export default prisma;

if (process.env.NODE_ENV !== "production") globalThis.prismaGlobal = prisma;

import { PrismaClient } from "@prisma/client/edge";
// test
import { withAccelerate } from "@prisma/extension-accelerate";

// Learn more about instantiating PrismaClient in Next.js here: https://www.prisma.io/docs/data-platform/accelerate/getting-started

const prismaClientSingleton = () => {
  return new PrismaClient().$extends(withAccelerate());
};

declare const globalThis: {
  prismaGlobal: ReturnType<typeof prismaClientSingleton>;
} & typeof global;

const prisma = globalThis.prismaGlobal ?? prismaClientSingleton();

export default prisma;

if (process.env.NODE_ENV !== "production") globalThis.prismaGlobal = prisma;

and finally my schema.prisma

generator client {
  provider   = "prisma-client-js"
  engineType = "library"
}

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

generator client {
  provider   = "prisma-client-js"
  engineType = "library"
}

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

so i do not get what the issue is as i have followed all the docs and tried for hour's and it just doesn't seem to wanna work.
if anyone could help tat would be amazing

Prisma•17mo ago•

4 replies

Middleware error: PrismaClientKnownRequestError

On localhost it works all fine no error, nothing, but on vercel there is this issue "Middleware error: PrismaClientKnownRequestError:
Invalid

prisma.subdomain.findFirst()

prisma.subdomain.findFirst()

invocation:

Error validating datasource

db

db

: the URL must start with the protocol

prisma://

prisma://

import { PrismaClient } from "@prisma/client/edge";
// test
import { withAccelerate } from "@prisma/extension-accelerate";

// Learn more about instantiating PrismaClient in Next.js here: https://www.prisma.io/docs/data-platform/accelerate/getting-started

const prismaClientSingleton = () => {
  return new PrismaClient().$extends(withAccelerate());
};

declare const globalThis: {
  prismaGlobal: ReturnType<typeof prismaClientSingleton>;
} & typeof global;

const prisma = globalThis.prismaGlobal ?? prismaClientSingleton();

export default prisma;

if (process.env.NODE_ENV !== "production") globalThis.prismaGlobal = prisma;

import { PrismaClient } from "@prisma/client/edge";
// test
import { withAccelerate } from "@prisma/extension-accelerate";

// Learn more about instantiating PrismaClient in Next.js here: https://www.prisma.io/docs/data-platform/accelerate/getting-started

const prismaClientSingleton = () => {
  return new PrismaClient().$extends(withAccelerate());
};

declare const globalThis: {
  prismaGlobal: ReturnType<typeof prismaClientSingleton>;
} & typeof global;

const prisma = globalThis.prismaGlobal ?? prismaClientSingleton();

export default prisma;

if (process.env.NODE_ENV !== "production") globalThis.prismaGlobal = prisma;

and finally my schema.prisma

generator client {
  provider   = "prisma-client-js"
  engineType = "library"
}

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

generator client {
  provider   = "prisma-client-js"
  engineType = "library"
}

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

so i do not get what the issue is as i have followed all the docs and tried for hour's and it just doesn't seem to wanna work.
if anyone could help tat would be amazing

Middleware error: PrismaClientKnownRequestError

Similar Threads

Middleware error: PrismaClientKnownRequestError

Similar Threads

Similar Threads

Similar Threads