Prisma

P

Prisma

Join the community to ask questions about Prisma and get answers from other members.

Join

Please add Dark/Night mode on console.prisma.io

Night/Dark mode is very helpful for devs/users. I know the extension- Dark Reader, but why extension?

"code":"P6003" Prisma example: accelerate-hacker-news

When I upvote on official example- I upvode a post- I got this error- Error: Failed to invalidate Accelerate cache. Response was 400 Bad Request. {"code":"P6003","message":"There is a hold on your account. Reason: planLimitReached. Please contact Prisma support if you think this is an error."} at async addVotes (addVotes.ts:21:3) code link ...

Query works but getting a TS error

Hello! I wrote a query that is working but I am getting a Typescript error that I cannot debug. Could someone more experienced tell me what this could be about? Of course I don't want you to work for me. Not looking for help solving the problem, just some steering on the right direction. Thank you so much in advance. Query:...

Prisma MongoDB

Hello everyone. I want to using Prisma with MongoDB, NestJS. I was setup with docs, and when start server, I have an error with Typescript: ``` yarn start [9:51:57 AM] Starting compilation in watch mode... ...

Prisma Studio Whitescreen?

Hello, when i start up prisma studio using yarn prisma studio -p 6000, i don't get any errors. When i open the url, it's just a white screen. Any help is appreciated, thanks

Im getting some errors out of nowhere

My app was working perfectly fine and suddenly im getting some prisma errors like: PrismaClientKnownRequestError: Invalid prisma.user.findUnique() invocation: ...

Can we pg_dump or pg_restore?

I would like to migrate a database from Vercel Storage to Prisma Postgres, but currently it doesn't seem possible due to being unable to connect directly.

Can't configure Prisma query engine on FreeBSD server

I successfully compiled the engine including /root/prisma-engines/target/release/libquery_engine.so and other files, renamed release/deps/libquery_engine.so to release/deps/libqueryengine.so.node and set variables in the shell like export PRISMA... Now I run npx prisma db push and it successfully creates tables in the database. But when I run my tRPC server file as DEBUG=prisma* node dist/server/routers/_app.js which tries to use Prisma client, I get result root@www2:/usr/local/www # DEBUG=prisma* node dist/server/routers/_app.js prisma:tryLoadEnv Environment variables not found at null +5ms...

Migration to v6 Cockroach DB

I am working on my local environment on a project that uses Prisma. The config looks like this: ``` generator client { provider = "prisma-client-js"...

Console prisma studio

Hello, when I run prisma studio locally everything is fine, but in the prisma studio console I get this error. Is it a bug in the console or on my side? I get this error even with an empty database, I have asked AI and tried many different configs.... nothing helps installHook.js:1 Error: {"error_code":"P1012","message":"\u001b[1;91merror\u001b[0m: \u001b[1mError validating: This line is not a valid field or attribute definition.\u001b[0m\n \u001b[1;94m-->\u001b[0m \u001b[4mschema.prisma:57\u001b[0m\n\u001b[1;94m | \u001b[0m\n\u001b[1;94m56 | \u001b[0mmodel Staff {\n\u001b[1;94m57 | \u001b[0m \u001b[1;91mid Int @id(map: "Staff_pkey") @default(nextval('staff_id_seq")\u001b[0m\n\u001b[1;94m58 | \u001b[0m name String\n\u001b[1;94m | \u001b[0m\n\u001b[1;91merror\u001b[0m: \u001b[1mError validating: This line is not a valid field or attribute definition.\u001b[0m\n \u001b[1;94m-->\u001b[0m \u001b[4mschema.prisma:67\u001b[0m\n\u001b[1;94m | \u001b[0m\n\u001b[1;94m66 | \u001b[0mmodel Studio {\n\u001b[1;94m67 | \u001b[0m \u001b[1;91mid Int @id(map: "Studio_pkey") @default(nextval('studio_id_seq")\u001b[0m\n\u001b[1;94m68 | \u001b[0m name String\n\u001b[1;94m | \u001b[0m\n\nValidation Error Count: 2"}...

Hello, i'm getting error when i start my project

I'm use Postgresql with Prisma but i'm getting this error when i start my project: I tried connect postgresql with psql <link> and it's connected but i don't know why this error occured 😢 I'm tried npm update @prisma/client prisma but it didn't work My model file: ```generator client {...
No description

Delete annoying warning in production

This warning pop-up in my log all the time : prisma:warn In production, we recommend using prisma generate --no-engine (See: prisma generate --help) I'm using the "normal" client and also the "edge" client, depending on my endpoint, so I can't use the --no-engine option. Is there a way to make this warning finally go away ? Thanks !...

Prisma.skip on deeply nested objects

Hello, is there a way to Prisma.skip deeply nested objects? In this case: ```...

Prisma JSON not working with "path"

Hi, I'm using Prisma with Postgres, I store some data with JSON inside, when using { where }, and providing the path and equals value, it does not work.

Cannot read properties of undefined (reading 'bind')

I am trying to update a project I haven't worked on in months. Went to update the prisma dependencies but when running the code, it is showing these errors. The version I updated it to is 6.2.1 which is the latest and am using mongodb. Tried to debug it but not sure what is causing it. ``` TypeError: Cannot read properties of undefined (reading 'bind') at _r.wrapEngine (/Users/Desktop/projects/playercount/node_modules/@prisma/client/runtime/library.js:111:11274)...

Significant Performance Gap: Prisma vs Supabase Client in Nuxt 3

Issue Description I've built a performance comparison tool to test the response times between Prisma and Supabase client when querying the same Supabase database. The results show that Prisma queries are significantly slower (approximately 7-8x) than direct Supabase client queries. Environment...
No description

Prisma.sql vs Prisma $queryRaw diff

Can someone guide me what is the main benefit of Prisma.sql and main differences with $queryRaw? I could not find the Prisma.sql in official docs. Is below approach corrct? ```ts export async function aggregateOpenPullRequestsInPeriod(...

Prisma Optimize Initialization Missing Database URL

After waiting 2 hours for migrations, I decided to give Optimize a go. I have my database url in my .env.development file, which works great when initializing my prisma clients in other files, the DB services. However, it can't find it on my index file. ``` // prettier-ignore import dotenv from 'dotenv'; dotenv.config();...

PrismaClientValidationError

Hello there, I'm currently stuck with this error: `` Invalid prisma.ticket.create()` invocation in ./src/lib/server/ticket.ts:12:16 9 phone_number: string,...

PrismaClientInitializationError

Hello! I'm new to posting here. I'm developing the Next.js app and deploying it to AWS Amplify. However, I'm having problems using Prisma and Auth.js. When I use both prima and auth's session, I get a "PrismaClientInitializationError." The local and Vercel hosting cases are working without this issue. Do you have any thoughts?
No description