Prisma•13mo ago

Error P1012 when trying to use Prisma Postgres

Hey there

I'm trying to use Prisma Postgres, but I am getting this error. I am unsure why the

DATABASE_URL

DATABASE_URL

provided by Prisma would not work? Mine follows the format:

prisma+postgres://accelerate.prisma-data.net/?api_key=..."

prisma+postgres://accelerate.prisma-data.net/?api_key=..."

prisma+postgres://accelerate.prisma-data.net/?api_key=..."

prisma+postgres://accelerate.prisma-data.net/?api_key=..." but I get the following error when running

npx prisma migrate dev --name init

npx prisma migrate dev --name init

npx prisma migrate dev --name init

npx prisma migrate dev --name init

Error code: P1012
error: Error validating datasource `db`: the URL must start with the protocol `postgresql://` or `postgres://`. To use a URL with protocol `prisma://`, you need to either enable Accelerate or the Data Proxy. Enable Accelerate via `prisma generate --accelerate` or the Data Proxy via `prisma generate --data-proxy.

Error code: P1012
error: Error validating datasource `db`: the URL must start with the protocol `postgresql://` or `postgres://`. To use a URL with protocol `prisma://`, you need to either enable Accelerate or the Data Proxy. Enable Accelerate via `prisma generate --accelerate` or the Data Proxy via `prisma generate --data-proxy.

Error code: P1012
error: Error validating datasource `db`: the URL must start with the protocol `postgresql://` or `postgres://`. To use a URL with protocol `prisma://`, you need to either enable Accelerate or the Data Proxy. Enable Accelerate via `prisma generate --accelerate` or the Data Proxy via `prisma generate --data-proxy.

Error code: P1012
error: Error validating datasource `db`: the URL must start with the protocol `postgresql://` or `postgres://`. To use a URL with protocol `prisma://`, you need to either enable Accelerate or the Data Proxy. Enable Accelerate via `prisma generate --accelerate` or the Data Proxy via `prisma generate --data-proxy.

Nurul•12/6/24, 5:08 AM

Hello @Alaskan donut

This is strange. Prisma Postgres should work as expected with Prisma Migrate. Can you double check that the correct environment variable - DATABASE_URL is being used.

Do you have any other database connection strings in your env file?

.jsonpOP•12/6/24, 6:16 AM

DATABASE_URL="prisma+postgres://accelerate.prisma-data.net/?api_key=..."

PULSE_API_KEY="..."

DATABASE_URL="prisma+postgres://accelerate.prisma-data.net/?api_key=..."

PULSE_API_KEY="..."

These are the two keys Prisma Postgres provides me during setup. I have no other keys that might conflict.

.jsonpOP•12/6/24, 6:18 AM

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["relationJoins", "typedSql", "omitApi"]
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["relationJoins", "typedSql", "omitApi"]
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

NNurul Hello @Alaskan donut 👋 This is strange. Prisma Postgres should work as expect...

.jsonpOP•12/7/24, 2:37 AM

Are there any resources on debugging this?

Nurul•12/10/24, 8:31 AM

Is your repository open source? If yes, can you share it with me?
I'll try spinning up a new prisma postgres db and check if I get the same issue

NNurul Is your repository open source? If yes, can you share it with me? I'll try spinn...

.jsonpOP•12/11/24, 9:14 PM

It is not, but if you shoot me your github email I can share it with you. Currently I am using Neon until I can resolve this.

Error P1012 when trying to use Prisma Postgres

Similar Threads

Similar Threads

Similar Threads