3,811 questions
0
votes
0
answers
19
views
In prisma migration, it gives this error: Already in sync, no schema change or pending migration was found
I recently added a new field called membersCount in my community model in the schema.prisma , as usual after that i migrated my schema npx prisma migrate dev , but it shows ----> Already in sync, ...
-3
votes
0
answers
18
views
Shopping Cart, how to do it right? [closed]
The question is how to correctly implement the logic for the user's cart, taking into account that the User has the ability to add products, delete them or update their quantity, while not being ...
0
votes
0
answers
35
views
Cannot find module '../../prisma/generated/main/index.js' while starting NestJs Project?
I have two Prisma schemas like this:
Schema1 Generator:
generator client {
provider = "prisma-client-js"
output = "./generated/main"
}
Schema2 Generator:
generator client {
...
- 41
1
vote
1
answer
38
views
Prisma Client could not locate the Query Engine for runtime "rhel-openssl-3.0.x" error on deployment
Prisma works locally and I can invoke my server actions without any problem. However, when I deploy, I get
`Unhandled Rejection: Error [PrismaClientInitializationError]: Prisma Client could not ...
- 41
1
vote
0
answers
20
views
Prisma cannot locate the Query Engine while deploying a NextJS-Prisma app in Vercel with Vercel's Neon PostreSQL
I'm deploying a NextJS App with prisma on Vercel with Vercel's Neon PostreSQl, Vercel doesn't give me any errors while deploying, but when it comes to making request to prisma, it always returns the ...
- 11
0
votes
0
answers
22
views
How can I deploy a web app with prisma to docker with different os binaries?
Im building my first website on docker and it uses prisma. My project is on windows and I am building onto a linux base-image which I assume is causing problems. When I build my docker file I get the ...
0
votes
1
answer
53
views
Prisma won't connect to the API I Created
Now that is the error when I try to save the course name the error handling message always pop up
so I checked connection of Prisma with MySQL database and it was fine.
I did npx prisma generate and ...
0
votes
1
answer
90
views
PostgreSQL simple query slow on server
I use Prisma for two really simple queries in my Node backend
const excavationSiteCount: number = (await client.excavation_sites.count({where: {owner: user}}));
const artifactCount: number = (await ...
- 291
0
votes
0
answers
25
views
How to handle Prisma shared types in a monorepo setup
I have this setup of npm monorepo - apps/fe, apps/be and packages/common (from now on referred to as @common/types). On my BE I use prisma and have several enums inside schema.prisma. I want to have ...
- 79
0
votes
0
answers
25
views
Prisma user.create() throws 'Unknown argument team' error despite correct schema setup
let teamData = {};
if (category === "Challenger") {
if (createTeam === false) {
teamData = {
team: {
connect: { teamName: assignedTeamName },
...
0
votes
1
answer
46
views
Module '"@prisma/client"' has no exported member 'PrismaClient'
This issue arises when I created my own db file:
import { PrismaClient } from '@prisma/client'
export const db = new PrismaClient();
I am using NextJS Prisma.
- 1
0
votes
2
answers
95
views
Prisma Client Initialization Issue After Running npx prisma generate
I'm facing an issue with Prisma Client initialization after running npx prisma generate. Here's the error I'm encountering:
PS C:\Users\USER\DataAnalytics> node Scripts/loadData.js
[class ...
- 43
-1
votes
0
answers
36
views
How to properly configure Prisma with Neon’s serverless PostgreSQL driver in a Next.js app?
I'm trying to connect Prisma ORM with Neon's serverless PostgreSQL in my Next.js project (App Router). I've followed Prisma's official Neon integration guide and installed the following packages:
npm ...
- 109
0
votes
1
answer
70
views
TypeError: Cannot read properties of undefined (reading 'ReactCurrentDispatcher')
I'm a relatively new dev and I am working through a tutorial on how to build a fullstack demo app on Vercel using nextjs with Prisma and Postgres (link: https://vercel.com/guides/nextjs-prisma-...
-1
votes
0
answers
20
views
Is using a centralized Prisma layer for multiple Lambda services a good practice?
Current Approach
I'm building multiple AWS Lambda services that need database access. Instead of duplicating Prisma setup in each service, I've created a centralized prisma-layer that contains:
...
0
votes
0
answers
20
views
P1001: Can't reach database server at `ep-autumn-sky-abvh829b-pooler.eu-west-2.aws.neon.tech:5432`
i got this error P1001: Can't reach database server at ep-autumn-sky-abvh829b-pooler.eu-west-2.aws.neon.tech:5432
My project is being built with Nextjs15, Prisma(6.5) and PostgreSQL, and using neon to ...
0
votes
0
answers
30
views
Vitest setup file is not working in bun express application
I have this bun expressjs typescript application and this is my folder structure.
I wrote some tests using vitest which are placed in the tests/ directory and the tests are executing perfectly with ...
0
votes
0
answers
17
views
new async authorize function for NextAuth5 (auth.js) and Next.JS 15
ALL implementations of the authorize function of NextAuth found on the web are false/deprecated with new Next.JS 15 and new NextAuth 5 (new auth.js) like this :
async authorize(credentials: any) {
...
- 4,796
3
votes
1
answer
2k
views
throw new TypeError(`Missing parameter name at ${i}: ${DEBUG_URL}`);
Gadget Controller Ts Code :
import { Request, Response, NextFunction } from 'express';
import { Status } from '@prisma/client'
import prisma from '../utils/prisma.client';
import { AppError } from '../...
- 43
0
votes
0
answers
64
views
Why can't I delete the data if it's left alone?
Why I can't delete the data if its left alone? I'm having a hard time how can I debug this, I'm using react-hook-form and maximizing the use of useFieldArray. I already have the ability to add and ...
- 731
0
votes
0
answers
36
views
How to get average on timestmapDiff in prisma queries
I am trying to get convert a raw sql query to prisma, but i can't find a way to average on a "virtual" column which is the difference between 2 date columns
IFNULL(AVG(CASE WHEN end_time IS ...
- 1,658
0
votes
1
answer
22
views
How can I include a traceId in Prisma’s $on('query') logs per request?
I'm building a Node.js application using Prisma ORM, and I want to log SQL queries along with a traceId that is generated per HTTP request.
For example, in an Express middleware, I assign a traceId ...
- 1,271
0
votes
0
answers
30
views
Configuring Database Access for Next.js Prisma RDS in AWS Amplify
Problem Description
I have a Next.js application using Prisma ORM that needs to connect to an Amazon RDS PostgreSQL database. I've deployed the site on AWS Amplify, but I'm struggling to properly ...
- 1
0
votes
0
answers
27
views
my next-auth is not redirecting to /users route after adding prisma adapter, where i have used middleware for protecting route
i am trying to protect /users route with oAuth in next-auth while it's working before adding prisma adapter but after prisma adapter, it's not working as expected as the main issue is: when I go to /...
- 997
0
votes
0
answers
27
views
How to create an advance filter using NextJS Tanstack, and Prisma?
I'm having a hard time on how can I create an advance filter function using Tanstack Query, Next JS and Prisma. The main problem I'm encountering right now is how can I pass the query properly to my ...
- 731
0
votes
1
answer
22
views
How can I filter data by Query using Prisma?
I'm trying to filter papers dynamically, either using title or using publication_date or department. Or either just a single query. For example this my URL, so it means I must filter name with test ...
- 731
0
votes
1
answer
331
views
Why is my newly created Next.js app with NextAuth and Prisma throwing this error "TypeError: Cannot read properties of undefined (reading 'exec')"
Just started this project, used create-next-app@latest and installed prisma, nextauth and prisma adapter according to latest docs. DB is properly configured and tested, next secret is set, middleware....
0
votes
0
answers
70
views
Next.js 14 build error: Issues with setImmediate, MessageChannel, and invalid export types in API routes
I'm building a web application with Next.js 14 and React, which includes an upload system that integrates with Replicate's APIs to allow users to create custom AI tools. However, I'm running into a ...
0
votes
0
answers
47
views
PrismaClientUnknownRequestError: "Error in connector: Error querying the database: db error: FATAL: the database system is in recovery mode"
I have a nestjs + prisma + postgres project, everything is good on local. It is deployed to production by docker, when run on production with real user, It usually got this issue, the log returned is
...
- 57
0
votes
2
answers
38
views
Question about Prisma indexes, response its slow
I just noticed that I haven an issue with one of my queries.
I have the following model on prisma:
Database: MYSQL
model Subscriber {
id String @id @default(uuid())
timestamp ...
- 148
1
vote
0
answers
130
views
NestJS Prisma Generated Types Not Included in dist folder
I'm working on a NestJS backend and using Prisma for my database. I generated my Prisma type with the following configuration:
generator clientTypes {
provider = "prisma-client-js"
...
- 11
0
votes
0
answers
37
views
prisma.findmany() on production mode return outdated data, but in dev mode all ok
When trying to get data from the prisma.order.findmany() table, in development mode we get the correct data, in production mode we get the data only at the initialization stage of the project.
...
- 11
0
votes
1
answer
49
views
Prisma client is causing Function App to give Error: Encountered an error (ServiceUnavailable) from host runtime
I am deploying a nodejs app on Azure functions. It works well, but then I need to integrate Prisma for DB interactions.
As soon as I add code related to that:
import { PrismaClient } from "@...
0
votes
0
answers
49
views
Next.js Prisma Base Service: UserDelegate Error with Related Schemas
In my Next.js project, I created a BaseService using Prisma and extended it for sub-services. Everything works fine for normal usage, but when I try to use this approach with schemas that have ...
1
vote
0
answers
86
views
Module not found with prisma and nest js integration on turborepo
I gave you my repo about the question
https://github.com/stygma-projects/fm-apps/tree/init
I made a monorepo with turborepo. I follow the guideline to make my prisma as an internal package to share it ...
- 139
0
votes
1
answer
20
views
Is it possible to disable the database URL accessibility check when initializing the Prisma client?
Is it possible to disable the database URL accessibility check when initializing the Prisma client?
I'm building a Next.js app locally, and the database is hosted at mysql.hostinger.com:3306, but it ...
- 142
0
votes
1
answer
31
views
Prisma Dart ORM write NULL values
I'm trying to update optional / nullable table values with null.
When i do this:
await prisma.testTable.update(
data: PrismaUnion.$1(
TestTableUpdateInput(
myNullableColumn: obj.value != ...
- 127
0
votes
0
answers
54
views
How to properly map PostgreSQL TIME type in Prisma schema for storing operating hours?
I'm trying to store business operating hours in PostgreSQL using Prisma, but I'm having trouble with the proper type mapping for TIME columns.
My PostgreSQL table:
CREATE TABLE public.operating_hours (...
- 634
0
votes
1
answer
121
views
Error: "prismaSchemaFolder preview feature must be enabled" when running npx prisma generate
I'm facing the following issue when running npx prisma generate in my project located at c:\Users\ENGINEER-PC\Desktop\postgresql_project:
Running prisma generate:
- c:\Users\ENGINEER-PC\Desktop\...
- 47
-4
votes
1
answer
100
views
Docker ports problem Error: Failure when receiving data from the peer
I don't understand at all about ports in Docker. I couldn't find any good material explaining this to me. I just found out that there is a host port and an internal one. As I understand it, the ...
- 9
0
votes
0
answers
18
views
Database: migration against the ID field
I have a PSQL database with related relations, and I already have record store in the tables. I need to update the default value for the id field in the relations from CUID to UUID. I'm using Prisma ...
- 31
0
votes
1
answer
48
views
I have signIn defined in next-auth (v5) callbacks, but it does not work
I'm using next-auth (v5).
I have set up OAuth with a Github account, and it works fine.
Next, I want to implement "login is possible only with my Github account".
In this case, I think I ...
1
vote
1
answer
79
views
Electron-app can't find prisma after building an exe
I'm facing the next issue after completing my program and trying to make an executable.
I've started the project directly with electron:
npx create-electron-app@latest my-app --template=vite
And ...
- 89
0
votes
1
answer
62
views
Getting typescript error Type error: Type '() => Promise<{ message: string; } | undefined>' is not assignable to type 'string | ((formData: FormData)
/component/button.tsx
"client component"
export const DeleteButton = ({ id }: { id: string }) => {
const deleteImageWithId = deleteImage.bind(null, id);
return (
<form
...
- 63
0
votes
0
answers
26
views
Getting 42P05 when trying to finUnique using prisma orm
I am currently working on a project where I use express with Prisma with Postgres db but I have recently ran into same error over and over again
ConnectorError(ConnectorError { user_facing_error: ...
- 9
0
votes
0
answers
69
views
Supabase cannot connect to PostgreSQL database
I am facing this issue.
schema.prisma
generator client {
provider = "prisma-client-js"
}
datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
...
- 271
0
votes
0
answers
22
views
Next.js API Route Timezone Conversion Inconsistent Between Development and Production (Vercel)
I'm building an attendance tracking application using Next.js, Prisma, and PostgreSQL. I'm experiencing inconsistent timezone handling between my local development environment and my production ...
- 1
1
vote
0
answers
24
views
How do I add a new parameter in typescript when using Prisma Middleware?
I am using Prisma Middleware to add caching using redis. As part of this I want to be able to set a specific key and TTL on some queries, however I am getting errors thanks to typescript being unable ...
- 1,026
1
vote
1
answer
36
views
How should I handle ownership/existence checks using PrismaORM for nested REST api resources?
I'm working on a REST API with express to keep track of climbs you've completed. A user has a one to many relation with Climbs, and climb has a one to many relationship with notes.
I've chosen to make ...
- 39
0
votes
0
answers
63
views
Why does my Filter option not working? (Shadcn, Tanstack Table)
I'm trying to filter the school using the same method used in the sample filter in Shadcn's Dashboard but the problem I'm encountering right now is, nothing is being fetched. This is the sample image.
...
- 731