Solved

New app scaffold: Error: Prisma session table does not exist.

zhicheng1
Shopify Partner
28 2 6

I have run "npm init @Shopify/app@latest" to scaffold a new app to become a new sales channel.  However, the app generated does not work out of the box.  I have already had to modify the shopify.web.toml file to add back in missing fields to get past the first error message.

 

Now I have another error message which is "Error: Prisma session table does not exist. This could happen for a few reasons, see https://github.com/Shopify/shopify-app-js/tree/main/packages/shopify-app-session-storage-prisma#trou... for more".  I never did anything to set up Prisma but is there anything I need to do?  Someone explain this problem to me.

 

 

Accepted Solution (1)

zhicheng1
Shopify Partner
28 2 6

This is an accepted solution.

I was able to solve the problem.  You have to run the site using "npm run dev" and not "shopify app dev" now unlike in prior versions of shopify cli.  That will run the db migration which is also how the db is created in the first place.

View solution in original post

Replies 4 (4)

tanmaykejriwal
Shopify Partner
59 1 5

Hi I see your problem 

1. Did you try clearing cache npm and retrying ?

2. Deleting project and retrying ?

3. editing schema.prisma file.

 

lmk if ya need help

TK

zhicheng1
Shopify Partner
28 2 6

This is an accepted solution.

I was able to solve the problem.  You have to run the site using "npm run dev" and not "shopify app dev" now unlike in prior versions of shopify cli.  That will run the db migration which is also how the db is created in the first place.

Boris__
Shopify Partner
1 0 1

Hi, I'm facing the same issue when deploying to DigitalOcean, and other providers like fly.io seem to be working fine. Do you know what might be the issue?

 

921Kiyo
Shopify Partner
15 0 1

Did you manage to fix this? For me, it works fine in fly.io but getting "Error: Prisma session table does not exist. This could happen for
a few reasons, see https://github.com/Shopify/shopify-app-js/tree/main/packages/shopify-ap
p-session-storage-prisma#troubleshooting for more information" when running locally.