hi, ,anyone encountering "Field does not exist on ...
# prisma-clientj
james tan
10/04/2021, 6:30 AMhi, ,anyone encountering "Field does not exist on enclosing type" even if the field exists?
james tan
10/04/2021, 6:30 AMi double checked the db exists , and my schema does indicate it. and ive already run prisma generate. visual code does not throw space id error
r
Ryan
10/04/2021, 6:38 AMCould you share your query and schema?
j
james tan
10/04/2021, 6:38 AM Copy code
model CompanySpaces {
id Int @id(map: "companyspaces_pk") @default(autoincrement())
company_id Int
space_id Int
createdAt DateTime? @db.Timetz(6)
updatedAt DateTime? @db.Timetz(6)
Companies Companies @relation(fields: [company_id], references: [id], onDelete: Cascade, map: "companyspaces_fk_company")
Spaces Spaces @relation(fields: [space_id], references: [id], onDelete: Cascade, map: "companyspaces_fk_space")
@@index([company_id], map: "companyspaces_company_id_idx")
@@index([space_id], map: "companyspaces_space_id_idx")
}james tan
10/04/2021, 6:38 AM Copy code
prisma.companyLicenses.findMany({ select: {
company_id: true,
space_id: true,
private_member_size: true,
}, where: { company_id: rec.company_id } }).then((lics) => {
recruiter[i].licenses = lics;
});james tan
10/04/2021, 6:39 AMwhen space_id is passed in or include: { Spaces: true } is specified, i willl get that error
james tan
10/04/2021, 6:39 AMusing postgresql
james tan
10/04/2021, 7:56 AMi debugged it down to graphql error:
Copy code
{
error: 'Error in query graph construction: QueryParserError(QueryParserError { path: QueryPath { segments: ["Query", "findManyCompanyLicenses", "CompanyLicenses", "space_id"] }, error_kind: FieldNotFoundError })',
user_facing_error: {
is_panic: false,
message: 'Failed to validate the query: `Field does not exist on enclosing type.` at `Query.findManyCompanyLicenses.CompanyLicenses.space_id`',
meta: {
query_validation_error: 'Field does not exist on enclosing type.',
query_position: 'Query.findManyCompanyLicenses.CompanyLicenses.space_id'
},
error_code: 'P2009'
}
}james tan
10/04/2021, 7:56 AMwhy did we have graphql behind the scene on the prisma sdk?
james tan
10/04/2021, 8:18 AMi have file a bug here https://github.com/prisma/prisma/issues/9578
james tan
10/04/2021, 8:24 AMfixed, ive to remove node_modules n reinstall
💯 1
r
Ryan
10/04/2021, 8:38 AMIs your prisma and @prisma/cli version the same?
j
james tan
10/04/2021, 11:05 AMyes
james tan
10/04/2021, 11:05 AM3.1.1 i think
r
Ryan
10/04/2021, 11:07 AMIn that case, could you share a sample repo with this issue so that I can check?
j
james tan
10/04/2021, 11:08 AMim surprised that the sdk of prisma is calling graphql server
james tan
10/04/2021, 11:09 AMalready fixed sorry didnt have time to filter out the private files, i suspect some node modules is probably not updated
james tan
10/04/2021, 11:09 AMoh ya also possible i was trying out pnpm
r
Ryan
10/04/2021, 11:16 AMim surprised that the sdk of prisma is calling graphql serverWe use that implementation internally. Possibly related to this then.
12 Views