Prisma•2y ago

PrismaClientInitializationError

Hey can anybody please help me out with this, i've tried rechecking the .env file, restarted servers, "stack overflow"d for hours...please do kindly help me out here.

RaphaelEtim•8/1/24, 1:41 PM

Hi @Arkana

What does your connection string look like for your environment variable

DATABASE_URL

DATABASE_URL

RaphaelEtim•8/1/24, 1:42 PM

I can see that your provider is sqlitesqlite. Your connection string should look like

"file:../dev.db"

"file:../dev.db"

ArkanaOP•8/1/24, 2:03 PM

yes it does

ArkanaOP•8/1/24, 2:04 PM

probably shouldn't have uploaded the .env file lol but i really need this fixed asap

ArkanaOP•8/1/24, 2:08 PM

@RaphaelEtim

Original message was deleted

gnarley_farley.•8/1/24, 2:17 PM

You mad bro. Remove this

ArkanaOP•8/1/24, 2:18 PM

ArkanaOP•8/1/24, 2:18 PM

i think this should do!

gnarley_farley.•8/1/24, 2:19 PM

You using an sql lite db?

gnarley_farley.•8/1/24, 2:20 PM

First go setup a proper db. Postgres or SQl. Then Put the details in. Then go from there. No one really using sqlite in production.

gnarley_farley.•8/1/24, 2:20 PM

I would not spend hours trying to fix that

ArkanaOP•8/1/24, 2:33 PM

i just need this to work! TwT

ArkanaOP•8/1/24, 2:33 PM

not for production tbf

gnarley_farley.•8/1/24, 2:37 PM

What framework are you using? nextjs?

gnarley_farley.•8/1/24, 2:41 PM

Just came across this, might be relevant to your use case

Ggnarley_farley.What framework are you using? nextjs?

ArkanaOP•8/1/24, 2:44 PM

yes

Ggnarley_farley.Just came across this, might be relevant to your use case

ArkanaOP•8/1/24, 2:45 PM

ohhh! alr

ArkanaOP•8/1/24, 2:45 PM

thanks a ton man :)

gnarley_farley.•8/1/24, 2:48 PM

Im currently also trying to get it working on nextjs with app directory

gnarley_farley.•8/1/24, 2:48 PM

Not fun at all. Not sure why but they are still not edge compatible

ArkanaOP•8/1/24, 2:50 PM

well one needs to add this to their package.json

ArkanaOP•8/1/24, 2:50 PM

also take care of typesafety

ArkanaOP•8/1/24, 2:50 PM

fml

Ggnarley_farley.Not fun at all. Not sure why but they are still not edge compatible

ArkanaOP•8/1/24, 2:50 PM

yeah man true, new day new bug :3

gnarley_farley.•8/1/24, 2:54 PM

Yeah it's always been quite clunky. I was willing to deal with that. But this is the final straw for me

gnarley_farley.•8/1/24, 2:54 PM

I will report if I find a solution

Original message was deleted

ArkanaOP•8/1/24, 2:59 PM

i tried drizzle lmao, faced a few issues there too smh

ArkanaOP•8/1/24, 3:00 PM

yeah i got rid of sqlite and going for postgres

ArkanaOP•8/1/24, 3:00 PM

any clue about this error mate?

gnarley_farley.•8/1/24, 3:01 PM

Thats to do with the encoding in your strings

gnarley_farley.•8/1/24, 3:01 PM

Check you might have some stuff where you are writing words or text on your page

gnarley_farley.•8/1/24, 3:01 PM

You need to use escape characters instead of apostrophes etc

gnarley_farley.•8/1/24, 3:02 PM

You can usually also get around it by using certain brackets and things

gnarley_farley.•8/1/24, 3:04 PM

gnarley_farley.•8/1/24, 3:04 PM

There are various strategies to avoid it. Just give it a google. Usually happens when you typing text directly into the components like that

gnarley_farley.•8/1/24, 3:05 PM

You can create seperate config files for your website then import those variables. It works well and is a neat way to work

ArkanaOP•8/1/24, 3:13 PM

yeah fixed it but more new errors smh

ArkanaOP•8/1/24, 3:14 PM

post implicitly has any type here, ts and it's typesafety TwT

ArkanaOP•8/1/24, 3:14 PM

i'll kms

AArkana post implicitly has any type here, ts and it's typesafety TwT

ArkanaOP•8/1/24, 3:14 PM

that's refraining me from deploying it. throwing an error lol

gnarley_farley.•8/1/24, 3:20 PM

Try chatgpt or claude to show you how to do all the type assertions.

gnarley_farley.•8/1/24, 3:20 PM

You can change the rules as well. But best to just fix it.

gnarley_farley.•8/1/24, 3:21 PM

post: {id: string, title:string}

ArkanaOP•8/1/24, 3:29 PM

yeah doing that manually rn

ArkanaOP•8/1/24, 3:29 PM

time consuming

gnarley_farley.•8/1/24, 3:33 PM

That's typescript for you. But very much worth it

ArkanaOP•8/1/24, 3:39 PM

what even are these

ArkanaOP•8/1/24, 3:43 PM

is prisma not compatible with pnpm?

ArkanaOP•8/1/24, 3:43 PM

god knows why i decided trying out pnpm for this project smh