Database v1 tables have not been detected.

[nkilm]

Hey I've followed all the instructions mentioned in migration guide, but I still get the following error.

I have all the tables which were created in by umami v1. See the below screenshot displaying all the tables.

I am using planetscale to store all umami data. v1 is working smoothly with no errors. Also I am deployed the site to vercel.

[franciscao633]

planetscale is tricky because of the foreign key constraints did not mix well with prisma migrations. Can you check your _prisma_migrations table and let me know what records are there.

[nkilm]

I don't have _prisma_migrations table in my database😅

I followed this guide https://umami.is/docs/running-on-vercel and deployed directly on vercel.

[nkilm]

How do I update my schema to v1(latest) for my planetscale db? It is mentioned in the docs. I am not sure how to check if the schema in my database is of latest version for v1 or not.

[franciscao633]

Can you check if you event / account table have UUID columns? If so I think you should have the latest and you can follow the steps below. I'm hoping we can get planetscale to work.

1. Inside your Umami folder run yarn build-db
2. then run npx prisma migrate resolve --applied 04_add_uuid
3. the run the migration npx @umami/migrate-v1-v2@latest

[nkilm]

Yeah both event and account tables have uuid column.

[nkilm]

But the command you provided is not working.

I don't have that migration.

[franciscao633]

I apologize. The 04_add_uuid migration only exists in v1.4. You would need to run all those commands on v1.4, then upgrade your app to 2.0.

[nkilm]

Where do I find those commands?

[franciscao633]

Some are prisma commands, which can be found here. Also package.json contains commands under scripts.

[nkilm]

@franciscao633 how do I check which version of the database schema do I have? In which table is this stored?