hey, following D1 customers schema tutorial, i can run select with wrangler, but when using programa

C

ConstantinOP•11/24/23, 9:05 PM

const { results } = await ENV.DB.prepare("SELECT * from Customers")
    .bind("Customers")
    .all();

const { results } = await ENV.DB.prepare("SELECT * from Customers")
    .bind("Customers")
    .all();

const { results } = await ENV.DB.prepare("SELECT * from Customers")
    .bind("Customers")
    .all();

const { results } = await ENV.DB.prepare("SELECT * from Customers")
    .bind("Customers")
    .all();

C

ConstantinOP•11/24/23, 9:07 PM

    Cause:
  Error: no such table: Customers
      at D1Database._sendOrThrow (cloudflare-internal:d1-api:67:24)
      at async D1PreparedStatement.all (cloudflare-internal:d1-api:175:29)

    Cause:
  Error: no such table: Customers
      at D1Database._sendOrThrow (cloudflare-internal:d1-api:67:24)
      at async D1PreparedStatement.all (cloudflare-internal:d1-api:175:29)

    Cause:
  Error: no such table: Customers
      at D1Database._sendOrThrow (cloudflare-internal:d1-api:67:24)
      at async D1PreparedStatement.all (cloudflare-internal:d1-api:175:29)

    Cause:
  Error: no such table: Customers
      at D1Database._sendOrThrow (cloudflare-internal:d1-api:67:24)
      at async D1PreparedStatement.all (cloudflare-internal:d1-api:175:29)

CConstantin hey, following D1 customers schema tutorial, i can run select with wrangler, but...

M

Matt Silverlock•11/24/23, 9:27 PM

Are you getting “no such table: users” (as per your comment) or “no such table: customers” as per the error text you posted? Did you create the table first?

L

liorgr•11/24/23, 9:29 PM

Am I the only one experiencing issues with D1?
Dashboard doesn’t load & API calls are failing

C

ConstantinOP•11/24/23, 9:29 PM

sorry i was testing with both users and Consumers. yes the consumers table is created and i can query it.

C

ConstantinOP•11/24/23, 9:30 PM

from wrangler it works, but from the code Astro it does not

C

ConstantinOP•11/24/23, 9:30 PM

the KV however works ..

L

liorgr•11/24/23, 9:36 PM

D1 dashboard is stuck, is it only for me?

L

liorgr•11/24/23, 9:37 PM

And an API token that worked up until 2 hours ago is not working, even though it says it’s active and no changes were made

L

liorgr•11/24/23, 9:48 PM

@Alexander.Xtreme I get the same

L

liorgr•11/24/23, 9:48 PM

Also if you check the network request for the dashboard, it gets similar error

L

liorgr•11/24/23, 9:49 PM

I’ve opened a support ticket

G

gf•11/24/23, 9:53 PM

same here

C

ConstantinOP•11/24/23, 9:57 PM

@nora my remode database has no tables in it .. does the request is trying to look to the remote instead of the local db ?

C

ConstantinOP•11/24/23, 9:58 PM

[[d1_databases]]
binding = "DB"                                               # i.e. available in your Worker on env.DB
database_name = "user"
database_id = "97285d4c-b85d-4df9-b44f-d4411fe1cbbc"
preview_database_id = "97285d4c-b85d-4df9-b44f-d4411fe1cbbc"

[[d1_databases]]
binding = "DB"                                               # i.e. available in your Worker on env.DB
database_name = "user"
database_id = "97285d4c-b85d-4df9-b44f-d4411fe1cbbc"
preview_database_id = "97285d4c-b85d-4df9-b44f-d4411fe1cbbc"

[[d1_databases]]
binding = "DB"                                               # i.e. available in your Worker on env.DB
database_name = "user"
database_id = "97285d4c-b85d-4df9-b44f-d4411fe1cbbc"
preview_database_id = "97285d4c-b85d-4df9-b44f-d4411fe1cbbc"

[[d1_databases]]
binding = "DB"                                               # i.e. available in your Worker on env.DB
database_name = "user"
database_id = "97285d4c-b85d-4df9-b44f-d4411fe1cbbc"
preview_database_id = "97285d4c-b85d-4df9-b44f-d4411fe1cbbc"

C

ConstantinOP•11/24/23, 9:58 PM

this is my binding

C

ConstantinOP•11/24/23, 10:02 PM

oh, found it

C

Cyb3r-Jak3•11/24/23, 10:03 PM

Raised the wrangler create issue

C

ConstantinOP•11/24/23, 10:03 PM

[[d1_databases]]
binding = "DB"                                       # Should match preview_database_id
database_name = "user"
database_id = "97285d4c-b85d-4df9-b44f-d4411fe1cbbc"
preview_database_id = "DB"                           # Required for Pages local development

[[d1_databases]]
binding = "DB"                                       # Should match preview_database_id
database_name = "user"
database_id = "97285d4c-b85d-4df9-b44f-d4411fe1cbbc"
preview_database_id = "DB"                           # Required for Pages local development

[[d1_databases]]
binding = "DB"                                       # Should match preview_database_id
database_name = "user"
database_id = "97285d4c-b85d-4df9-b44f-d4411fe1cbbc"
preview_database_id = "DB"                           # Required for Pages local development

[[d1_databases]]
binding = "DB"                                       # Should match preview_database_id
database_name = "user"
database_id = "97285d4c-b85d-4df9-b44f-d4411fe1cbbc"
preview_database_id = "DB"                           # Required for Pages local development

C

ConstantinOP•11/24/23, 10:08 PM

ty @nora

Lliorgr D1 dashboard is stuck, is it only for me?

R

Rob M.•11/24/23, 10:32 PM

same here

B

Bakĉoj | Brandon•11/24/23, 10:34 PM

Oh thank god I'm not alone

R

Rob M.•11/24/23, 10:35 PM

I can access my D1 instance from the worker though blob_sweat

B

Bakĉoj | Brandon•11/24/23, 10:35 PM

Same

B

Bakĉoj | Brandon•11/24/23, 10:36 PM

But I can't run any migrations from wrangler

B

Bakĉoj | Brandon•11/24/23, 10:36 PM

It was working just fine, then all of a sudden everything stopped

J

James•11/24/23, 10:38 PM

You can't run any d1 commands with wrangler at all? What happens when you try?

B

Bakĉoj | Brandon•11/24/23, 10:41 PM

  POST method not allowed for the oauth_token authentication scheme [code: 10000]

  POST method not allowed for the oauth_token authentication scheme [code: 10000]

J

James•11/24/23, 10:42 PM

okay I think we're gonna raise this higher. Creating new DBs being broken is one thing, but migrations being broken is a big deal. Give us a moment

J

James•11/24/23, 10:42 PM

Thanks for the info all

JJames okay I think we're gonna raise this higher. Creating new DBs being broken is one...

M

Matt Silverlock•11/24/23, 10:44 PM

@rozenmd

A

andy__yo•11/24/23, 10:47 PM

Is there any starter repo for nextjs with CloudFlare D1 on Drizzle? I am new to the CloudFlare environment, I tried with bindings as per doc couldn't get that up running.

Aandy__yo Is there any starter repo for nextjs with CloudFlare D1 on Drizzle? I am new to...

M

Matt Silverlock•11/24/23, 10:48 PM

See https://developers.cloudflare.com/pages/framework-guides/deploy-a-nextjs-site/#use-bindings-in-your-nextjs-application

Deploy a Next.js site · Cloudflare Pages docs

Next.js is an open-source React framework for creating websites and applications. In this guide, you will create a new Next.js application and deploy …

M

Matt Silverlock•11/24/23, 10:51 PM

Hi folks - we’re having some API issues specific to D1 and expect to remediate shortly.

M

Matt Silverlock•11/24/23, 11:13 PM

@D1 Database Issues with the D1 API (including the dashboard) should now be resolved. We attempted to roll out an important fix, but introduced an authentication issue. We've rolled this back until we can re-test the fix.

MMatt Silverlock @D1 Database Issues with the D1 API (including the dashboard) should now be reso...

J

James•11/24/23, 11:16 PM

Thanks Matt. It might be good to get a retro status page up for this, just in case folks had hit errors in their CI and can correlate the time it happened to the status report.

C

ConstantinOP•11/24/23, 11:18 PM

is there a cloudflare features roadmap? i'm curious in an auth/user management feature

MMatt Silverlock @D1 Database Issues with the D1 API (including the dashboard) should now be reso...

R

Rob M.•11/24/23, 11:22 PM

Still can't access the D1 Dashboard blobhaj

CConstantin is there a cloudflare features roadmap? i'm curious in an auth/user management f...

C

Cyb3r-Jak3•11/24/23, 11:23 PM

Non I’m aware of. They do typically announce stuff with blog posts so can follow those

C

ConstantinOP•11/24/23, 11:30 PM

it's the last missing part of the puzzle imho

. it feels bad to use a 3rd party provider (hosted in a different region/cloud infra) and wait for users to login. i'm implementing my own, however users has been allways a hard thing to reason about

MMatt Silverlock @D1 Database Issues with the D1 API (including the dashboard) should now be reso...

M

Max (@rozenmd)•11/24/23, 11:32 PM

Should be working now in EMEA

U

Unsmart•11/24/23, 11:32 PM

Tbh doing your own auth is a million times better than using a service even if the cloud service you host on is the one offering it. Lucia auth works wonders and has D1 compat. @cmnstmntmn

C

ConstantinOP•11/24/23, 11:35 PM

indeed now i'm setting it up

UUnsmart Tbh doing your own auth is a million times better than using a service even if t...

I

Isaac McFadyen•11/24/23, 11:35 PM

That's very much an opinion though, I'd argue at larger scales it's a lot of extra work to do your own auth

I

Isaac McFadyen•11/24/23, 11:36 PM

For an indie dev or startup? Maybe best.

I

Isaac McFadyen•11/24/23, 11:36 PM

For a big business who just wants to focus on their business? Maybe not.

U

Unsmart•11/24/23, 11:36 PM

Everything is always opions of course but mine is right Kapp

C

ConstantinOP•11/24/23, 11:37 PM

yeah, and i really had bad experiences before with auth0 .. never again

hey, following D1 customers schema tutorial, i can run select with wrangler, but when using programa

Similar Threads

Similar Threads

Similar Threads