Error While Implementing Migrate Command in Prisma: How to Resolve?

Question

I am Working on Twitter-Clone, where I am facing issue on Twitter-server side while implementing Prisma. more details- when I am trying to create a dataBase table of MODEL USER in schema.prisma and trying to connect it with superBase by running "npx prisma migrate dev --name added_user_model" command then this goes under processing but does not execute as it has to be.

As you can see in the terminal, the command is running and it keep on process like this only.

Screenshot

What I have tried?

I have rechecked the DATABASE_URL from SUPERBASE it also right,
I have installed the prisma/client and all prisma's dependencies.
I have checked and asked to chatGPT also but I am not getting my solution. Expecting: After running that command a folder of migration should be created in prisma folder and migration must connect schema to superbase and create a USER MODEL table there. As you can see in this screenshot, this is how the command should work.

Screenshot

Please include relevant code and errors in the question, formatted appropriately 👍🏻 — Dave Newton
– Dave Newton, Commented Jun 21, 2024 at 4:15
Actually it shows no error in my system, just it is kept on rendering this command but not executing it... @DaveNewton As i have also attached screenshot of the problem and and expecting result both — SAURAV PRATAP SINGH
– SAURAV PRATAP SINGH, Commented Jun 21, 2024 at 4:20
Please include relevant code and errors in the question, formatted appropriately. — Dave Newton
– Dave Newton, Commented Jun 21, 2024 at 6:06

fudo · Accepted Answer · 2024-07-31 09:53:23Z

1

This here is the corrected host for your Postgres URL, you need to change the "6589" in your host to "5432". Another method is for you to change your pooler mode from "Transaction" to "Session" before copying your URL from superBase. You can use this link for reference.

edited Jul 31, 2024 at 9:53

fudo

3,0349 gold badges30 silver badges73 bronze badges

answered Jul 23, 2024 at 6:24

Amplejohnny

111 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

David Zagi Over a year ago

Had the same issue and changing the port from "6542" to "5432" worked. Thanks

he kret · Accepted Answer · 2025-04-06 14:55:42Z

0

For me changing the DATABASE_URL to DIRECT_URL in schema.prisma worked.

edited Apr 6 at 14:55

answered Apr 6 at 14:54

he kret

11 bronze badge

1 Comment

stevestorey Apr 10 at 20:38

This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. To get notified when this question gets new answers, you can follow this question. Once you have enough reputation, you can also add a bounty to draw more attention to this question. - From Review

Collectives™ on Stack Overflow

Error While Implementing Migrate Command in Prisma: How to Resolve?

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related