I am getting "Deploy failed: No response from server" when I am trying to Insert the data coming from real-time sensors in JSON format. All the other queries except the Insert query is running fine. Below is the Insert query I am using inside my template node: INSERT INTO aress_support_sensor (m…

Yes. It has all the privileges. Delete and select queries are also working fine.

Is the MySQL database on the same or a different machine? I just ran a test and inserts work fone for me. in my case MySQL is on the same machine as NR. If you insert ran nee and tehn stopped, have you looked in the logs of the database to see if naything funky is happening there?

The MySQL database is on the same machine. Even I did setup a new server and tried the same activity on that server, still there was this issue. Just now I tried using "REPLACE INTO" instead of "INSERT INTO" in my query and it worked fine!! However, this is not the motive of the task I am doing. I…

feel like sharing your db schema and flow so I can try to reproduce it?

Please see this and edit your post accordingly so that we can import your flow [image] How to share code or flow json FAQs To share code samples or flow json in this forum, you need to take care to format it properly so that it is displayed correctly. The easiest way to d…

Also with that flow, when do you get the Deploy Failed message?

The same flow I have posted which is giving the deploy failed message: [{"id":"2867501b.43456","type":"tab","label":"Flow 1","disabled":false,"info":""},{"id":"560199de.cdcaf8","type":"mysql","z":"2867501b.43456","mydb":"2a44bcb3.ad6994","name":"","x":550,"y":180,"wires":[["6d7e9abd.a213b4"]]},{"id…

In the screenshot for your template node you seem to be setting the query into msg.payload... it needs to be in msg.topic as per the info sidebar

[image] Sagar: The same flow I have posted which is giving the deploy failed message: There is a syntax error in the json for that flow (the second one you posted), which may explain why it will not deploy. Try to import it and it shows the error. I will have to leave it to others to commen…

Node-RED

Node-RED Forum

"Deploy failed: No response from server" when inserting into MySQL

General

Colin 6 December 2019 11:03 19

Please see this and edit your post accordingly so that we can import your flow

Topic		Replies	Views
Trying to write to mariaDB with mysql node General	17	268	18 December 2024
Deploy failed: no response from server General	9	3987	5 December 2019
Read from mysql db Dashboard	54	17730	23 December 2018
Deploy failing. No response from server General	34	9977	5 July 2021
Update broke MySQL, old versions of Node-red-nodes have been removed. Why and where are they? General	31	1560	7 September 2021

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

"Deploy failed: No response from server" when inserting into MySQL

Related topics