prisma - getting environment variable not found error message when running graphql query
I am getting this error message from prisma when I am running the GraphQL query.
Environment variable not found: DATABASE_URL.\n --> schema.prisma:6\n | \n 5 | provider = \"postgresql\"\n 6 | url = env(\"DATABASE_URL\")\n | \n\nValidation Error Count: 1",
At first, I didn't have the .env file in any of my project folders, then I added it with the link to the database url, still not working. Here is the folder structure:
This is what I have inside my .env file looks like -
DATABASE_URL="postgres://postgres:mypassword@db.pqtgawtgpfhpqxpgidrn.supabase.co:5432/postgres"
Solution
If anybody running into this issue, just run npx prisma generate. This will re-establish the link between schema.prisma and .env file.
- @prisma/client did not initialize yet. Please run "prisma generate" and try to import it again
- The right way to create an auto increment ID on Prisma using mongodb
- next-auth credentials provider authorize type error
- Prisma openssl version issue
- Prisma find many and count in one request
- Seeding with prisma nested create with one-to-one relation
- prisma Error: p1001: Can't reach database server at `db.xocheossqzkirwnhzxxm.supabase.co`:`5432`
- Filter by ObjectId with equals operator in $search pipeline stage does not work
- TypeError: The "payload" argument must be of type object. Received null
- Using a prisma query with callback seems to ignore try/catch blocks (Node)
- How can I insert a dynamically-chosen raw SQL clause when using prisma.$queryRaw as a template literal tag?
- the created_at search in prisma aggregateRow mongodb does not work
- Prisma query engine not found on mac M1
- Prisma: Error validating datasource `db`: the URL must start with the protocol `postgresql://` or `postgres://`
- Unknown binaryTarget debian-openssl-3.0.x and no custom binaries were provided error Command failed with exit code 1
- When use two argument or more with where get error
- Apply Prisma Migrations to Multiple Environments with Kubernetes
- prisma - make a field equal to another when it is created
- P1000: Authentication failed against database server at `localhost`, the provided database credentials for `postgres` are not valid
- How to insert String data as enum into Postgres database in Python
- Application error: a server-side exception has occurred next.js
- prisma : how can i get transactions of a specifc user?
- Prisma migration error: "type "serial" does not exist" despite using PostgreSQL 15
- How to get enums in prisma client?
- Is there an alternative solution GraphQL resolveType for union types?
- Unknown argument error when creating record
- Connecting Prisma to Azure SQL Database
- Can not connect to Neon using Prisma
- Doing call to prisma client from load function in Svelte Kit
- How to create a custom mutation Output in GraphQL Pothos Builder