Drizzle TeamDT
Drizzle Team•3y ago
Hugo

Can't migrate "Table already exist"

Error: Table 'carts_formulas' already exists
    at PromiseConnection.query (/Applications/MAMP/htdocs/streeteats/admin/node_modules/mysql2/promise.js:94:22)
    at MySql2PreparedQuery.execute (/Applications/MAMP/htdocs/streeteats/admin/node_modules/src/mysql2/session.ts:85:18)
    at MySql2Session.execute (/Applications/MAMP/htdocs/streeteats/admin/node_modules/src/mysql-core/session.ts:77:5)
    at MySql2Transaction.execute (/Applications/MAMP/htdocs/streeteats/admin/node_modules/src/mysql-core/db.ts:165:23)
    at /Applications/MAMP/htdocs/streeteats/admin/node_modules/src/mysql-core/dialect.ts:67:16
    at processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async MySql2Session.transaction (/Applications/MAMP/htdocs/streeteats/admin/node_modules/src/mysql2/session.ts:242:19)
    at async MySqlDialect.migrate (/Applications/MAMP/htdocs/streeteats/admin/node_modules/src/mysql-core/dialect.ts:60:3)
    at async migrate (/Applications/MAMP/htdocs/streeteats/admin/node_modules/src/mysql2/migrator.ts:10:2) {
  code: 'ER_TABLE_EXISTS_ERROR',
  errno: 1050,
  sql: '\n' +
    'CREATE TABLE `carts_formulas` (\n' +
    '\t`id_cart_formula` int AUTO_INCREMENT NOT NULL,\n' +
    '\t`id_cart` int,\n' +
    '\t`id_formula` int,\n' +
    '\t`quantity` int,\n' +
    '\tCONSTRAINT `carts_formulas_id_cart_formula` PRIMARY KEY(`id_cart_formula`)\n' +
    ');\n',
  sqlState: '42S01',
  sqlMessage: "Table 'carts_formulas' already exists"
}
Was this page helpful?