#Prisma ORM + MongoDB, Ive been trying to define a unique constraint for another field on my model

9 messages · Page 1 of 1 (latest)

glacial flicker
#

Ive been trying to npx prisma db push it and it's not working:

[+] Unique index `Players_player_id_key` on ({"player_id":1})    

Error: MongoDB error
Kind: Command failed: Error code 59 (CommandNotFound): command createIndexes not found, correlationID = 17be0c70d108c759c936a0f5, labels: {}
   0: schema_core::state::SchemaPush
             at schema-engine\core\src\state.rs:433
#

Here's my schema

#
model Players {
  id                       String  @id @default(auto()) @map("_id") @db.ObjectId
  atp_id                   Int?
  atp_peak_rank            Int?
  atp_peak_rank_date       Int?
  atp_peak_rating          Int?
  atp_peak_rating_date     Int?
  atp_rank                 Int?
  atp_rating               Int?
  /// Could not determine type
  backhand                 Json?
  birthdate                Int?
  birthplace               String?
  clay_peak_rank           Int?
  clay_peak_rank_date      Int?
  clay_peak_rating         Int?
  clay_peak_rating_date    String?
  clay_rank                Int?
  clay_rating              Int?
  death                    String?
  debut                    String
  facebook                 String?
  /// Could not determine type
  favorite_surface         Json?
  grass_peak_rank          Int?
  grass_peak_rank_date     Int?
  grass_peak_rating        Int?
  grass_peak_rating_date   String?
  grass_rank               Int?
  grass_rating             Int?
  hand                     String?
  hard_peak_rank           Int?
  hard_peak_rank_date      Int?
  hard_peak_rating         Int?
  hard_peak_rating_date    String?
  hard_rank                Int?
  hard_rating              Int?
  height                   Int?
  img_link                 String?
  instagram                String?
  last_match               String?
  nicknames                String?
  overall_peak_rank        Int?
  overall_peak_rank_date   Int?
  overall_peak_rating      Int?
  overall_peak_rating_date String?
  overall_rank             Int?
  overall_rating           Int?
  player_id                String @unique 
  player_name              String
  status                   String?
  twitter                  String?
  /// Could not determine type
  website                  Json?
  /// Could not determine type: the field only had null or empty values in the sample set.
  weight                   Json?
  wiki                     String?
}
rocky escarp
#

Hey 👋
Is this happening on latest prisma version 5.11.0?

glacial flicker
#

prisma : 5.10.2

#

I updated

#
prisma                  : 5.11.0
@prisma/client          : 5.11.0
#
[+] Unique index `Players_player_id_key` on ({"player_id":1})

Error: MongoDB error
Kind: Command failed: Error code 59 (CommandNotFound): command createIndexes not found, correlationID = 17be33c07ce3beb990aa6fee, labels: {}
   0: schema_core::state::SchemaPush
             at schema-engine\core\src\state.rs:433```
rocky escarp
#

What is your MongoDB version? Are you using MongoDB Atlas?