Local sqlite db in monorepo with nextJS trying to find table 'main.TABLE' instead of 'TABLE'

Hi,

I'm running a monorepo with my db separate from my NextJS package, and have already implemented the workaround plugin to let it find the external DB.

It's my first time trying to get anything to show up, and I'm now getting an error in the frontend:

Invalid

prisma.builtPrompt.findMany()

prisma.builtPrompt.findMany()

invocation:
The table

main.BuiltPrompt

main.BuiltPrompt

does not exist in the current database.

The table

BuildPrompt

BuildPrompt

definitely exists, and I don't know where the

main.

main.

came from; I can see the rows in Prisma studio. My googling suggested it might be a migration problem, but I don't know enough about that to know next. I've

migrate dev

migrate dev

and am getting

"Datasource "db": SQLite database "dev.db" at "file:./dev.db"
Already in sync, no schema change or pending migration was found."

I'm stuck. What should I try?

Prisma•2y ago•

4 replies

Smitty

Local sqlite db in monorepo with nextJS trying to find table 'main.TABLE' instead of 'TABLE'

prisma.builtPrompt.findMany()

prisma.builtPrompt.findMany()

invocation:
The table

main.BuiltPrompt

main.BuiltPrompt

does not exist in the current database.

The table

BuildPrompt

BuildPrompt

definitely exists, and I don't know where the

main.

main.

came from; I can see the rows in Prisma studio. My googling suggested it might be a migration problem, but I don't know enough about that to know next. I've

migrate dev

migrate dev

and am getting

"Datasource "db": SQLite database "dev.db" at "file:./dev.db"
Already in sync, no schema change or pending migration was found."

I'm stuck. What should I try?

Local sqlite db in monorepo with nextJS trying to find table 'main.TABLE' instead of 'TABLE'

Similar Threads

Local sqlite db in monorepo with nextJS trying to find table 'main.TABLE' instead of 'TABLE'

Similar Threads

Similar Threads

Similar Threads