Prisma•3mo ago

fullText contradicting errors

PrismaClientKnownRequestError: 
Invalid `prisma.user.findMany()` invocation:
Cannot find a fulltext index to use for the native search, try adding a @@fulltext([Fields...]) to your schema

PrismaClientKnownRequestError: 
Invalid `prisma.user.findMany()` invocation:
Cannot find a fulltext index to use for the native search, try adding a @@fulltext([Fields...]) to your schema

Then I add the @@fullText part to my schema and I get

Error: Prisma schema validation - (get-dmmf wasm)
Error code: P1012
error: Attribute not known: "@fullText".
  -->  prisma\schema.prisma:88
   | 
87 |   @@index([siteId])
88 |   @@fullText([name, firstName, lastName])

Error: Prisma schema validation - (get-dmmf wasm)
Error code: P1012
error: Attribute not known: "@fullText".
  -->  prisma\schema.prisma:88
   | 
87 |   @@index([siteId])
88 |   @@fullText([name, firstName, lastName])

5 Replies

RhysOP•3mo ago

Versions

"@planetscale/database": "^1.19.0",
"@prisma/adapter-planetscale": "^6.0.1",
"@prisma/client": "^6.0.1",
"prisma": "^6.0.1"

"@planetscale/database": "^1.19.0",
"@prisma/adapter-planetscale": "^6.0.1",
"@prisma/client": "^6.0.1",
"prisma": "^6.0.1"

RaphaelEtim•3mo ago

Hi @Rhys You specified @@fullText with an uppercase T, it should be @@fulltext. Don't forget to run prisma generate command after updating the schema

RhysOP•3mo ago

https://tenor.com/view/po-facepalm-gif-27277915

Tenor

RhysOP•3mo ago

Thanks @RaphaelEtim

RaphaelEtim•3mo ago

You're welcome.

Gaming

Programming

fullText contradicting errors

Did you find this page helpful?