Hi, Been struggling for a while to get this to work (saving multiple sensor readers to MySQL) and finally succeeded but now it saves 2 identical lines each time to the database and I get a sporadic error message from the debug node of the Mysql node; 5/14/2020, 9:37:05 AM node: monitor DB msg : erro…

Your problem is caused because you specify to send a message from the join after 1 mesage comes in [join_1] that is why you see a NaN. change After a number of message parts to 2 and uncheck after every subsequent message.

Trouble entering data to mysql

General

Steve-Mcl 14 May 2020 09:00 2

Please read How to share code or flow json and edit your post - your code cannot be imported as is.

Edit

Never mind, i edited your post for you.

Try adding extra debugs - what do you see in debug panel from before the MYSQL node?

Topic		Replies	Views
Database not receive the data when one sensor stops General	36	1222	14 February 2019
mySQL INSERT INTO with multiple msg.xxx failing General	15	3025	28 November 2020
Problem with inserting duplicate data MySQL General	10	589	26 April 2021
Data Stored in MySQL General	6	1002	3 October 2019
MySQL NODE-RED table General	33	11597	8 February 2019

Trouble entering data to mysql

Related topics