MySQL node cannot find the column value if referenced from a previous node

Questions
,
1

MySQL node cannot find the column value if referenced from a previous node… only hardcoding works…???

Please share your workflow

chat_id is NULL when referencing from previous node… clearly value is available from mysql databse, but returns NULL…

image
image1663×652 56.6 KB

image
image695×264 29.4 KB

It works if i hard code the value…

image
image1716×698 60.6 KB

Information on your n8n setup

  • n8n version: Version 1.89.2
  • Database (default: SQLite): yes
  • n8n EXECUTIONS_PROCESS setting (default: own, main): own
  • Running n8n via (Docker, npm, n8n cloud, desktop app): docker
  • Operating system: selfhost ubuntu
2

Interesting, this could be a bug. I believe there was a similar issue to this with facebook or telegram nodes a few weeks back. Mapped data would never work, only hardcoded data.

It was recently fixed.

You may want to submit a bug report on github.

3

yeah. it was working on 1.86… i created a github issue now … MySQL node cannot find the column value if referenced from a previous node · Issue #14931 · n8n-io/n8n

1 Like