firefish

firefish-web-1 | Migration "NoteFile1710304584214" failed, error: subquery in FROM must have an alias
firefish-web-1 | query: ROLLBACK
firefish-web-1 | Error during migration run:
firefish-web-1 | QueryFailedError: subquery in FROM must have an alias
firefish-web-1 | at PostgresQueryRunner.query (/firefish/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.3.2_pg@8.11.3_ts-node@10.9.2/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)
firefish-web-1 | at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
firefish-web-1 | at async NoteFile1710304584214.up (file:///firefish/packages/backend/built/migration/1710304584214-note-file.js:5:9)
firefish-web-1 | at async MigrationExecutor.executePendingMigrations (/firefish/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.3.2_pg@8.11.3_ts-node@10.9.2/node_modules/typeorm/migration/MigrationExecutor.js:225:17)
firefish-web-1 | at async DataSource.runMigrations (/firefish/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.3.2_pg@8.11.3_ts-node@10.9.2/node_modules/typeorm/data-source/DataSource.js:265:35)
firefish-web-1 | at async Object.handler (/firefish/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.3.2_pg@8.11.3_ts-node@10.9.2/node_modules/typeorm/commands/MigrationRunCommand.js:68:13) {
firefish-web-1 | query: '\n' +
firefish-web-1 | '\t\t\tINSERT INTO "note_file" ("noteId", "fileId") SELECT * FROM (\n' +
firefish-web-1 | '\t\t\t\tSELECT "id", UNNEST("fileIds") FROM "note"\n' +
firefish-web-1 | '\t\t\t)\n' +
firefish-web-1 | '\t\t',
firefish-web-1 | parameters: undefined,
firefish-web-1 | driverError: error: subquery in FROM must have an alias
firefish-web-1 | at /firefish/node_modules/.pnpm/pg@8.11.3/node_modules/pg/lib/client.js:526:17
firefish-web-1 | at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
firefish-web-1 | at async PostgresQueryRunner.query (/firefish/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.3.2_pg@8.11.3_ts-node@10.9.2/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:184:25)
firefish-web-1 | at async NoteFile1710304584214.up (file:///firefish/packages/backend/built/migration/1710304584214-note-file.js:5:9)
firefish-web-1 | at async MigrationExecutor.executePendingMigrations (/firefish/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.3.2_pg@8.11.3_ts-node@10.9.2/node_modules/typeorm/migration/MigrationExecutor.js:225:17)
firefish-web-1 | at async DataSource.runMigrations (/firefish/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.3.2_pg@8.11.3_ts-node@10.9.2/node_modules/typeorm/data-source/DataSource.js:265:35)
firefish-web-1 | at async Object.handler (/firefish/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.3.2_pg@8.11.3_ts-node@10.9.2/node_modules/typeorm/commands/MigrationRunCommand.js:68:13) {
firefish-web-1 | length: 138,
firefish-web-1 | severity: 'ERROR',
firefish-web-1 | code: '42601',
firefish-web-1 | detail: undefined,
firefish-web-1 | hint: 'For example, FROM (SELECT ...) [AS] foo.',
firefish-web-1 | position: '64',
firefish-web-1 | internalPosition: undefined,
firefish-web-1 | internalQuery: undefined,
firefish-web-1 | where: undefined,
firefish-web-1 | schema: undefined,
firefish-web-1 | table: undefined,
firefish-web-1 | column: undefined,
firefish-web-1 | dataType: undefined,
firefish-web-1 | constraint: undefined,
firefish-web-1 | file: 'gram.y',
firefish-web-1 | line: '13256',
firefish-web-1 | routine: 'base_yyparse'
firefish-web-1 | },
firefish-web-1 | length: 138,
firefish-web-1 | severity: 'ERROR',
firefish-web-1 | code: '42601',
firefish-web-1 | detail: undefined,
firefish-web-1 | hint: 'For example, FROM (SELECT ...) [AS] foo.',
firefish-web-1 | position: '64',
firefish-web-1 | internalPosition: undefined,
firefish-web-1 | internalQuery: undefined,
firefish-web-1 | where: undefined,
firefish-web-1 | schema: undefined,
firefish-web-1 | table: undefined,
firefish-web-1 | column: undefined,
firefish-web-1 | dataType: undefined,
firefish-web-1 | constraint: undefined,
firefish-web-1 | file: 'gram.y',
firefish-web-1 | line: '13256',
firefish-web-1 | routine: 'base_yyparse'
firefish-web-1 | }
firefish-web-1 | /firefish/packages/backend:
firefish-web-1 |  ERR_PNPM_RECURSIVE_RUN_FIRST_FAIL  backend@ migrate: `typeorm migration:run --dataSource ./built/ormconfig.js`
firefish-web-1 | Exit status 1
firefish-web-1 |  ELIFECYCLE  Command failed with exit code 1.
firefish-web-1 |  ELIFECYCLE  Command failed with exit code 1.