Taylor Posts - Answer Overflow

Taylor

•Created by Taylor on 4/26/2024 in #pages-help

Working with D1 Remote DB locally with nextjs

So i'm using Cloudflare D1, I imported data into my remote Cloudflare D1 database, i didn't do this for the --local one and i don't really want to if possible. I want to just locally develop with the remote database. I have my binding setup and i created an API route like this

import type { NextRequest } from "next/server";
import { getRequestContext } from "@cloudflare/next-on-pages";
import { cases } from "@/schema";
import { CloudflareEnv } from "@/env";
import { db } from "@/db";

export const runtime = "edge";

export async function GET(request: NextRequest, env: CloudflareEnv) {
  const context = getRequestContext();

  const DB = db((context.env as CloudflareEnv).edendb);

  const result = await DB.select({
    CaseID: cases.CaseID,
    CasePriority: cases.CasePriority,
    CaseStatus: cases.CaseStatus,
    Pending: cases.Pending,
    Active: cases.Active,
    Closed: cases.Closed,
    NotReviewed: cases.NotReviewed,
  }).from(cases);

  return new Response(JSON.stringify(result), {
    status: 200,
    headers: {
      "Content-Type": "application/json",
    },
  });
}

import type { NextRequest } from "next/server";
import { getRequestContext } from "@cloudflare/next-on-pages";
import { cases } from "@/schema";
import { CloudflareEnv } from "@/env";
import { db } from "@/db";

export const runtime = "edge";

export async function GET(request: NextRequest, env: CloudflareEnv) {
  const context = getRequestContext();

  const DB = db((context.env as CloudflareEnv).edendb);

  const result = await DB.select({
    CaseID: cases.CaseID,
    CasePriority: cases.CasePriority,
    CaseStatus: cases.CaseStatus,
    Pending: cases.Pending,
    Active: cases.Active,
    Closed: cases.Closed,
    NotReviewed: cases.NotReviewed,
  }).from(cases);

  return new Response(JSON.stringify(result), {
    status: 200,
    headers: {
      "Content-Type": "application/json",
    },
  });
}

I deployed the site with pnpm run deploy everythings good and when i go to the live url/api/getallcases route, it works just as expected. But in local development I get a

✘ [ERROR] Error: D1_ERROR: no such table: Cases

✘ [ERROR] Error: D1_ERROR: no such table: Cases

I know this has something to do with the local vs remote database but I can't seem to figure out how to develop against it with Nextjs, could anyone help? I've gotten this error with both pnpm run dev (nextjs server) and pnpm wrangler pages dev

5 replies

CDCloudflare Developers

•Created by Taylor on 3/29/2024 in #pages-help

Succesful Bun Run Deploy in Console, deployment fails in Dashboard

Account id: 2681f1ed7639ad2477706a492ad7d1c5 projecturl: nextproject.pages.dev Console says it sucesfully compiles with

✨ Compiled Worker successfully
✨ Uploading Worker bundle
✨ Uploading _routes.json
✨ Deployment complete! Take a peek over at https://a0f33ef8.nextproject.pages.dev

✨ Compiled Worker successfully
✨ Uploading Worker bundle
✨ Uploading _routes.json
✨ Deployment complete! Take a peek over at https://a0f33ef8.nextproject.pages.dev

but I just see deployment failed in the dashboard, I have no idea where to find the logs or errors for it.
https://prnt.sc/sqntOfmHQx2Q

16 replies

CDCloudflare Developers

•Created by Taylor on 3/29/2024 in #pages-help

Pages won't let me add custom domain already active in CF Account

Accountid: 2681f1ed7639ad2477706a492ad7d1c5 Pages url: nextproject.pages.dev Custom domain: gitcloneship.com

11 replies

Gaming

Programming