MySQL Insert Row node : issue with variable
Hello,
I'm having an issue using variable with the MySQL insert row.
When I perform my testing with hardcoded variables, everything works fine but when I'm trying to use variables in the workflow nothing happens.
Here is a screenshot of my configuration, for information all fields are strings expect montant which is number.
Solution:Jump to solution
Hi @Guiz, we checked the insert mysql node, and it is working fine. To debug, could you please delete the node and add it again, and test it in node editor?
8 Replies
For info, the same behaviour is happening for the update node
Hi @Guiz, Could you please share from where are these variables referenced? And from the logs if they are returning any value?
Hello Gaurav, doing the exact same with the "execute query" node is working fine so I don't think the issue is related to variable
what response does the node give on execution?
I have a 200 with an empty array []
Empty array here denotes the data is not being parsed correctly, can you delete and try from the node again? As you mentioned it worked with raw values.
No it didn't work at all with the node, it worked with the "query" node.
Solution
Hi @Guiz, we checked the insert mysql node, and it is working fine. To debug, could you please delete the node and add it again, and test it in node editor?