"D1_ERROR: SqliteError: no such table"

Hello, I have a project that uses D1 and wrangler, so I generate the schema with drizzle, and then run apply my migrations to my database, I also confirmed that the id in my wrangler.toml is correct and the tables do exist on the D1 dashboard, confirmed the same thing with the CLI as well, but..... when I run wrangler dev and head to the server and send requests, I get the above error, I don't know why D1 can't find the table although it exists on both the CLI and the web dashboard, may someone please help me out here? Because I've been battling this since yesterday with no luck.
5 Replies
rynite
ryniteOP17mo ago
No description
rynite
ryniteOP17mo ago
while the dashboard shows
No description
rynite
ryniteOP17mo ago
no idea what's going on
Chaika
Chaika17mo ago
In wrangler 3.x, wrangler dev is using local dev, which has its own local tables/resources. If you want to run dev using live resources, you can use wrangler dev --remote
rynite
ryniteOP17mo ago
god bless you dude its finally working thanks

Did you find this page helpful?