Guiz
Guiz7mo ago

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.
No description
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?
No description
Jump to solution
8 Replies
Guiz
Guiz7mo ago
For info, the same behaviour is happening for the update node
Gaurav Chadha
Gaurav Chadha7mo ago
Hi @Guiz, Could you please share from where are these variables referenced? And from the logs if they are returning any value?
Guiz
Guiz7mo ago
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
Gaurav Chadha
Gaurav Chadha6mo ago
what response does the node give on execution?
Guiz
Guiz6mo ago
I have a 200 with an empty array []
Gaurav Chadha
Gaurav Chadha6mo ago
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.
Guiz
Guiz6mo ago
No it didn't work at all with the node, it worked with the "query" node.
Solution
Gaurav Chadha
Gaurav Chadha6mo ago
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?
No description