Error after first deploy

[abaudhuin]

After a first deploy i still get an error. I'm not too familiar with this env so I'm not sure where to check.

Everything logs ok in real time logs too:

Any idea why ?

[DiogoDuart3]

Same here, must be something to do with the wrangler file that sets up the database

[Dhravya]

Yeah! I think this is because the remote database migrations aren't there i guess? I'm looking into it. Thanks for letting me know

[DiogoDuart3]

Nah, by following the readme it will run the migrations on the cloudflare database and it works locally, its the cloudflare deployment that didnt read that file i guess

[DiogoDuart3]

The latest version of drizzle orm removed the driver "d1" and now has "d1-http"

[Dhravya]

Right, makes sense :)

there's a PR by @codetorso which i'll merge soon but that's the steps to fix it!

[abaudhuin]

Great. Feels kinda weird that there is no error anywhere though

[DiogoDuart3]

This is the error from the cloudflare functions

[Dhravya]

When you run it locally, the database used is actually a local sqlite instance. When deployed, it uses a remote version of the same database.

cd apps/web && wrangler d1 execute ${YOUR-DATABASE-NAME} --file=migrations/0000_setup.sql --remote

[Dhravya]

I fixed this issue in the setup script

[DiogoDuart3]

Running "bunx wrangler d1 migrations apply DB_NAME --remote" worked

[Dhravya]

Perfect!

[Dhravya]

@abaudhuin can you confirm this too?

[abaudhuin]

yes, I confirm it's deployed now! Thanks