# General

**URL:** https://discourse.nodered.org/c/general/7.md?page=22

[Latest](https://discourse.nodered.org/latest.md) · [Categories](https://discourse.nodered.org/categories.md) · [Tags](https://discourse.nodered.org/tags.md)

**Page:** 23

---

## [Best practice mssql node](https://discourse.nodered.org/t/best-practice-mssql-node/99386)

<div class="topic-metadata">

**Author:** [@Filip\_Top](https://discourse.nodered.org/u/Filip_Top)\
**Replies:** 10\
**Last updated:** [17 October 2025 11:45 UTC](https://discourse.nodered.org/t/best-practice-mssql-node/99386 "2025-10-17T11:45:24Z")

</div>

I'm using data from the database to update multiple screens every 5 min from the database. To do this, I need to run several queries in the same database. What is the best practice, make a flow for every query with his…

---

## [Modbus - Flex Write node - Parameters](https://discourse.nodered.org/t/modbus-flex-write-node-parameters/99410)

<div class="topic-metadata">

**Author:** [@craigcurtin](https://discourse.nodered.org/u/craigcurtin)\
**Replies:** 3\
**Last updated:** [17 October 2025 11:29 UTC](https://discourse.nodered.org/t/modbus-flex-write-node-parameters/99410 "2025-10-17T11:29:04Z")

</div>

Hey Guys (hopefully @Steve-Mcl is listening !) I am using the Modbus nodes extensively and not having any troubles - except i now want to pass two parameters through the Flex-write node and can not figure out the setup …

---

## [Node-red-contrib-alexa-home-skill](https://discourse.nodered.org/t/node-red-contrib-alexa-home-skill/99419)

<div class="topic-metadata">

**Author:** [@cymplecy](https://discourse.nodered.org/u/cymplecy)\
**Replies:** 3\
**Last updated:** [17 October 2025 09:07 UTC](https://discourse.nodered.org/t/node-red-contrib-alexa-home-skill/99419 "2025-10-17T09:07:20Z")

</div>

I updated my main NodeRED instance running native on a Pi to 4.1.1 this afternoon and nothing that's programmed to use this skill from @hardillb seems to be working this evening. Anyone else having difficulties?

---

## [Help required to remove pymysql from script](https://discourse.nodered.org/t/help-required-to-remove-pymysql-from-script/99409)

<div class="topic-metadata">

**Author:** [@Tinbum1](https://discourse.nodered.org/u/Tinbum1)\
**Replies:** 5\
**Last updated:** [16 October 2025 21:05 UTC](https://discourse.nodered.org/t/help-required-to-remove-pymysql-from-script/99409 "2025-10-16T21:05:09Z")

</div>

Hi, I wonder if anyone would be able to remove all the code for the logger pymysql from this script below as I don't need it. I've had a go but but not really sure. #!/usr/bin/env python import requests,json,pymysql im…

---

## [“POOL IS CLOSED” Error in mysql2 Node](https://discourse.nodered.org/t/pool-is-closed-error-in-mysql2-node/99413)

<div class="topic-metadata">

**Author:** [@shubhamnodered](https://discourse.nodered.org/u/shubhamnodered)\
**Replies:** 1\
**Last updated:** [16 October 2025 06:54 UTC](https://discourse.nodered.org/t/pool-is-closed-error-in-mysql2-node/99413 "2025-10-16T06:54:49Z")

</div>

Hi everyone, I recently came across an error in Node-RED related to the mysql2 node: "POOL IS CLOSED" This is what i saw in the debug window.... { "\_\_enc\_\_": true, "type": "error", "data": { "name": "Erro…

---

## [Csv value to mqtt](https://discourse.nodered.org/t/csv-value-to-mqtt/99372)

<div class="topic-metadata">

**Author:** [@gerribaldi](https://discourse.nodered.org/u/gerribaldi)\
**Replies:** 5\
**Last updated:** [15 October 2025 18:46 UTC](https://discourse.nodered.org/t/csv-value-to-mqtt/99372 "2025-10-15T18:46:23Z")

</div>

HI, i read a csv file from a ftp server and want to sent the values to a mqtt broker. My point know is, how can i create for each value in a line separate topic. The csv have this fields: sn; volume 1; volume 2; volum…

---

## [Tibber Price Reveiver Object not updated to 15 min mode](https://discourse.nodered.org/t/tibber-price-reveiver-object-not-updated-to-15-min-mode/99407)

<div class="topic-metadata">

**Author:** [@jojogommez](https://discourse.nodered.org/u/jojogommez)\
**Replies:** 1\
**Last updated:** [15 October 2025 17:56 UTC](https://discourse.nodered.org/t/tibber-price-reveiver-object-not-updated-to-15-min-mode/99407 "2025-10-15T17:56:08Z")

</div>

Hello im not a programmer but in the Power Save Palette the lowest Price works with 15 minutes but the Price Receiver ist in the old 1 hour mode. Can someone help to update the Prive Receiver to 15 min mode ?

---

## [LCD1602 RGB Waveshare](https://discourse.nodered.org/t/lcd1602-rgb-waveshare/99401)

<div class="topic-metadata">

**Author:** [@PLC](https://discourse.nodered.org/u/PLC)\
**Replies:** 2\
**Last updated:** [15 October 2025 13:22 UTC](https://discourse.nodered.org/t/lcd1602-rgb-waveshare/99401 "2025-10-15T13:22:44Z")

</div>

Hello guys, I bought a RGB LCD from Waveshare and I would like to know if anyone alredy use it with node-red ? I didn't find any thnigs about it. I would like to use it with node and not use python execute node if poss…

---

## [Why won't this flow import?](https://discourse.nodered.org/t/why-wont-this-flow-import/99382)

<div class="topic-metadata">

**Author:** [@Colin](https://discourse.nodered.org/u/Colin)\
**Replies:** 12\
**Last updated:** [15 October 2025 12:17 UTC](https://discourse.nodered.org/t/why-wont-this-flow-import/99382 "2025-10-15T12:17:07Z")

</div>

In a github issue the OP is posting flows that validate ok in https://jsonlint.com but won't import as node red says it is not valid JSON. Could someone who knows about such things indicate what the problem is? I suspe…

---

## [We published an article on integrating Allen-Bradley PLCs with Node-RED over EtherNet/IP](https://discourse.nodered.org/t/we-published-an-article-on-integrating-allen-bradley-plcs-with-node-red-over-ethernet-ip/99400)

<div class="topic-metadata">

**Author:** [@sumitshinde-84](https://discourse.nodered.org/u/sumitshinde-84)\
**Replies:** 0\
**Last updated:** [15 October 2025 09:01 UTC](https://discourse.nodered.org/t/we-published-an-article-on-integrating-allen-bradley-plcs-with-node-red-over-ethernet-ip/99400 "2025-10-15T09:01:27Z")

</div>

Just wanted to share this article that shows how you can connect to Allen-Bradley PLCs over EtherNet/IP using Node-RED. It covers both implicit and explicit messaging. Check out this comprehensive guide: EtherNet/IP Inte…

---

## [Best way to display graphic image in simple dashboard?](https://discourse.nodered.org/t/best-way-to-display-graphic-image-in-simple-dashboard/99390)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 2\
**Last updated:** [14 October 2025 19:43 UTC](https://discourse.nodered.org/t/best-way-to-display-graphic-image-in-simple-dashboard/99390 "2025-10-14T19:43:59Z")

</div>

Best way to display graphic image in simple NR dashboard? I thought this was pretty straight forward, until I realized I have never do this type of thing before. Here is the scenario, I have two(2) graphic files, JPEG,…

---

## [Analyze simple project](https://discourse.nodered.org/t/analyze-simple-project/99325)

<div class="topic-metadata">

**Author:** [@Gioacchino1969](https://discourse.nodered.org/u/Gioacchino1969)\
**Replies:** 12\
**Last updated:** [14 October 2025 19:30 UTC](https://discourse.nodered.org/t/analyze-simple-project/99325 "2025-10-14T19:30:26Z")

</div>

These are my first projects with node red. I try to use node red to control sonoff devices (zigbee). In this simple project if I make a single press on button I see the same row of event repeated more then once. I woul…

---

## [Node red pages gone :-(](https://discourse.nodered.org/t/node-red-pages-gone/99391)

<div class="topic-metadata">

**Author:** [@Filip\_Top](https://discourse.nodered.org/u/Filip_Top)\
**Replies:** 5\
**Last updated:** [14 October 2025 17:06 UTC](https://discourse.nodered.org/t/node-red-pages-gone/99391 "2025-10-14T17:06:09Z")

</div>

All; I had an upgrade of a node that required a restart of the system. But I didn't find any way to do this, so I restarted the system. But now turns out that everything is gone in my node red environment :frowning: I…

---

## [Wrong timezone in Node Red](https://discourse.nodered.org/t/wrong-timezone-in-node-red/99381)

<div class="topic-metadata">

**Author:** [@macht\_rebel](https://discourse.nodered.org/u/macht_rebel)\
**Replies:** 4\
**Last updated:** [14 October 2025 16:29 UTC](https://discourse.nodered.org/t/wrong-timezone-in-node-red/99381 "2025-10-14T16:29:53Z")

</div>

I run Node-RED (V4.1.0) under Synology Container. My issue is that I have in my Node-RED GUI always the UTC (Zulu) Timezone instead of Europe/Berlin (GMT+2). I broke yesterday my fingers to correct it and thought I did i…

---

## [BME680 Fehlermeldung](https://discourse.nodered.org/t/bme680-fehlermeldung/99364)

<div class="topic-metadata">

**Author:** [@Fuerst081](https://discourse.nodered.org/u/Fuerst081)\
**Replies:** 4\
**Last updated:** [14 October 2025 15:57 UTC](https://discourse.nodered.org/t/bme680-fehlermeldung/99364 "2025-10-14T15:57:31Z")

</div>

Hallo zusammen, beim auslesen eines BME680 Sensor bekomme ich folgende Fehlermeldung: Mit Python funktionier der Sensor. Meine Version ist: Wer kann hier bitte Helfen?

---

## [Using the new dashboard 2.0? How to mimic old table format?](https://discourse.nodered.org/t/using-the-new-dashboard-2-0-how-to-mimic-old-table-format/99389)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 3\
**Last updated:** [14 October 2025 15:29 UTC](https://discourse.nodered.org/t/using-the-new-dashboard-2-0-how-to-mimic-old-table-format/99389 "2025-10-14T15:29:07Z")

</div>

Using the new dashboard 2.0? How to mimic old table format? Add back Borders? Grid lines? Left Justify table title? Color table title? Would be really nice to add the above as an example to the documentation, as nic…

---

## [Understanding the new dashboard?](https://discourse.nodered.org/t/understanding-the-new-dashboard/99376)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 6\
**Last updated:** [14 October 2025 14:38 UTC](https://discourse.nodered.org/t/understanding-the-new-dashboard/99376 "2025-10-14T14:38:11Z")

</div>

Understanding the new dashboard? So is it local or cloud based? I am of course asking about the @flowfuze/node-red-dashboard. I do not want to create anything cloud based for a simple UI for my local flows.

---

## [(Sorry: off topic) Question about this n8n thing](https://discourse.nodered.org/t/sorry-off-topic-question-about-this-n8n-thing/99384)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 2\
**Last updated:** [14 October 2025 10:47 UTC](https://discourse.nodered.org/t/sorry-off-topic-question-about-this-n8n-thing/99384 "2025-10-14T10:47:14Z")

</div>

Ok, yes, a bit of searching would help but...... From what I've read, it is ..... similar to Node-red. I know I'll get biased answers here, but I just wanted to ask where it stacks up to NR? Similar, worse, better, al…

---

## [Is there a node red way something like a one shote rise in a PLC?](https://discourse.nodered.org/t/is-there-a-node-red-way-something-like-a-one-shote-rise-in-a-plc/99379)

<div class="topic-metadata">

**Author:** [@Newbie01](https://discourse.nodered.org/u/Newbie01)\
**Replies:** 1\
**Last updated:** [14 October 2025 01:47 UTC](https://discourse.nodered.org/t/is-there-a-node-red-way-something-like-a-one-shote-rise-in-a-plc/99379 "2025-10-14T01:47:34Z")

</div>

I have the input node checking the database every second for a change, but it is a lot going back and forth to MQTT. Is there a way to only send one message until the output from the sql database changes in the switch no…

---

## [Using a change node to change payload (or whatever string) to lowercase?](https://discourse.nodered.org/t/using-a-change-node-to-change-payload-or-whatever-string-to-lowercase/99377)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 4\
**Last updated:** [13 October 2025 22:38 UTC](https://discourse.nodered.org/t/using-a-change-node-to-change-payload-or-whatever-string-to-lowercase/99377 "2025-10-13T22:38:00Z")

</div>

Using a change node to change payload (or whatever string) to lowercase? To error results: What boneheaded thing am I forgetting?

---

## [Using NodeRed and a BlackMagic ATEM Video Switcher?](https://discourse.nodered.org/t/using-nodered-and-a-blackmagic-atem-video-switcher/99274)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 2\
**Last updated:** [13 October 2025 17:20 UTC](https://discourse.nodered.org/t/using-nodered-and-a-blackmagic-atem-video-switcher/99274 "2025-10-13T17:20:46Z")

</div>

Using NodeRed and a BlackMagic ATEM Video Switcher? I am trying to heads or tails of the BlackMagic ATEM support in NodeRed... there are 3 contributed node packages, and I am using the most recent one, per its github re…

---

## [Using environment variables in kafka consumer topic](https://discourse.nodered.org/t/using-environment-variables-in-kafka-consumer-topic/99321)

<div class="topic-metadata">

**Author:** [@JeroenVH](https://discourse.nodered.org/u/JeroenVH)\
**Replies:** 1\
**Last updated:** [13 October 2025 13:40 UTC](https://discourse.nodered.org/t/using-environment-variables-in-kafka-consumer-topic/99321 "2025-10-13T13:40:57Z")

</div>

The project that I am working on uses the hylink/node-red-kafka-client nodes. I have different flows with identical nodes and configured an environment variable at the flow level to make things inside the flow unique. I…

---

## [Update node and npm without breaking node-red](https://discourse.nodered.org/t/update-node-and-npm-without-breaking-node-red/99353)

<div class="topic-metadata">

**Author:** [@haegar33](https://discourse.nodered.org/u/haegar33)\
**Replies:** 7\
**Last updated:** [13 October 2025 12:40 UTC](https://discourse.nodered.org/t/update-node-and-npm-without-breaking-node-red/99353 "2025-10-13T12:40:17Z")

</div>

I am running on a Raspberry3 NR at V4.1 with underlaying node V18.20 which is the minimum setup. As I experience some instability with my Pi I consider updating node to V20 or V22. Whats the best strategy to ensure no i…

---

## [Read log with journalctl when Node-RED is started with pm2](https://discourse.nodered.org/t/read-log-with-journalctl-when-node-red-is-started-with-pm2/99359)

<div class="topic-metadata">

**Author:** [@SveinHa](https://discourse.nodered.org/u/SveinHa)\
**Replies:** 13\
**Last updated:** [13 October 2025 10:46 UTC](https://discourse.nodered.org/t/read-log-with-journalctl-when-node-red-is-started-with-pm2/99359 "2025-10-13T10:46:44Z")

</div>

I have installed Node-RED on Linux using the recommended way with npm and autostarting it with pm2. After a bit of digging, I found the Node-RED log file in /home/USERNAME/.pm2/logs/node-red-out.log Right now, I read t…

---

## [Has anybody succeded in controlling a 2025 LG TV via Node Red](https://discourse.nodered.org/t/has-anybody-succeded-in-controlling-a-2025-lg-tv-via-node-red/99362)

<div class="topic-metadata">

**Author:** [@Mikee1234K](https://discourse.nodered.org/u/Mikee1234K)\
**Replies:** 2\
**Last updated:** [13 October 2025 04:46 UTC](https://discourse.nodered.org/t/has-anybody-succeded-in-controlling-a-2025-lg-tv-via-node-red/99362 "2025-10-13T04:46:01Z")

</div>

I have a 2025 LG OLED G5 TV which I am trying to control out of Node Red. I have partially succeded in controlling via IP commands sent to a websocket. One issue is it frequently stops working, then I have to send a regi…

---

## [I've got this problem using node-red on a raspberry pi 4](https://discourse.nodered.org/t/ive-got-this-problem-using-node-red-on-a-raspberry-pi-4/99365)

<div class="topic-metadata">

**Author:** [@ItzGael](https://discourse.nodered.org/u/ItzGael)\
**Replies:** 1\
**Last updated:** [12 October 2025 22:21 UTC](https://discourse.nodered.org/t/ive-got-this-problem-using-node-red-on-a-raspberry-pi-4/99365 "2025-10-12T22:21:06Z")

</div>

Hi im currently using node-red in a raspberry PI 4 but, when I try to start node-red i got this problem, does anybody know how to solve it? This happens when I use node-red-contrib-st-ethernet-ip

---

## [Running Nodered on RPi 5 and connecting to Cerbo GX](https://discourse.nodered.org/t/running-nodered-on-rpi-5-and-connecting-to-cerbo-gx/99121)

<div class="topic-metadata">

**Author:** [@TimosCodeHub](https://discourse.nodered.org/u/TimosCodeHub)\
**Replies:** 3\
**Last updated:** [12 October 2025 21:01 UTC](https://discourse.nodered.org/t/running-nodered-on-rpi-5-and-connecting-to-cerbo-gx/99121 "2025-10-12T21:01:46Z")

</div>

My setup: I have a campervan with an LTE router, a Raspberry Pi 5, several ESP32s, and multiple Victron Energy devices. On the RPi5 I run Node-RED. What I want to do: I’d like to interact with the Victron devices via …

---

## [Shelly relay status](https://discourse.nodered.org/t/shelly-relay-status/99360)

<div class="topic-metadata">

**Author:** [@Herbert](https://discourse.nodered.org/u/Herbert)\
**Replies:** 3\
**Last updated:** [12 October 2025 11:41 UTC](https://discourse.nodered.org/t/shelly-relay-status/99360 "2025-10-12T11:41:26Z")

</div>

Hello, I´m using more shellies first gen in NodeRed with MQTT. Asking if online, show state of relay and turn on and off relay. That works great. I bought a new Shelly, but its name is Shellyplus and the commands are …

---

## [Switching based on objects](https://discourse.nodered.org/t/switching-based-on-objects/99358)

<div class="topic-metadata">

**Author:** [@Newbie01](https://discourse.nodered.org/u/Newbie01)\
**Replies:** 8\
**Last updated:** [12 October 2025 00:10 UTC](https://discourse.nodered.org/t/switching-based-on-objects/99358 "2025-10-12T00:10:30Z")

</div>

Trying to make a switch node to change the flow based on the ON or OFF status. I have tried this so far and none of it works as expected. No matter whats in the object ON or OFF the flow never changes \[ { "i…

---

## [Search: does \`uses:\` flag work and \`uses:selection\` might be an idea?](https://discourse.nodered.org/t/search-does-uses-flag-work-and-uses-selection-might-be-an-idea/99350)

<div class="topic-metadata">

**Author:** [@gregorius](https://discourse.nodered.org/u/gregorius)\
**Replies:** 2\
**Last updated:** [11 October 2025 18:26 UTC](https://discourse.nodered.org/t/search-does-uses-flag-work-and-uses-selection-might-be-an-idea/99350 "2025-10-11T18:26:26Z")

</div>

Hi There, I was playing around with the idea of having a search limited to a selection of nodes/groups when I thought how hard could it be?. So I had a look at the source code and discovered the uses:\<node-id\> flag: v…

[Previous page](https://discourse.nodered.org/c/general/7.md?page=21)

[Next page](https://discourse.nodered.org/c/general/7.md?page=23)