Trouble w connecting prisma to next js

Answered

Rhinelander posted this in #help-forum

RhinelanderOP

2023-09-09T06:53:54.000Z

1. installed prisma and created model
2. i made singleton:

import { PrismaClient } from "@prisma/client";

const client = globalThis.prisma || new PrismaClient();

if (process.env.NODE_ENV !== 'production') {
  globalThis.prisma = client;
}

export default client;

3. I created route /api/test/
route.js:

import prisma from "@/app/libs/prismadb"

export async function POST(){ 
    return prisma.user.create({
        data: {
            name: "Jhon",
            email: "Jhon@mail.com"
        }
    })
}

What did I do wrong?

Answered by joulev

yes so you cannot write to the db because this constraint is violated. there is already an user with that email in the db and you had email @unique

View full answer

53 Replies

@Rhinelander 1. installed prisma and created model 2. i made singleton: `import { PrismaClient } from "@prisma/client"; const client = globalThis.prisma || new PrismaClient(); if (process.env.NODE_ENV !== 'production') { globalThis.prisma = client; } export default client;` 3. I created route /api/test/ route.js: `import prisma from "@/app/libs/prismadb" export async function POST(){ return prisma.user.create({ data: { name: "Jhon", email: "Jhon@mail.com" } }) }` What did I do wrong?

joulev

2023-09-09T06:54:56.000Z

export async function POST(){ 
    const result = await prisma.user.create({
        data: {
            name: "Jhon",
            email: "Jhon@mail.com"
        }
    });
    return NextResponse.json(result);
}

RhinelanderOP

2023-09-09T06:57:02.000Z

does not work

joulev

2023-09-09T06:57:21.000Z

define 'does not work', what exactly is not working?

RhinelanderOP

2023-09-09T06:57:30.000Z

it doesnt add it to db and it throws me server error with postman

joulev

2023-09-09T06:57:42.000Z

what is the error message in the terminal

RhinelanderOP

2023-09-09T06:58:29.000Z

it compiles successfully

joulev

2023-09-09T06:58:39.000Z

no that is not the error message

RhinelanderOP

2023-09-09T06:59:04.000Z

in postman or vs code

joulev

2023-09-09T06:59:15.000Z

ok... in both

anywhere there is an error message

RhinelanderOP

2023-09-09T06:59:48.000Z

405 method not allowed and UND_ERR_REQ_CONTENT_LENGTH_MISMATCH

cause: RequestContentLengthMismatchError: Request body length does not match content-length header
at write (C:\Users\ArneÅ¾\Desktop\test\node_modules\next\dist\compiled\undici\index.js:1:67105)
at _resume (C:\Users\ArneÅ¾\Desktop\test\node_modules\next\dist\compiled\undici\index.js:1:66726)
at resume (C:\Users\ArneÅ¾\Desktop\test\node_modules\next\dist\compiled\undici\index.js:1:65413)
at connect (C:\Users\ArneÅ¾\Desktop\test\node_modules\next\dist\compiled\undici\index.js:1:65301) {
code: 'UND_ERR_REQ_CONTENT_LENGTH_MISMATCH'
}

@Rhinelander 405 method not allowed and UND_ERR_REQ_CONTENT_LENGTH_MISMATCH

joulev

2023-09-09T07:00:11.000Z

method not allowed is due to you didn't submitting a POST request most likely

UND_ERR_REQ_CONTENT_LENGTH_MISMATCH is likely an old nextjs bug, upgrade nextjs to latest version

RhinelanderOP

2023-09-09T07:02:11.000Z

i created project today

so its latest

i did npx i prisma -D then npx prisma init

after that i created libs/prismadb.js

created api/test/route.js and did POST function

@Rhinelander Click to see attachment

joulev

2023-09-09T07:06:14.000Z

you never imported prisma and NextResponse

import em

RhinelanderOP

2023-09-09T07:06:37.000Z

at prismadb.js?

@Rhinelander Click to see attachment

joulev

2023-09-09T07:06:52.000Z

at here

RhinelanderOP

2023-09-09T07:09:12.000Z

joulev

2023-09-09T07:09:39.000Z

now show the terminal

RhinelanderOP

2023-09-09T07:11:14.000Z

before that it was

@Rhinelander before that it was

joulev

2023-09-09T07:12:45.000Z

yes so you cannot write to the db because this constraint is violated. there is already an user with that email in the db and you had email @unique

Answer

RhinelanderOP

2023-09-09T07:13:34.000Z

db does not contain this

joulev

2023-09-09T07:14:32.000Z

dunno â€“ the error message literally says "unique constraint failed on the constraint: User_email_key"

the constraint is that email @unique

RhinelanderOP

2023-09-09T07:15:21.000Z

yeah i just did not refresh my db and did not see it i am so dumb....

another question how could i display that data in frontend

if you don't have time to explain i would appreciate if you point me out to good resouce

joulev

2023-09-09T07:18:00.000Z

export default async function Page() {
  const users = await prisma.user.findMany();
  return <pre>{JSON.stringify(users, null, 2)}</pre>;
}

for a start

RhinelanderOP

2023-09-09T07:22:09.000Z

I am gifted programer i get error for every single thing possible

so what are those 2 values after users

do they represent name and email

@Rhinelander Click to see attachment

joulev

2023-09-09T07:23:53.000Z

the error message means there is a user with email: null in your db

change that

RhinelanderOP

2023-09-09T07:26:31.000Z

sorry for being anoying i went from casual frontend javascript dev to fullstack nextjs dev in a week i lack a lot of knowledge but project that i need to do doesnt leave me with many options

joulev

2023-09-09T07:29:54.000Z

yeah no problems i'm trying to help you here, but have you checked if there is a user without an email in your db?

because fairly sure there is

RhinelanderOP

2023-09-09T07:32:17.000Z

@Rhinelander Click to see attachment

joulev

2023-09-09T07:34:03.000Z

see the first user? that is mail not email

RhinelanderOP

2023-09-09T07:34:25.000Z

yeah i saw that and deleted it

it works

you are the best