PrismaClientValidationError:无效的`prisma.user.create()`调用:

Question

我正在尝试使用Next.js&Prisma。我有两个模型用户&轮廓我想创建用户&还使用poster配置req.body中的字段。

datasource db {
provider = "sqlite"
url      = env("DATABASE_URL")
}
generator client {
provider = "prisma-client-js"
}
model User {
id Int @id @default(autoincrement())
name String
email   String @unique
password String
profile Profile?
}
model Profile {
id     Int     @default(autoincrement()) @id
bio    String?
user   User    @relation(fields: [userId], references: [id])
userId Int   @unique
}
here my create function:
//Create User
let { name, email, password,  } = req.body;
const createUser = await prisma.user.create({
data: {
name: name,
email: email,
password: user_password,
profile: {
create: { bio: 'Bsc' }
},  
}
});
res.status(201).json({ error: false, msg: "User Create Successfuly" });

URL命中后，我出现了一个错误。PrismaClientValidationError：无效的prisma.user.create()调用类型UserCreateInput的data.profile中存在未知参数profile。你是说email吗？可用参数：类型UserCreateInput

我该如何解决这个问题？

Answer 1

我遇到了同样的问题，首先停止服务器运行，并尝试：npx yarn-upgrade-all

yarn add @prisma/client

npx prisma migrate reset

Answer 2

解决此问题

let { name, email, password,  } = req.body;
//Create User
const createUser = await prisma.user.create({
data: {
name: name,
email: email,
password: user_password,
profile: {
create: { bio: 'Learning Prisma' },
},

}
});
res.status(201).json({ error: false, msg: "User Create Successfuly" });