I have been trying to upgrade past 0.52.0 but I keep getting this error, is there a workaround?
Migration “AddExternalIdForTablesAndFieldsSQLITE1746367601605” failed, error: SQLITE_CONSTRAINT: NOT NULL constraint failed: temporary_field.externalId
2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 pid=8 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 pid=8 hostname=89c01843cab3 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 pid=8 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 pid=8 hostname=89c01843cab3 err={“type”:“QueryFailedError”,“message”:“SQLITE_CONSTRAINT: NOT NULL constraint failed: temporary_field.externalId”,“stack”:“QueryFailedError: SQLITE_CONSTRAINT: NOT NULL constraint failed: temporary_field.externalId\n at Statement.handler (/usr/src/app/dist/packages/server/api/node_modules/typeorm/driver/src/driver/sqlite/SqliteQueryRunner.ts:134:29)\n at Statement.replacement (/usr/src/app/dist/packages/server/api/node_modules/sqlite3/lib/trace.js:25:27)\n at Statement.replacement (/usr/src/app/dist/packages/server/api/node_modules/sqlite3/lib/trace.js:25:27)”,“query”:“\n INSERT INTO "temporary_field"(\n "id",\n "created",\n "updated",\n "name",\n "type",\n "tableId",\n "projectId",\n "data"\n )\n SELECT "id",\n "created",\n "updated",\n "name",\n "type",\n "tableId",\n "projectId",\n "data"\n FROM "field"\n “,“driverError”:{“type”:“Error”,“message”:“SQLITE_CONSTRAINT: NOT NULL constraint failed: temporary_field.externalId”,“stack”:“Error: SQLITE_CONSTRAINT: NOT NULL constraint failed: temporary_field.externalId\n → in Statement#all(undefined, [Function: replacement])\n at Database. (/usr/src/app/dist/packages/server/api/node_modules/sqlite3/lib/sqlite3.js:88:19)\n at Database. (/usr/src/app/dist/packages/server/api/node_modules/sqlite3/lib/sqlite3.js:20:19)\n at execute (/usr/src/app/dist/packages/server/api/node_modules/typeorm/driver/src/driver/sqlite/SqliteQueryRunner.ts:87:50)\n at (/usr/src/app/dist/packages/server/api/node_modules/typeorm/driver/src/driver/sqlite/SqliteQueryRunner.ts:169:23)”,“errno”:19,“code”:“SQLITE_CONSTRAINT”,”__augmented”:true},“errno”:19,“code”:“SQLITE_CONSTRAINT”,“__augmented”:true} 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 pid=8 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 pid=8 hostname=89c01843cab3 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 pid=8 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 pid=8 hostname=89c01843cab3 err={“type”:“QueryFailedError”,“message”:“SQLITE_CONSTRAINT: NOT NULL constraint failed: temporary_field.externalId”,“stack”:“QueryFailedError: SQLITE_CONSTRAINT: NOT NULL constraint failed: temporary_field.externalId\n at Statement.handler (/usr/src/app/dist/packages/server/api/node_modules/typeorm/driver/src/driver/sqlite/SqliteQueryRunner.ts:134:29)\n at Statement.replacement (/usr/src/app/dist/packages/server/api/node_modules/sqlite3/lib/trace.js:25:27)\n at Statement.replacement (/usr/src/app/dist/packages/server/api/node_modules/sqlite3/lib/trace.js:25:27)”,“query”:“\n INSERT INTO "temporary_field"(\n "id",\n "created",\n "updated",\n "name",\n "type",\n "tableId",\n "projectId",\n "data"\n )\n SELECT "id",\n "created",\n "updated",\n "name",\n "type",\n "tableId",\n "projectId",\n "data"\n FROM "field"\n “,“driverError”:{“type”:“Error”,“message”:“SQLITE_CONSTRAINT: NOT NULL constraint failed: temporary_field.externalId”,“stack”:“Error: SQLITE_CONSTRAINT: NOT NULL constraint failed: temporary_field.externalId\n → in Statement#all(undefined, [Function: replacement])\n at Database. (/usr/src/app/dist/packages/server/api/node_modules/sqlite3/lib/sqlite3.js:88:19)\n at Database. (/usr/src/app/dist/packages/server/api/node_modules/sqlite3/lib/sqlite3.js:20:19)\n at execute (/usr/src/app/dist/packages/server/api/node_modules/typeorm/driver/src/driver/sqlite/SqliteQueryRunner.ts:87:50)\n at (/usr/src/app/dist/packages/server/api/node_modules/typeorm/driver/src/driver/sqlite/SqliteQueryRunner.ts:169:23)”,“errno”:19,“code”:“SQLITE_CONSTRAINT”,”__augmented”:true},“errno”:19,“code”:“SQLITE_CONSTRAINT”,“__augmented”:true} msg=[Main#main]
Migration “AddExternalIdForTablesAndFieldsSQLITE1746367601605” failed, error: SQLITE_CONSTRAINT: NOT NULL constraint failed: temporary_field.externalId
2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 pid=9 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 pid=9 hostname=89c01843cab3 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 pid=9 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 pid=9 hostname=89c01843cab3 err={“type”:“QueryFailedError”,“message”:“SQLITE_CONSTRAINT: NOT NULL constraint failed: temporary_field.externalId”,“stack”:“QueryFailedError: SQLITE_CONSTRAINT: NOT NULL constraint failed: temporary_field.externalId\n at Statement.handler (/usr/src/app/dist/packages/server/api/node_modules/typeorm/driver/src/driver/sqlite/SqliteQueryRunner.ts:134:29)\n at Statement.replacement (/usr/src/app/dist/packages/server/api/node_modules/sqlite3/lib/trace.js:25:27)\n at Statement.replacement (/usr/src/app/dist/packages/server/api/node_modules/sqlite3/lib/trace.js:25:27)”,“query”:“\n INSERT INTO "temporary_field"(\n "id",\n "created",\n "updated",\n "name",\n "type",\n "tableId",\n "projectId",\n "data"\n )\n SELECT "id",\n "created",\n "updated",\n "name",\n "type",\n "tableId",\n "projectId",\n "data"\n FROM "field"\n “,“driverError”:{“type”:“Error”,“message”:“SQLITE_CONSTRAINT: NOT NULL constraint failed: temporary_field.externalId”,“stack”:“Error: SQLITE_CONSTRAINT: NOT NULL constraint failed: temporary_field.externalId\n → in Statement#all(undefined, [Function: replacement])\n at Database. (/usr/src/app/dist/packages/server/api/node_modules/sqlite3/lib/sqlite3.js:88:19)\n at Database. (/usr/src/app/dist/packages/server/api/node_modules/sqlite3/lib/sqlite3.js:20:19)\n at execute (/usr/src/app/dist/packages/server/api/node_modules/typeorm/driver/src/driver/sqlite/SqliteQueryRunner.ts:87:50)\n at (/usr/src/app/dist/packages/server/api/node_modules/typeorm/driver/src/driver/sqlite/SqliteQueryRunner.ts:169:23)”,“errno”:19,“code”:“SQLITE_CONSTRAINT”,”__augmented”:true},“errno”:19,“code”:“SQLITE_CONSTRAINT”,“__augmented”:true} 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 pid=9 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 pid=9 hostname=89c01843cab3 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 pid=9 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 2025/05/11 01:06PM 2025/05/11 01:06PM 50 pid=9 hostname=89c01843cab3 err={“type”:“QueryFailedError”,“message”:“SQLITE_CONSTRAINT: NOT NULL constraint failed: temporary_field.externalId”,“stack”:“QueryFailedError: SQLITE_CONSTRAINT: NOT NULL constraint failed: temporary_field.externalId\n at Statement.handler (/usr/src/app/dist/packages/server/api/node_modules/typeorm/driver/src/driver/sqlite/SqliteQueryRunner.ts:134:29)\n at Statement.replacement (/usr/src/app/dist/packages/server/api/node_modules/sqlite3/lib/trace.js:25:27)\n at Statement.replacement (/usr/src/app/dist/packages/server/api/node_modules/sqlite3/lib/trace.js:25:27)”,“query”:“\n INSERT INTO "temporary_field"(\n "id",\n "created",\n "updated",\n "name",\n "type",\n "tableId",\n "projectId",\n "data"\n )\n SELECT "id",\n "created",\n "updated",\n "name",\n "type",\n "tableId",\n "projectId",\n "data"\n FROM "field"\n “,“driverError”:{“type”:“Error”,“message”:“SQLITE_CONSTRAINT: NOT NULL constraint failed: temporary_field.externalId”,“stack”:“Error: SQLITE_CONSTRAINT: NOT NULL constraint failed: temporary_field.externalId\n → in Statement#all(undefined, [Function: replacement])\n at Database. (/usr/src/app/dist/packages/server/api/node_modules/sqlite3/lib/sqlite3.js:88:19)\n at Database. (/usr/src/app/dist/packages/server/api/node_modules/sqlite3/lib/sqlite3.js:20:19)\n at execute (/usr/src/app/dist/packages/server/api/node_modules/typeorm/driver/src/driver/sqlite/SqliteQueryRunner.ts:87:50)\n at (/usr/src/app/dist/packages/server/api/node_modules/typeorm/driver/src/driver/sqlite/SqliteQueryRunner.ts:169:23)”,“errno”:19,“code”:“SQLITE_CONSTRAINT”,”__augmented”:true},“errno”:19,“code”:“SQLITE_CONSTRAINT”,“__augmented”:true} msg=[Main#main]