Been working on this for several days and have exhausted my abilities and various suggestions via the web and these forums...so thank you in advance for any assistance! Basis: Have 3 MQTT inputs/message payloads In node red, converting payload to number(s) Since all messages had same designation …

This thread has veered off from "mySQL INSERT INTO with multiple msg.xxx failing" to "how to send mySQL data to a chart" It should really be a new thread (to attract the correct people)! Anyhow - the below thread is almost identical - it should give you a head start. [image] Data…

Hi. I think this might help. Can't be certain as you haven't posted your flow or a screenshot... See this article in the cookbook for an example of how to join messages into one object.

Just to add further clarification, in case you didn't realise, the problem is that your function assumes that each message contains all three values whereas, as you can see, each message has only one of them defined. The solution is to use a Join node as suggested. You won't need to move the values …

Thank you both! I had tried the Join earlier, but missed the "Send the message after xxx message parts" so obviously the join was not properly configured. With this properly configured I am able to get the proper values into the insert statement as shown: [nr3] However, the insert statement is n…

Are there any messages coming out of the sql node? Does a Catch node catch any errors from the sql node?

Catch node does not capture any errors. DB is connected in NR. I changed the insert function to this, but still no success in inserting a new record: msg.topic="INSERT INTO exterior_climate (Temp,Pressure,Humidity,Light,Voltage) VALUES ("+msg.payload.Outside_Temp+","+msg.payload.Outside_Pressure+…

Don't show us what is in the function, what matters is what is going into the sql node. Use the little Copy Value button next to the value in the debug window. You didn't answer the question about what is coming out of the sql node. Also are you using node-red-node-mysql (look in Manage Palette t…

Thank you for your patience ! Here is what is coming out of the debug node that is wired after the insert statement: [null,null,null,null,null] [nr4] Yes I am using the Node Red MY SQL Node, properly configured and connected (as shown by the green dot). During previous troubleshooting using sta…

I Found and fixed some typos in the insert which now reads: msg.topic="INSERT INTO exterior_climate (Temp,Pressure,Humidity,Light,Voltage) VALUES ("+msg.payload.Outside_Temp+","+msg.payload.Outside_Pressure+","+msg.payload.Outside_Humidity+",30,20)"; msg.payload=[msg.payload.Outside_Temp,msg.paylo…

Show us the debug node output from your test insert of static data. But before showing us, does it look the same as your actual data?

All, again...many thanks. I continued to fiddle with the insert statement and even though I am uncertain which of the many things I tried did work. The data is now inserting to SQL. I hope to get more proficient with NR so that at some time I may be of assistance to others. Kind Regards

Node-RED

Node-RED Forum

mySQL INSERT INTO with multiple msg.xxx failing

General

Paul-Reed 28 November 2020 21:32 15

New topic created at Dynamic series identification from message, send data to Chart

Topic		Replies	Views
Insert Into MySQL Database General	15	13820	19 September 2020
Send data to MYSQL General	17	1244	2 May 2024
Can't Differentiate data from different topics while inserting data into my sql database General	12	526	17 July 2021
Node red value to mysql General	8	1975	20 May 2020
Insert Into MySQL table General database	4	2018	30 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.

mySQL INSERT INTO with multiple msg.xxx failing

Related topics