MSQL Node in Executions does not show "result"

[xewonder]

Executing manually you can see the actual query.

In “Executions” you can not trace…

It is essential to be able to see what you sent to mysql!

Share the output returned by the last node

Information on your n8n setup

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

[Jon]

Hey @xewonder,

In the execution view we won’t show the output of the expression but to the right of that window we should show what the output was of the request.

Logging the query does sound like a good feature request though.

[xewonder]

thank you @Jon.

It is really essential that you see the query you are sending out. I was there in 0.230.

[Jon]

Hey @xewonder,

Have you tried the new node version to see if it is in there?

[xewonder]

Hello,

yes, it’s only there when you execute the node manually… not in executions.

running 1.18.0

[xewonder]

it does not help if you are trying to “quick check” if you have a wrong value (from upstream) in your query.

you really need to see what you are pushing to mysql.

Please give this back… it was there before… can’t be a huge job.

Thank you

[Jon]

Hey @xewonder,

If you use the new version of the node we have an option to output query execution details this outputs the query that was sent to the server in the output.

This may be a better solution and I believe it solves the issue you are seeing.

[xewonder]

Hi @Jon ,

Is there a way to change the “node” via code instead of having to re-create them? As you can see, there are just too many… Bellow is 1 out of about 15 such workflows

[xewonder]

Replying to my own question, is it just a matter of setting

  "type": "n8n-nodes-base.mySql",
  "typeVersion": 1,

to
“type”: “n8n-nodes-base.mySql”,
“typeVersion”: 2.2,

and adding
“options”: {
“detailedOutput”: true
}

Thanks

[xewonder]

yes…

that solved the issue.

Thank you all