Issue setting this up (fails at `Configure Database`)

[rfgamaral]

Hi there! 👋

First, thank you for creating this tool, it looks genuinely useful, and I’m excited to try it out.

I’ve been going through the installation steps, but I’ve run into an issue during step 3 of the README (“Apply schema (for new deployments)”). Here’s what I’m seeing:

PS C:\Users\Ricardo\Workspace\Personal\statusflare> pnpm dlx wrangler d1 execute statusflare-db --remote --file=db/schema-v4.sql

⛅️ wrangler 4.47.0
───────────────────
Resource location: remote

√ ⚠️ This process may take some time, during which your D1 database will be unavailable to serve queries.
Ok to proceed? ... yes
🌀 Executing on remote database statusflare-db (f1dc8592-redacted-the-rest):
🌀 To execute on your local development database, remove the --remote flag from your wrangler command.
Note: if the execution fails to complete, your DB will return to its original state and you can safely retry.
🌀 File already uploaded. Processing.

✘ [ERROR] no such table: main.slos: SQLITE_ERROR

It seems like the schema isn’t being applied correctly, or it’s referencing a table that doesn’t exist yet. Is there something I might be missing before running the schema file?

I also have a question regarding STATUSFLARE_ADMIN_PASSWORD: should this be an arbitrary password that I define myself, or is it meant to be an API key generated on Cloudflare? If it’s the latter, which permissions should that API key have?

[F1xx]

I am getting the exact same error during install. Was hoping to find an answer here, any solution?

[F1xx]

I actually managed to fix this problem if anyone comes into this.

Go into /db and open schema-v4.sql

Move all CREATE TABLE IF NOT EXISTS sections above the CREATE INDEX IF NOT EXISTS section.

It was trying to index tables it hadn't created yet.