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.
GitHub
codoodle/src/lib/server/db/schema.ts at main · nevthereal/codoodle
A SvelteKit blog with Turso. Contribute to nevthereal/codoodle development by creating an account on GitHub.
0 Replies
No replies yetBe the first to reply to this messageJoin
Want results from more Discord servers?
Add your server