Deploy Shopify Remix app to Vercel error - Prisma session table does not exist

Retired Boards Appdev Tools
5

@andyjpg It’s most likely you haven’t migrated your db yet.

Make sure you set your schema.prisma correctly and pull the correct env from Vercel using vercel env pull

// your schema.prisma should start as

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
  url = env("POSTGRES_PRISMA_URL") // uses connection pooling
  directUrl = env("POSTGRES_URL_NON_POOLING") // uses a direct connection
}

Delete any files inside migrations folder, then run:

npx prisma migrate dev --name app-setup

**CC: @joshcorbett @pedromsalbur **

1 Like