Drizzle Team•11mo ago

push:sqlite error _old_push table with turso

is there any known workaround for this issue: https://github.com/drizzle-team/drizzle-orm/issues/1313 adding a column to a table and calling db:push gives a 500 error due to a _oldpushtablename being created causing some issues

GitHub

[BUG]: drizzle-kit push:sqlite fails to copy table data after addin...

What version of drizzle-orm are you using? 0.28.6([email protected]) What version of drizzle-kit are you using? 0.19.13 Describe the Bug After adding a column to a table in schema, and executing...

5 Replies

Matan Nahmani•10mo ago

any updates?

philbookst•10mo ago

I don’t think so 😵‍💫

Matan Nahmani•10mo ago

@philbookst did you even ran across this error SQL_INPUT_ERROR? when i insert a new column it inserts it but the push just dosen't work well, it keeps throwing error even though it alterd the db

LibsqlError: SQL_INPUT_ERROR: SQL input error: no such column: provider_review_id (at offset 82)
    at mapHranaError (file:///home/matan/code/downtoeat/node_modules/@libsql/client/lib-esm/hrana.js:257:16)
    at HttpClient.execute (file:///home/matan/code/downtoeat/node_modules/@libsql/client/lib-esm/http.js:53:19)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async TursoSqlite.run (/home/matan/code/downtoeat/node_modules/drizzle-kit/bin.cjs:25414:9)
    at async Command.<anonymous> (/home/matan/code/downtoeat/node_modules/drizzle-kit/bin.cjs:63359:9) {
  code: 'SQL_INPUT_ERROR',
  rawCode: undefined,
  [cause]: [ResponseError: SQL input error: no such column: provider_review_id (at offset 82)] {
    code: 'SQL_INPUT_ERROR',
    proto: {
      message: 'SQL input error: no such column: provider_review_id (at offset 82)',
      code: 'SQL_INPUT_ERROR'
    }
  }
}

LibsqlError: SQL_INPUT_ERROR: SQL input error: no such column: provider_review_id (at offset 82)
    at mapHranaError (file:///home/matan/code/downtoeat/node_modules/@libsql/client/lib-esm/hrana.js:257:16)
    at HttpClient.execute (file:///home/matan/code/downtoeat/node_modules/@libsql/client/lib-esm/http.js:53:19)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async TursoSqlite.run (/home/matan/code/downtoeat/node_modules/drizzle-kit/bin.cjs:25414:9)
    at async Command.<anonymous> (/home/matan/code/downtoeat/node_modules/drizzle-kit/bin.cjs:63359:9) {
  code: 'SQL_INPUT_ERROR',
  rawCode: undefined,
  [cause]: [ResponseError: SQL input error: no such column: provider_review_id (at offset 82)] {
    code: 'SQL_INPUT_ERROR',
    proto: {
      message: 'SQL input error: no such column: provider_review_id (at offset 82)',
      code: 'SQL_INPUT_ERROR'
    }
  }
}

philbookst•10mo ago

yes i think i also had this error sometimes

Gustavo CA•10mo ago

it happens something similar to me when I use references() method, so I've removed it for now

Gaming

Programming

push:sqlite error _old_push table with turso