Hi guys,
Error: `The table `publicProducts` does ...
# orm-helpn
Naotho Machida
07/27/2021, 12:23 PMHi guys,
Error: `The table
publicProducts✅ 1
r
Ryan
07/27/2021, 12:35 PM@Naotho Machida 👋
Does the database URL match the one on AWS? Sometimes that might be causing an issue.
n
Naotho Machida
07/27/2021, 1:21 PMHi @Ryan, yes
Naotho Machida
07/27/2021, 1:21 PMMySQL is hosted in the same server
a
alisalimli
07/27/2021, 1:24 PMdo you apply migrations ?
alisalimli
07/27/2021, 1:28 PMconnect the database and make sure tables created
n
Naotho Machida
07/27/2021, 1:33 PMI run
npx prisma db pushNaotho Machida
07/27/2021, 1:34 PMafter this I imported the mySQL
a
alisalimli
07/27/2021, 1:35 PMrun npx prisma deploy,afterward npx prisma generate
alisalimli
07/27/2021, 1:35 PMit should create the tables
n
Naotho Machida
07/27/2021, 1:37 PMa
alisalimli
07/27/2021, 1:42 PMoh i mean npx prisma migrate deploy
n
Naotho Machida
07/27/2021, 1:43 PMok! 😁
Naotho Machida
07/27/2021, 1:44 PMI think I'm skipping some step
Naotho Machida
07/27/2021, 1:44 PMNaotho Machida
07/27/2021, 1:45 PMWhich step I deploy the prisma on other server?
a
alisalimli
07/27/2021, 1:45 PMwhy you don't create migrations
alisalimli
07/27/2021, 1:45 PMn
Naotho Machida
07/27/2021, 1:45 PMI've clonned my repo in AWS after I imported MySQL
a
alisalimli
07/27/2021, 1:45 PMyou should read docs
n
Naotho Machida
07/27/2021, 1:45 PMok!
Naotho Machida
07/27/2021, 1:45 PMI'll look at
a
alisalimli
07/27/2021, 1:46 PMrun npx prisma migrate,then migrate deploy
n
Naotho Machida
07/27/2021, 4:01 PMHi guys... solved the problem
Naotho Machida
07/27/2021, 4:03 PMWhen I've imported the db in mysql the name of table was all in lowercase
Naotho Machida
07/27/2021, 4:03 PMin dev table name = 'publicproducts' all ok
Naotho Machida
07/27/2021, 4:03 PMin AWS table name = 'publicproducts' but not works
Naotho Machida
07/27/2021, 4:04 PMI run
running npx prisma db pushNaotho Machida
07/27/2021, 4:04 PMand imported csv data exported from my local mySQL
Naotho Machida
07/27/2021, 4:04 PMand ok now!
Naotho Machida
07/27/2021, 4:04 PMNow AWS table is publicProducts (same name of model)
Naotho Machida
07/27/2021, 4:05 PMbut in dev table is 'publicproducts' and works too
2 Views