Hi there, I've got a prisma connected to an SQL da...
# orm-help
c
Hi there, I've got a prisma connected to an SQL database locally. Our init migration succeeds in creating the tables and several other migrations run, but we get 1 migration that constantly fails. Even if i delete this migration and add anything new to the schema, every new migration also fails. We've tried everything in the docs to resolve this migration but nothing seems to work. This is the erorr we get:
Copy code
Error: P3006

Migration `20210624184346_added_slug_name` failed to apply cleanly to the shadow database. 
Error code: P3018
Error:
A migration failed to apply. New migrations cannot be applied before the error is recovered from. Read more about how to resolve migration issues in a production database: <https://pris.ly/d/migrate-resolve>

Migration name: 20210624184346_added_slug_name

Database error code: 1146

Database error:
Table 'prisma_migrate_shadow_db_8ffd3d5c-5d54-4052-91f9-c30857576558.applicationconfig' doesn't exist

Please check the query number 1 from the migration file.
furthermore seems to happen mostly when a column is added using alter table
r
@Cory Da Silva 👋 It would be great if you could create an issue here with steps and the alter table migration that is causing this so that we can check.
c
thanks @Ryan ive created ticket https://github.com/prisma/prisma/issues/8888
🙌 1