Prisma, Error: P1014 The underlying table for model (not available) does not exist.

[JDuarthe]

Hi everyone, I'm new with prisma and I been doing the getting started example https://www.prisma.io/docs/getting-started/setup-prisma/start-from-scratch-typescript-postgres

And got this error while doing the migration
Error: P1014
The underlying table for model (not available) does not exist.

someone know what i'm doing wrong?

prisma version: 2.16.1

[mandaputtra]

You're maybe missing the model that you want to migrate. Can you share some code?

[snake-py]

You just saved my sanity.

[shamxeed]

@JDuarthe thanks! worked for me too!!

[iamthewalkingkode]

The above commands resets your DB. All data will be lost. Use at your own risk.

[The-Kevin]

Take care about this command, bro
this redefine the database, please avoid this command in production environment

[kiwavi]

Had a similar issue. The problem was that I had not committed one migration file that created the table but I had committed a migration file that was to edit that table. So it was trying to edit a table that was not created, hence the error. Fixed by staging the migration file for table creation.