boba Posts - Answer Overflow

boba

•Created by boba on 9/11/2024 in #help

migration problem

Hello everybody, this is my first time using drizzle and using an sql library for the first time. I was wondering why am I getting this error?

[⣯] applying migrations...LibsqlError: SQL_INPUT_ERROR: SQL input error: table `platforms` already exists (at offset 13)
    at mapHranaError (file:///Users/bobasafe/DevLink/Link-Sharing/linksharing/node_modules/@libsql/client/lib-esm/hrana.js:262:16)
    at HttpClient.batch (file:///Users/bobasafe/DevLink/Link-Sharing/linksharing/node_modules/@libsql/client/lib-esm/http.js:118:19)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at LibSQLSession.batch (/Users/bobasafe/DevLink/Link-Sharing/linksharing/node_modules/src/libsql/session.ts:75:24)
    at migrate (/Users/bobasafe/DevLink/Link-Sharing/linksharing/node_modules/src/libsql/migrator.ts:50:2) {
  code: 'SQL_INPUT_ERROR',
  rawCode: undefined,
  [cause]: [ResponseError: SQL input error: table `platforms` already exists (at offset 13)] {
    code: 'SQL_INPUT_ERROR',
    proto: {
      message: 'SQL input error: table `platforms` already exists (at offset 13)',
      code: 'SQL_INPUT_ERROR'
    }
  }
}

[⣯] applying migrations...LibsqlError: SQL_INPUT_ERROR: SQL input error: table `platforms` already exists (at offset 13)
    at mapHranaError (file:///Users/bobasafe/DevLink/Link-Sharing/linksharing/node_modules/@libsql/client/lib-esm/hrana.js:262:16)
    at HttpClient.batch (file:///Users/bobasafe/DevLink/Link-Sharing/linksharing/node_modules/@libsql/client/lib-esm/http.js:118:19)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at LibSQLSession.batch (/Users/bobasafe/DevLink/Link-Sharing/linksharing/node_modules/src/libsql/session.ts:75:24)
    at migrate (/Users/bobasafe/DevLink/Link-Sharing/linksharing/node_modules/src/libsql/migrator.ts:50:2) {
  code: 'SQL_INPUT_ERROR',
  rawCode: undefined,
  [cause]: [ResponseError: SQL input error: table `platforms` already exists (at offset 13)] {
    code: 'SQL_INPUT_ERROR',
    proto: {
      message: 'SQL input error: table `platforms` already exists (at offset 13)',
      code: 'SQL_INPUT_ERROR'
    }
  }
}

I deleted the migration folder (because i was looking up the discord to see if anyone has the same issue), generated it, and once I used the migrate command it it gave me this error

16 replies

Gaming

Programming