How to fix P2005: The value stored in the database is invalid for the field's type in Prisma

P2005: The value "abc123" stored in the database for the field "userId" is invalid for the field's type

model User {
  id    Int     @id @default(autoincrement())
  email String  @unique
  posts Post[]
}

model Post {
  id     Int    @id @default(autoincrement())
  title  String
  userId Int    // This is defined as Int
  user   User   @relation(fields: [userId], references: [id])
}

\d table_name;
-- or
SELECT column_name, data_type, is_nullable
FROM information_schema.columns
WHERE table_name = 'your_table';

DESCRIBE your_table;
-- or
SHOW COLUMNS FROM your_table;

SELECT id, "userId", typeof("userId")
FROM "Post"
WHERE "userId" = 'abc123' OR "userId" IS NULL;

SELECT id, userId, TYPEOF(userId)
FROM Post
WHERE userId = 'abc123' OR userId IS NULL;

UPDATE "Post" SET "userId" = CAST("userId" AS INTEGER) WHERE "userId" ~ '^[0-9]+$';

UPDATE "Post" SET "userId" = 1 WHERE "userId" IS NULL;

ALTER TABLE "Post" MODIFY COLUMN "userId" BIGINT;

npx prisma generate

// If the field should be nullable
model Post {
  id     Int    @id @default(autoincrement())
  title  String
  userId Int?   // Now nullable
  user   User?  @relation(fields: [userId], references: [id])
}

// If the field should be a different type
model Post {
  id     Int     @id @default(autoincrement())
  title  String
  userId String  // Changed from Int to String
  user   User    @relation(fields: [userId], references: [id])
}

// If the field should support larger numbers
model Post {
  id     Int     @id @default(autoincrement())
  title  String
  userId BigInt  // Changed from Int to BigInt
  user   User    @relation(fields: [userId], references: [id])
}

npx prisma migrate dev --name fix_userid_type

npx prisma db pull

git diff prisma/schema.prisma

npx prisma generate

const post = await prisma.post.findUnique({
  where: { id: 1 },
  include: { user: true },
});

console.log(post); // Should not throw P2005