Error validating: You defined the enum but the current connector does not support enums

Question

This is React JS project in which I'm transferring DB from postgres to sqlite, in schema.prisma file I'm writing enum for some tables and it gives me an error that Error validating: You defined the enum but the current connector does not support enums. Any help is appreciated.

score 0 · Answer 1 · answered Jul 12 '22 at 13:33

0

I just follow these steps indicates in this then add all the migration files into migration folder and ran yarn db-migrate problem resolved, hope it'll help to someone.

answered Jul 12 '22 at 13:33

Riddhi

755
11
31

score 0 · Answer 2 · answered Nov 05 '22 at 17:59

0

Prisma seems to have removed their shim for enums in sqlite back in 2020. See issue Prisma issue #1906 for details.

You might find this answer helpful in seeking out an alternative to using enums:

How to create ENUM type in SQLite?

answered Nov 05 '22 at 17:59

Ash Ryan Arnwine

1,471
1
11
27

Error validating: You defined the enum but the current connector does not support enums

2 Answers2