How to fix P2030: Cannot find a fulltext index to use for the search in Prisma

// Example query that might cause P2030
const results = await prisma.post.findMany({
  where: {
    OR: [
      { title: { search: 'keyword' } },
      { content: { search: 'keyword' } }
    ]
  }
});

model Post {
  id      Int     @id @default(autoincrement())
  title   String  @db.VarChar(255)
  content String  @db.Text

  // Add fulltext index for search functionality
  @@fulltext([title, content])
}

model Product {
  id          Int     @id @default(autoincrement())
  name        String  @db.VarChar(255)
  description String  @db.Text
  category    String  @db.VarChar(100)

  // Multiple fulltext indexes for different search scenarios
  @@fulltext([name, description])
  @@fulltext([name])
  @@fulltext([description])
  @@fulltext([name, description, category])
}

# Generate migration
npx prisma migrate dev --name add-fulltext-indexes

# Or if you want to create the migration without applying it
npx prisma migrate dev --create-only

# For production deployment
npx prisma migrate deploy

-- Show indexes for your table
SHOW INDEX FROM Post;

-- Or more detailed view
SELECT
  TABLE_NAME,
  INDEX_NAME,
  COLUMN_NAME,
  INDEX_TYPE,
  COMMENT
FROM INFORMATION_SCHEMA.STATISTICS
WHERE TABLE_SCHEMA = 'your_database_name'
  AND TABLE_NAME = 'Post'
  AND INDEX_TYPE = 'FULLTEXT';

// Test basic search
const results = await prisma.post.findMany({
  where: {
    OR: [
      { title: { search: 'keyword' } },
      { content: { search: 'keyword' } }
    ]
  }
});

// Test with multiple keywords
const multiResults = await prisma.post.findMany({
  where: {
    title: { search: 'database OR mysql' }
  }
});

// Test with relevance ordering
const relevanceResults = await prisma.post.findMany({
  where: {
    OR: [
      { title: { search: 'prisma' } },
      { content: { search: 'prisma' } }
    ]
  },
  orderBy: {
    _relevance: {
      fields: ['title', 'content'],
      search: 'prisma',
      sort: 'desc'
    }
  }
});

-- Set minimum word length to 3
SET GLOBAL innodb_ft_min_token_size = 3;