Repository navigation
error: column reference "content" is ambiguous #1080
Copy link
Copy link
Closed
Description
When exporting a page with sub-pages enabled, the export fails with a UI error at the bottom of the screen:
Export failed:undefined
Note the missing space between
failed:and the error message.
The associated XHR POST request yields 500.
The server throws:
[Nest] 36 - 04/24/2025, 8:51:00 PM ERROR [ExceptionsHandler] error: column reference "content" is ambiguous
at /app/node_modules/.pnpm/pg@8.13.3/node_modules/pg/lib/client.js:535:17
at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
at async PostgresConnection.executeQuery (/app/node_modules/.pnpm/kysely@0.27.5/node_modules/kysely/dist/cjs/dialect/postgres/postgres-driver.js:75:28)
at async connection.executeQuery (/app/node_modules/.pnpm/kysely@0.27.5/node_modules/kysely/dist/cjs/driver/runtime-driver.js:92:24)
at async /app/node_modules/.pnpm/kysely@0.27.5/node_modules/kysely/dist/cjs/query-executor/query-executor-base.js:37:28
at async DefaultConnectionProvider.provideConnection (/app/node_modules/.pnpm/kysely@0.27.5/node_modules/kysely/dist/cjs/driver/default-connection-provider.js:12:20)
at async DefaultQueryExecutor.executeQuery (/app/node_modules/.pnpm/kysely@0.27.5/node_modules/kysely/dist/cjs/query-executor/query-executor-base.js:36:16)
at async SelectQueryBuilderImpl.execute (/app/node_modules/.pnpm/kysely@0.27.5/node_modules/kysely/dist/cjs/query-builder/select-query-builder.js:317:24)
at async ExportService.exportPageWithChildren (/app/apps/server/dist/integrations/export/export.service.js:71:23)
at async ExportController.exportPage (/app/apps/server/dist/integrations/export/export.controller.js:48:35)
at PostgresConnection.executeQuery (/app/node_modules/.pnpm/kysely@0.27.5/node_modules/kysely/dist/cjs/dialect/postgres/postgres-driver.js:95:69)
at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
at async connection.executeQuery (/app/node_modules/.pnpm/kysely@0.27.5/node_modules/kysely/dist/cjs/driver/runtime-driver.js:92:24)
at async /app/node_modules/.pnpm/kysely@0.27.5/node_modules/kysely/dist/cjs/query-executor/query-executor-base.js:37:28
at async DefaultConnectionProvider.provideConnection (/app/node_modules/.pnpm/kysely@0.27.5/node_modules/kysely/dist/cjs/driver/default-connection-provider.js:12:20)
at async DefaultQueryExecutor.executeQuery (/app/node_modules/.pnpm/kysely@0.27.5/node_modules/kysely/dist/cjs/query-executor/query-executor-base.js:36:16)
at async SelectQueryBuilderImpl.execute (/app/node_modules/.pnpm/kysely@0.27.5/node_modules/kysely/dist/cjs/query-builder/select-query-builder.js:317:24)
at async ExportService.exportPageWithChildren (/app/apps/server/dist/integrations/export/export.service.js:71:23)
at async ExportController.exportPage (/app/apps/server/dist/integrations/export/export.controller.js:48:35) {
length: 113,
severity: 'ERROR',
code: '42702',
detail: undefined,
hint: undefined,
position: '316',
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'parse_relation.c',
line: '831',
routine: 'scanRTEForColumn'
}Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels
Activity
Philipinho commentedon Apr 24, 2025
Fixed 0.20.3.
almereyda commentedon Apr 25, 2025
🚀