MigrationError: Migration core::5.0.0-discard-drafts (up) failed

commentsBot · November 1, 2024, 5:50am

Hey folks, while running Strapi 5 in a existing Strapi 4 database, I got the following error:

MigrationError: Migration core::5.0.0-discard-drafts (up) failed: Original error: insert into "categories" ("contentful_id", "created_at", "created_by_id", "document_id", "locale", "name", "published_at", "slug", "updated_at", "updated_by_id") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) returning "id" - current transaction is aborted, commands ignored until end of transaction block

looks like it’s coming from this line

github.com

strapi/strapi/blob/de5a38d7cd3c918458a7cee439a896ac35ddad4c/packages/core/core/src/migrations/database/5.0.0-discard-drafts.ts#L79


      
            return acc;
          }, [] as string[]);
          
          /**
           * Query to copy the published entries into draft entries.
           *
           * INSERT INTO tableName (columnName1, columnName2, columnName3, ...)
           * SELECT columnName1, columnName2, columnName3, ...
           * FROM tableName
           */
          await trx
            // INSERT INTO tableName (columnName1, columnName2, columnName3, ...)
            .into(
              trx.raw(`?? (${scalarAttributes.map(() => `??`).join(', ')})`, [
                meta.tableName,
                ...scalarAttributes,
              ])
            )
            .insert((subQb: typeof trx) => {
              // SELECT columnName1, columnName2, columnName3, ...
              subQb

I’m running Strapi 5.2.0

This topic has been created from a Discord post (1301785343284088862) to give it more visibility.
It will be on Read-Only mode here.
Join the conversation on Discord