Cannot Update MySQL JSON

Questions
1

Hi

I have a simple mysql node that is intended to update a JSON value in the database. The query is straight forward:

Query parameters are:

When the node executes I do get a “true” response but the value of alert_rules does not actually update.
I can paste this json directly into the database, and it will save without errors.

I can only image there is something that n8n is doing with the json that is preventing it from actually persisting when the module is executed?

Information on your n8n setup

  • v1.58.2
  • Database mysql

Thanks!

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

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

Is there anyone from the n8n support team that can assist with this?

1 Like
4

Never mind - found the solution to this myself. thanks

5

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