stridex
CDCloudflare Developers
•Created by stridex on 4/26/2024 in #d1-database
i'm getting `Error: D1_ERROR: D1 is
i think i found a place i was missing an index
4 replies
CDCloudflare Developers
•Created by stridex on 4/26/2024 in #d1-database
i'm getting `Error: D1_ERROR: D1 is
It was running just a basic select across a few columns. Nothing had changed when it started happening. It’s an app for myself basically.
SELECT DISTINCT releases.name, releases.group, releases.category, releases.size, releases.files,
releases.resolution, releases.source, releases.updatedAt, releases.imdb_id
FROM releases
LEFT JOIN movies ON movies.imdb_id = releases.imdb_id
WHERE (
movies.imdb_rating_votes > ? AND releases.resolution = ? AND releases.name not like ?
)
ORDER BY releases.updated_at DESC
LIMIT ?
4 replies
CDCloudflare Developers
•Created by stridex on 4/26/2024 in #d1-database
i'm getting `Error: D1_ERROR: D1 is
database id
aa76b36d-692e-423b-9718-aabfafb4588a
4 replies