prisma migration issue

[venkats-cr]

Unable to migrate the issue with prisma

Error: P3018

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: 20240415100000_added_category_id_field_in_product_table

Database error code: 1146

Database error:
Table 'newEcommerce.product' doesn't exist

Please check the query number 1 from the migration file.

[Kuzma02]

Hi @venkats-cr. Can you tell me more information about the error? Is this your first migration or have you run the project several times successfully before this? Also, did the error happen after your custom migration?

[venkats-cr]

This is my first migration , got this error Error: P3018 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: 20240415100000_added_category_id_field_in_product_table Database error code: 1146 Database error: Table 'newEcommerce.product' doesn't exist Please check the query number 1 from the migration file.

…

On Fri, 19 Jul 2024 at 15:05, Aleksandar Kuzmanović < ***@***.***> wrote: Hi @venkats-cr <https://github.com/venkats-cr>. Can you tell me more information about the error? Is this your first migration or have you run the project several times successfully before this? Also, did the error happen after your custom migration? — Reply to this email directly, view it on GitHub <#2 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/A5N2B4JAA3ENWLIFXFXBH3TZNDMWLAVCNFSM6AAAAABLEAXMTWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMZYG43DENZVGI> . You are receiving this because you were mentioned.Message ID: <Kuzma02/Electronics-eCommerce-Shop-With-Admin-Dashboard-NextJS-NodeJS/issues/2/2238762752 @github.com>

-- *Regards* *Venkatkumar S* *Phone: +91 9840077575* *www.cloudripples.io <http://www.cloudripples.io/> *

[Kuzma02]

I think you should watch the tutorial on running the project again and try to repeat the steps. The tutorial link is in the README. If you didn't see it, here is the link: https://www.youtube.com/watch?v=Ry0aOMws0gE

[Kuzma02]

@venkats-cr When you find a solution to the problem, please feel free to post it here.

[venkats-cr]

Will do, thanks!

…

On Fri, 19 Jul, 2024, 21:24 Aleksandar Kuzmanović, ***@***.***> wrote: @venkats-cr <https://github.com/venkats-cr> When you find a solution to the problem, please feel free to post it here. — Reply to this email directly, view it on GitHub <#2 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/A5N2B4KWVABXSWQQLEM6YQ3ZNEZEBAVCNFSM6AAAAABLEAXMTWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMZZGUYDGMRRGM> . You are receiving this because you were mentioned.Message ID: <Kuzma02/Electronics-eCommerce-Shop-With-Admin-Dashboard-NextJS-NodeJS/issues/2/2239503213 @github.com>

[venkats-cr]

Ok will check it out

…

On Fri, 19 Jul, 2024, 21:23 Aleksandar Kuzmanović, ***@***.***> wrote: I think you should watch the tutorial on running the project again and try to repeat the steps. The tutorial link is in the README. If you didn't see it, here is the link: https://www.youtube.com/watch?v=Ry0aOMws0gE — Reply to this email directly, view it on GitHub <#2 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/A5N2B4PO5O3K3U5PPVDWNDLZNEY7LAVCNFSM6AAAAABLEAXMTWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMZZGUYDCMZQGY> . You are receiving this because you were mentioned.Message ID: <Kuzma02/Electronics-eCommerce-Shop-With-Admin-Dashboard-NextJS-NodeJS/issues/2/2239501306 @github.com>

[Neutrino2019]

I had the same issue, and i was able to fix it. So here is the solution :

⚠The problem :

I use the latest mysql 9.1.0, and i also got the error :
Table 'newEcommerce.product' doesn't exist
▶ It's because previously, the product table was created with an uppercase first letter :

but later in the migration files, they use "product" without the first letter in uppercase :

⏩ So mysql table names are sensitive to case. And if you fix only "product", there will be other names to fix as they also have the upper case letter issue.

💡 The solution :

To fix this issue, i changed with a text editor all the table names's first letter to uppercase by editing the migration.sql (in your-project-directory\server\prisma\migrations\*\migration.sql) that is mentionned in the error. So Everytime, I run the command npx prisma migrate dev and fix the table name issue until there is no error. At the end the terminal proposed to reset the database, and i said "yes".

At the end you shoud get something like this :