Upgrade past 0.52.0 not possible with SQLITE?

Need help
1

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]

2

It looks like there may be a database compatibility issue starting in 0.52.1.

With that said, is there an easy way to migrate from SQLITE to PostGres/Redis?

3

Hi @Christian_DeRamos Can you upgrade to 0.53.1 directly, It should work

Please let me know if it’s does not

4

I tried that today and it didnt work, same error. Here is the Error chain with 0.53.1 or latest:

Migration “AddExternalIdForTablesAndFieldsSQLITE1746367601605” failed, error: SQLITE_CONSTRAINT: NOT NULL constraint failed: temporary_field.externalId
2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 pid=8 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 pid=8 hostname=ed7ed8443f88 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 pid=8 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 pid=8 hostname=ed7ed8443f88 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/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 pid=8 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 pid=8 hostname=ed7ed8443f88 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 pid=8 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 pid=8 hostname=ed7ed8443f88 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/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 pid=7 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 pid=7 hostname=ed7ed8443f88 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 pid=7 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 pid=7 hostname=ed7ed8443f88 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/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 pid=7 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 pid=7 hostname=ed7ed8443f88 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 pid=7 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 2025/05/12 06:51PM 2025/05/12 06:51PM 50 pid=7 hostname=ed7ed8443f88 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/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 pid=7 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 pid=7 hostname=ed7ed8443f88 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 pid=7 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 pid=7 hostname=ed7ed8443f88 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/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 pid=7 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 pid=7 hostname=ed7ed8443f88 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 pid=7 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 pid=7 hostname=ed7ed8443f88 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/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 pid=8 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 pid=8 hostname=ed7ed8443f88 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 pid=8 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 pid=8 hostname=ed7ed8443f88 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/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 pid=8 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 pid=8 hostname=ed7ed8443f88 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 pid=8 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 2025/05/12 06:52PM 2025/05/12 06:52PM 50 pid=8 hostname=ed7ed8443f88 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]

5

Thanks, I found the issue, please try in the next release (We will do one today)

6

Thank you Very much! I look forward to the new features.

7

This solved it, thank you @abuaboud!

8

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.