[Postgres] error when using postgres node

Describe the problem/error/question

Some options didn’t show on UI, and i got error when i running it.

What is the error message (if any)?

ERROR: Could not get parameter "columns.mappingMode"!
Error: Could not get parameter "columns.mappingMode"!
    at getNodeParameter (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/NodeExecuteFunctions.js:1295:15)
    at Object.getNodeParameter (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/NodeExecuteFunctions.js:1592:24)
    at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Postgres/v2/actions/database/insert.operation.js:149:20)
    at Object.router (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Postgres/v2/actions/router.js:49:81)
    at processTicksAndRejections (node:internal/process/task_queues:95:5)
    at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:658:19)
    at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:631:53

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 1.5.1
  • Database (default: SQLite): Postgres
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): docker
  • Operating system: linux

Hi @Yoshino-s :wave: Welcome to the community :cake:

Can you go into a little bit more detail about what you mean by some options didn’t show in the UI? What options were you needing that did not appear? Any further information would be helpful :bowing_man:

I choose schema and table, and then, no other UI coming out, no Mapping Column Mode no columns value select…

Also, i upgrade to 1.6.1 and the issue solved. Thanks for replying.

2 Likes

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