PrismaClientValidationError

Invalid

prisma.session.update()

prisma.session.update()

prisma.session.update()

prisma.session.update() invocation

I am utilizing the latest version of BetterAuth and using the prisma adaptor from

better-auth/adaptors/prisma

better-auth/adaptors/prisma

better-auth/adaptors/prisma

better-auth/adaptors/prisma and my db is

postgresql

postgresql

postgresql

postgresql. I am able to sign up and sign in just fine. However, when the current session needs to be updated, I get the following error. It appears it is trying to use the token for the lookup, but the error seems to indicate the call should be using id instead. My session schema is like this:

model Session {
  id             String   @id
  userId         String
  user           User     @relation(fields: [userId], references: [id], onDelete: Cascade)
  expiresAt      DateTime
  token          String
  ipAddress      String?
  userAgent      String?
  impersonatedBy String?
  createdAt      DateTime @default(now())
  updatedAt      DateTime @updatedAt

  @@map("sessions")
}

model Session {
  id             String   @id
  userId         String
  user           User     @relation(fields: [userId], references: [id], onDelete: Cascade)
  expiresAt      DateTime
  token          String
  ipAddress      String?
  userAgent      String?
  impersonatedBy String?
  createdAt      DateTime @default(now())
  updatedAt      DateTime @updatedAt

  @@map("sessions")
}

model Session {
  id             String   @id
  userId         String
  user           User     @relation(fields: [userId], references: [id], onDelete: Cascade)
  expiresAt      DateTime
  token          String
  ipAddress      String?
  userAgent      String?
  impersonatedBy String?
  createdAt      DateTime @default(now())
  updatedAt      DateTime @updatedAt

  @@map("sessions")
}

model Session {
  id             String   @id
  userId         String
  user           User     @relation(fields: [userId], references: [id], onDelete: Cascade)
  expiresAt      DateTime
  token          String
  ipAddress      String?
  userAgent      String?
  impersonatedBy String?
  createdAt      DateTime @default(now())
  updatedAt      DateTime @updatedAt

  @@map("sessions")
}

How do I resolve this to ensure it is able to properly update the session? Currently, when this error triggers, I just manually go into devtools and delete the cookie (effectively signing me out)

phyziyx•3/22/25, 1:00 PM

You aren't the only one, as I'm also having the exact same issue with Prisma and MySQL.

(screenshot provided by my colleague)

XurothOP•3/22/25, 5:07 PM

Hm... So either the issue is with config or schema (though everything looks correct, according to docs) or it's an issue with a higher-order function (not the specific adaptor, since multiple different ones seem "affected", but potentially with a common function that calls the adaptors)

At least in my case, I'm more likely to think that something isn't configured or initialized correctly. I'll re-check everything once more and do some poking about and report back if I have any progress or success. I'll continue looking at this thread in the hope that something will come up and someone can tell me what I'm doing wrong. More info (implementation etc.) is available if anyone asks.

XXuroth Hm... So either the issue is with config or schema (though everything *looks* co...

phyziyx•3/23/25, 6:54 PM

Make token unique property

XurothOP•3/24/25, 3:53 AM

I'll try that. In the docs, it specifies that token is simply a required string (not unique) but it makes sense it would be. Thanks.

PrismaClientValidationError

Similar Threads

Similar Threads

Similar Threads