chris_st Posts - Answer Overflow

chris_st

Explore posts from servers

•Created by chris_st on 4/20/2025 in #help

The table `main.verification` does not exist in the current database.

hey - trying to use better-auth with hono on cloudflare pages, currently just with a local database. Got hono and the database talking, tried to add better-auth with prisma, and I'm getting the following error:

``
<-- POST /start-sign-in
/start-sign-in sees email [email protected]
c.env.DATABASE_URL undefined
<-- POST /api/auth/email-otp/send-verification-otp
# SERVER_ERROR:  PrismaClientKnownRequestError:
Invalid

prisma.verification.create()

 invocation:


The table

main.verification` does not exist in the current database. at zn.handleRequestError (/Users/chris/hacks/podcast-time-machine/experiments/tmp/hono-prisma-d1/node_modules/@prisma/client/runtime/library.js:121:7459) at zn.handleAndLogRequestError (/Users/chris/hacks/podcast-time-machine/experiments/tmp/hono-prisma-d1/node_modules/@prisma/client/runtime/library.js:121:6784) at zn.request (/Users/chris/hacks/podcast-time-machine/experiments/tmp/hono-prisma-d1/node_modules/@prisma/client/runtime/library.js:121:6491) at async l (/Users/chris/hacks/podcast-time-machine/experiments/tmp/hono-prisma-d1/node_modules/@prisma/client/runtime/library.js:130:9778) at async Object.create (file:///Users/chris/hacks/podcast-time-machine/experiments/tmp/hono-prisma-d1/node_modules/better-auth/dist/adapters/prisma-adapter/index.mjs:92:16) at async Object.create (file:///Users/chris/hacks/podcast-time-machine/experiments/tmp/hono-prisma-d1/node_modules/better-auth/dist/shared/better-auth.rSYJCd3o.mjs:388:19) at async createWithHooks (file:///Users/chris/hacks/podcast-time-machine/experiments/tmp/hono-prisma-d1/node_modules/better-auth/dist/shared/better-auth.Bk5IMdhM.mjs:49:71) coninued in comment

13 replies

BABetter Auth

•Created by chris_st on 3/21/2025 in #help

Server email OTP authentication

It appears, from reading the docs, that email-and-password can be done if you're doing server-side auth only, however email-OTP is not currently supported. Am I missing something? I've got it working by having the server use the client library, but that's kind of ugly. Thanks!

5 replies

DTDrizzle Team

•Created by chris_st on 10/19/2024 in #help

Problem with findMany with many-to-many relations

First, here's my schema file:


import { integer, primaryKey, sqliteTable, text } from 'drizzle-orm/sqlite-core'
import { relations } from 'drizzle-orm'

export const Entries = sqliteTable('Entries', {
  Id: integer('Id', { mode: 'number' }).primaryKey({ autoIncrement: true }),
  PersonId: integer('PersonId', { mode: 'number' }).notNull(),
  Content: text('Content').notNull(),
  Timestamp: text('Timestamp').notNull(),
})

export const EntriesRelations = relations(Entries, ({ many }) => ({
  EntriesTags: many(EntriesTags),
}))

export const Tags = sqliteTable('Tags', {
  Id: integer('Id', { mode: 'number' }).primaryKey({ autoIncrement: true }),
  Tag: text('Tag').notNull(),
})

export const TagsRelations = relations(Tags, ({ many }) => ({
  EntriesTags: many(EntriesTags),
}))

export const EntriesTags = sqliteTable(
  'EntriesTags',
  {
    EntryId: integer('EntryId', { mode: 'number' })
      .notNull()
      .references(() => Entries.Id),
    TagId: integer('TagId', { mode: 'number' })
      .notNull()
      .references(() => Tags.Id),
  },
  (t) => ({
    pk: primaryKey({ columns: [t.EntryId, t.TagId] }),
  })
)

export const EntriesTagsRelations = relations(
  EntriesTags,
  ({ one }) => ({
    Entry: one(Entries, {
      fields: [EntriesTags.EntryId],
      references: [Entries.Id],
    }),
    Tag: one(Tags, {
      fields: [EntriesTags.TagId],
      references: [Tags.Id],
    }),
  })
)

6 replies

DTDrizzle Team

•Created by chris_st on 10/15/2024 in #help

Help with 'in' queries

Hi - sorry if this has been asked, but it's kind of hard to search for! If it helps, I'm using cloudflare's D1 database (sqlite). What I'd like to do is the following query: select id, tag from tags where tag in ('foo', 'bar', 'baz'); The closest I can get so far is: const tagsAlreadyThere = await getEntriesDb(context).run( Select Id, Tag from LFLGTags where Tag in (${tags.map((t) => '${t}').join(', ')}) ) But that fails if a tag has a single quote in it... I'd like to do something like a prepare statement, but I haven't been able to figure out how to do that in this case. If there's a better way to do such a query I'd be glad to find it... the nice thing about it is it's a single query, rather than querying for each tag individually. Thanks!

2 replies

Gaming

Programming