Error while setting up in local

[Danesh-md]

I'm trying to contribute in this project. While setting up locally I'm getting this error

migration error while running the command yarn dx

kindly help to setup in local

[biplab-sutradhar]

@Danesh-md did you set up the repo I am also facing same issue

[dosubot[bot]]

Hey @Danesh-md! 👋 I'm here to help you with any bugs, questions, or becoming a contributor. Let's squash those bugs together!

To resolve the migration error encountered when running the command yarn dx, follow these steps:

1. Check Environment Variables: Ensure that your .env file contains the correct DATABASE_URL and DATABASE_DIRECT_URL. These variables are crucial for the migration script to function properly.

2. Resolve Applied Migrations: If you see an error like Error: P3005, indicating that the database schema is not empty, you need to inform Prisma about which migrations have already been applied. Use the following command, replacing migration_name with the name of each migration that has already been applied:

   yarn prisma migrate resolve --applied migration_name

3. Reset Local Database: If your local Prisma database is out of sync, you can reset it by deleting entries in the _prisma_migrations table. For PostgreSQL, execute:

   DELETE FROM "_prisma_migrations";

4. Reapply Migrations: After resetting, re-index and apply all migrations in the prisma/migrations directory:

   ls -1a prisma/migrations/ | grep 2021 | xargs -I{} prisma migrate resolve --applied {}

5. Check Prisma Initialization: Ensure that Prisma can be initialized. If it cannot, the migration process will be skipped. Verify this using the isPrismaAvailableCheck function.

These steps should help you resolve the migration error and set up your local environment successfully ^[1][2].

To continue talking to Dosu, mention @dosu.

Written by @dosu, approved by dosu-customer-success