Prisma

P

Prisma

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

Join

Possible error in docs?

https://www.prisma.io/docs/guides/nextjs#25-set-up-prisma-client Here i copied the following: ```import { PrismaClient } from '@prisma/client' import { withAccelerate } from '@prisma/extension-accelerate' ...

Coolify: MongoDB Replica Set

Does anybody have the "Custom MongoDB Configuration" to resolve the replica set issue?? Kindly help. Also, if I create replica set on my VPS(via Coolify), all the replica sets are in the same location, then whats the use of it??...

Lost prod data, is there backup?

Hey, I lost my prod data. Is it possible to restore latest snapshot?

Can’t connect to a db

Hi guys, I have two db in a environment and I’m not able to connect with one of them, even to the prisma studio where a receive a erro 500. How can I solve this?...

Getting P5000 issue

This request could not be understood by the server: {"type":"UnknownJsonError","body":{"code":"P6002","message":"The provided API Key is invalid. Reason: No Authorization header is present."}} (The request

We were charged $400 and I can't see why!

We have 4 databases. Development / Staging / Production / Till All of them had ~100k DB requests. we were billed for 22M requests Please fix our invoice asap and reimburse us the money....

Issue migrating a vector field

```evelyn % npx prisma migrate dev Environment variables loaded from .env Prisma schema loaded from prisma/schema.prisma Datasource "db": PostgreSQL database "postgres", schema "public" at "aws-0-us-east-1.pooler.supabase.com:5432" ...

fulltext argument missing

Why @@fulltext argument is missing here? I am using MySQL and "prisma": "^6.1.0" Docs: https://www.prisma.io/docs/orm/prisma-client/queries/full-text-search...
No description

Custom error becomes normal error

what's the probably reason why my custom classes throws normal error in nextjs ? ```ts export default class ServerError extends Error { issues: IError; ...

InitializationError

this is my controller async function signUp(req: Request, res: Response) { req.body.password = await hashPassword(req.body.password); req.body.birthDate = new Date(req.body.birthDate).toISOString(); try {...

Change behavior of @updatedAt when upgrading from 5.21.1 to 6.5.0?

Hi, When upgrading from version 5.21.1 to 6.5.0 I noticed that some of my snapshot tests where failing to a change of order. Digging down I noticed that my records all have the same updatedAt value in version 5.21.1 and now different values in Prisma 6.5.0. I found this issue on GitHub: https://github.com/prisma/prisma/issues/22326. Was this basically resolved somehow? Unfortunately me and ChatGPT could not find a relevant commit that changes this behavior....

Prisma Select TypeError

ok - my issue might be unrelated: This works: ```js function manyFoo(select?: Prisma.fooSelect) {...

Is it possible to run migrations manually on the database server via raw SQL and not use Prisma?

Hi because I'm a bit stuck with migrations stalling and hanging due to Unsupported index of BM25, I am considering just running migrations on the database server manually via raw sql generated from prisma's migration files. i know its not the best thing to do but i gotta do what works. what are some of the implications of doing this?...

Prisma db pull Extremely Slow on Supabase with Custom Schema

Issue: Prisma db pull is extremely slow when introspecting a schema on Supabase. Details:
- Using PostgreSQL on Supabase
- Prisma version:...

Primsa Studio Help

Hi! I am just looking for some help with regards to prisma studio. I current have this model ```model Unit { id Int @id @default(autoincrement()) name String @unique...
No description

Module not found after v6.5.0 upgrade

After upgrading to v6.5.0 these errors occur. ``` ✔ Generated Prisma Client (v6.5.0) to ./node_modules/.pnpm/@[email protected][email protected][email protected][email protected]/node_modules/@prisma/client in 63ms ...

How does Prisma ORM build select Top in SQL Server?

My problem, can reply this query SELECT TOP 1000 * FROM [User] ORDER BY [id] ASC OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY; ...

Empty migration when baselining a database

Hi I'm following this https://www.prisma.io/docs/orm/prisma-migrate/workflows/baselining to baseline a MariaDB database. ``` npx prisma migrate diff \ --from-empty ...

Migration just stalls and hangs.

sometimes, when i perform prisma migrate to either create a new migration or run migration, it just hangs. what are some of the reasons for that happening? we haven't gone production yet but this is super scary. it happens to me from a fresh database after like 2 or 3 days later. we do have a custom BM25 index. its scary because the only way to get migration to work again is if i do a complete drop database and start over....

DB migration does not work on Python Client with Prisma Postgres

I have created a project with prisma postgres for my python application. Following is an example prisma/schema.prisma ```...
Next