Database Migration / Deployment Questions

Questions and Answers
42

Hi @DMehaffy ,

Thanks for sharing the documentation. I am on strapi v4.1.12 and using postgres as database.I have tried adding the migration file under database/migrations/test.js file with below content

'use strict';

async function up(knex) {
  await knex.from('tabs_components').update({ field: 'tabsData' }).where({ field: 'tabs' });
}

async function down() {}

module.exports = { up, down };

However its always throwing error

error: Migration test.js (up) failed: Original error: db.getConnection(...).transaction is not a function

This error is coming even if I have empty up method in migration file or write any other script. I have also tried naming the file with timestamp(as mentioned in the documentation) but no success.