Pulse listening to all schemas in my RDS instance
I want pulse to only subscribe to changes within one schema but it gives me changes of all schema, is it intended? how do I fix it?
How to avoid resetting the DB when switching between branches with schema diffs
Hello,
We are a small team of 4 working with prisma every day, and we often have to switch to the branch of a coworker to review their work.
But doing so, we need to reset the DB to migrate their version of the schema if they made change to it (while we also made some changes on our end while working).
...
Deploy on GCP
Hey, i'm deploying my NestJS application on GCP cloud run, using Prisma, but I still have this error :
The user-provided container failed to start and listen on the port defined provided by the PORT=8080 environment variable. Logs for this revision might contain more information.
However, I did what was necessary regarding environment variables, here is my entry point in NestJS : ...mysql table collation
I have a database with the default collation set to
utf8mb4_0900_as_ci because i need case insensitivity but accent sensitivity. I noticed the default collation set by prisma is utf8mb4_unicode_ci. is it safe for me to manually change to the collation i need without breaking anything in Prisma? Or is there a way to have prisma set a specific collation for new tables?Reason why relation is giving an error when id is provided
Hello im trying to create a new row but even when the id is provided it gives an error
``
2024-05-01 23:58:55 Invalid prisma.entryAlternativeTitle.create()` invocation:
2024-05-01 23:58:55
2024-05-01 23:58:55 {...Solution:
some wierd artifact i removed node_modules and prisma generated and it fixed it
Temporary table support?
Hi, I'm trying to create a temporary table. My sql works fine via mysql cmd line, but not via prisma client. Any idea what is wrong?
sql:
CREATE TEMPORARY TABLE TempA AS SELECT
ra.a,...
No models defined
Hi everyone ... I'm following the quickstart from here https://www.prisma.io/docs/getting-started/quickstart and getting this error
You don't have any models defined in your schema.prisma, so nothing will be generated.
Schema is definitely there and has a model defined....
Pulse import not recognized / types not working in Next.js project
Pulse is causing type issues when imported specifically inside of Next projects, hasn't happened for me in regular Node projects.
The code itself actually works when run, but it causes a litany of type errors because the .subscribe function isn't applied to the client's types.
To repro:...
Error with correct Model
I getting as problem in IDE
TS2353: Object literal may only specify known properties, and 'canal' does not exist in type 'PostSelect<DefaultArgs>' and error (it's lower)
```ts
// My piece of code
const customId = "15"...Solution:
i just had
output in my schemePrisma throws an error with code 2F005
When running an upsert, prisma throws the following error:
Error occurred during query execution:
ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(PostgresError { code: "2F005", message: "control reached end of trigger procedure without RETURN", severity: "ERROR", detail: None, column: None, hint: None }), transient: false })...Error on prisma Client
at async l (/opt/render/project/src/node_modules/@prisma/client/runtime/library.js:127:11167). I am getting this error
invalid invocation prisma.paypal.findMany()
I'm quite confused by this error since it only happens at runtime when deployed. Cannot recreate locally. We have a findMany query that is throwing this error:
Error converting field "date" of expected non-nullable type "String", found incompatible value of "2024-04-28 00:00:00 +00:00"
This is the model:...
Prisma Query
Hello I'm trying to create a search logic using nest js and prisma,
`` async searchConsumer(
prisma: Prisma.TransactionClient,
query: SearchAccountQuery,...
Prisma stores invalid data
when trying to store a big int like my discord user if which is
229368888486395905, when prisma stores the number, it is different to what my id is! This is what it stores: 229368888486395900MTI key relation
```
model Supertype {
id Int @id @default(autoincrement())
Subtype Subtype[]
}...
Solution:
Hi :vmathi: This looks correct to me. Did you get any issue with it?
Prisma first query goes slow
Hi, I have a question. I've noticed that when Prisma executes its first query of the day, it's quite slow. Even a simple find operation for a single item from the database experiences this delay, sometimes taking more than ten seconds. I've read in the documentation that $connect can help with this when making the first query, but the question is where to place it. Additionally, the documentation also mentions that it's not necessary to use it explicitly so im a little confuse
Solution:
Yeah. they are talking about the same issue. well i will try this workaround that invokes a simple database query every 10-15 mins, in order to prevent Query Engine. thanks
[ERR_PACKAGE_PATH_NOT_EXPORTED]: Package subpath './runtime/library.js' is not defined in "exports"
Hello, I get the error from the title whenever I try to run a project in Docker (image node:20.11.0-bullseye). Prisma is the only dependency in the project, prisma generate has been correctly executed.
Error stack: Error [ERR_PACKAGE_PATH_NOT_EXPORTED]: Package subpath './runtime/library.js' is not defined by "exports" in /ragemp-server/node_modules/.pnpm/@prisma+client@5.13.0_prisma@5.13.0/node_modules/@prisma/client/package.json
2024-04-30 12:50:56 at throwExportsNotFound (internal/modules/esm/resolve.js:285:9)
2024-04-30 12:50:56 at packageExportsResolve (internal/modules/esm/resolve.js:491:3)...
Health Check of Query Engine timed out.
Hello there, I've been using Prisma for a bit now and I decided today to setup Prisma Accelerate. I'm using a mariadb (mysql) server and I've successfully setup accelerate, however, when queries that worked before accelerate are run, they error.
Error + Logging:
```
prisma:client clientVersion 5.13.0 +0ms...