NevTheReal Posts - Answer Overflow

NevTheReal

•Created by NevTheReal on 5/30/2024 in #help

drizzle kit not migrating to turso properly

I have this little app with this schema https://github.com/nevthereal/codoodle/blob/main/src/lib/server/db/schema.ts And if I generate an sql file it will output something different, meaning not in the same order. First the posts table, then sessions and on the bottom users. I don't know if the order actually affects the migration, but i think it does. When I run the migration I always get some libsql error with the code 500. Important to note: my db on turso was created with --type schema if this has any importance. but anyways. Always when I want to run the migration, I get this 500 error code:

LibsqlError: SERVER_ERROR: Server returned HTTP status 500
    at mapHranaError (file:///Users/nevillebrem/Developer/Projects/codoodle/node_modules/@libsql/client/lib-esm/hrana.js:257:16)
    at HttpClient.execute (file:///Users/nevillebrem/Developer/Projects/codoodle/node_modules/@libsql/client/lib-esm/http.js:53:19)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async Object.run (/Users/nevillebrem/Developer/Projects/codoodle/node_modules/drizzle-kit/bin.cjs:111592:15)
    at async sqlitePush (/Users/nevillebrem/Developer/Projects/codoodle/node_modules/drizzle-kit/bin.cjs:114608:13)
    at async Command.<anonymous> (/Users/nevillebrem/Developer/Projects/codoodle/node_modules/drizzle-kit/bin.cjs:121490:7) {
  code: 'SERVER_ERROR',
  rawCode: undefined,
  [cause]: HttpServerError: Server returned HTTP status 500
      at errorFromResponse (file:///Users/nevillebrem/Developer/Projects/codoodle/node_modules/@libsql/hrana-client/lib-esm/http/stream.js:363:12)
      at process.processTicksAndRejections (node:internal/process/task_queues:95:5) {
    status: 500
  }
}

LibsqlError: SERVER_ERROR: Server returned HTTP status 500
    at mapHranaError (file:///Users/nevillebrem/Developer/Projects/codoodle/node_modules/@libsql/client/lib-esm/hrana.js:257:16)
    at HttpClient.execute (file:///Users/nevillebrem/Developer/Projects/codoodle/node_modules/@libsql/client/lib-esm/http.js:53:19)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async Object.run (/Users/nevillebrem/Developer/Projects/codoodle/node_modules/drizzle-kit/bin.cjs:111592:15)
    at async sqlitePush (/Users/nevillebrem/Developer/Projects/codoodle/node_modules/drizzle-kit/bin.cjs:114608:13)
    at async Command.<anonymous> (/Users/nevillebrem/Developer/Projects/codoodle/node_modules/drizzle-kit/bin.cjs:121490:7) {
  code: 'SERVER_ERROR',
  rawCode: undefined,
  [cause]: HttpServerError: Server returned HTTP status 500
      at errorFromResponse (file:///Users/nevillebrem/Developer/Projects/codoodle/node_modules/@libsql/hrana-client/lib-esm/http/stream.js:363:12)
      at process.processTicksAndRejections (node:internal/process/task_queues:95:5) {
    status: 500
  }
}

if i then go to turso.tech/app to view the tables in their embedded drizzle studio i get this message: Cannot read properties of undefined (reading 'id') and if i use local drizzle studio, i only see the posts table.

1 replies

DTDrizzle Team

•Created by NevTheReal on 1/3/2024 in #help

SQLite error: no such table: main.__old_push_users

I am currently trying to build a blog in sveltekit using lucia auth as the auth provider. I just can't create any user because I always get this error:

code: 'SQLITE_UNKNOWN',
  rawCode: undefined,
  [cause]: [ResponseError: SQLite error: no such table: main.__old_push_users] {
    code: 'SQLITE_UNKNOWN',
    proto: {
      message: 'SQLite error: no such table: main.__old_push_users',
      code: 'SQLITE_UNKNOWN'
    }
  }
}

code: 'SQLITE_UNKNOWN',
  rawCode: undefined,
  [cause]: [ResponseError: SQLite error: no such table: main.__old_push_users] {
    code: 'SQLITE_UNKNOWN',
    proto: {
      message: 'SQLite error: no such table: main.__old_push_users',
      code: 'SQLITE_UNKNOWN'
    }
  }
}

I can give additional information to this, but help pls

4 replies

DTDrizzle Team

•Created by NevTheReal on 11/22/2023 in #help

New to Drizzle

Hey there, I am relatively new to drizzle and all that stuff, but I want to understand how to use it with my Skeleton UI (SvelteKit + Tailwind) App. I want to use Supabase as my db. Maybe can somebody help me try to set up a todo app or a blog or so 🙂

1 replies

Gaming

Programming