# General

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

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

**Page:** 148

---

## [Sort ui\_table by timestamp](https://discourse.nodered.org/t/sort-ui-table-by-timestamp/84041)

<div class="topic-metadata">

**Author:** [@druckstick.at](https://discourse.nodered.org/u/druckstick.at)\
**Replies:** 2\
**Last updated:** [26 December 2023 19:31 UTC](https://discourse.nodered.org/t/sort-ui-table-by-timestamp/84041 "2023-12-26T19:31:04Z")

</div>

Hello everybody! I use a mysql database and display the data with the ui\_table. This all works great too. Since the new mysql entries are added at the bottom, ui\_table also displays the new values at the bottom. I wo…

---

## [mySQL, update 2 cells](https://discourse.nodered.org/t/mysql-update-2-cells/84044)

<div class="topic-metadata">

**Author:** [@druckstick.at](https://discourse.nodered.org/u/druckstick.at)\
**Replies:** 1\
**Last updated:** [26 December 2023 18:26 UTC](https://discourse.nodered.org/t/mysql-update-2-cells/84044 "2023-12-26T18:26:32Z")

</div>

Hello everybody! I know how to update a cell with the mySQL node: msg.topic = "UPDATE Tabelle1 SET Column1 = '" + msg.payload.value1+ "' WHERE Zeilen\_ID = " + "'" + msg.payload.ID+ "'";; return msg; But how can I…

---

## [How to create a dynamic inject-node with dynamic timestamp?](https://discourse.nodered.org/t/how-to-create-a-dynamic-inject-node-with-dynamic-timestamp/84026)

<div class="topic-metadata">

**Author:** [@Gawan](https://discourse.nodered.org/u/Gawan)\
**Replies:** 2\
**Last updated:** [25 December 2023 22:20 UTC](https://discourse.nodered.org/t/how-to-create-a-dynamic-inject-node-with-dynamic-timestamp/84026 "2023-12-25T22:20:53Z")

</div>

Hi al, I am used to INJECT Nodes and I know how to set a static time for the node to execute. But is there a possibility to set the time to execute the node somehow dynamically ? I do not want to set a time like "06:0…

---

## [Bug found in node-red-autolayout-sidebar](https://discourse.nodered.org/t/bug-found-in-node-red-autolayout-sidebar/83991)

<div class="topic-metadata">

**Author:** [@ProgrammerPaul](https://discourse.nodered.org/u/ProgrammerPaul)\
**Replies:** 6\
**Last updated:** [25 December 2023 21:17 UTC](https://discourse.nodered.org/t/bug-found-in-node-red-autolayout-sidebar/83991 "2023-12-25T21:17:38Z")

</div>

As per the github readme, I'm posting here and mentioning @gregorius and @bartbutenaers. I also want give my heartfelt thanks for creating this plugin, it's hugely valuable to me! I think I found a bug in the node-red-a…

---

## [Recurring "The flows on the server have been updated" message](https://discourse.nodered.org/t/recurring-the-flows-on-the-server-have-been-updated-message/13885)

<div class="topic-metadata">

**Author:** [@nodecentral](https://discourse.nodered.org/u/nodecentral)\
**Replies:** 69\
**Last updated:** [25 December 2023 19:28 UTC](https://discourse.nodered.org/t/recurring-the-flows-on-the-server-have-been-updated-message/13885 "2023-12-25T19:28:35Z")

</div>

Hi For some reason every time I do a browser refresh, I receive the following prompt ? When I choose “Review change" it says there are no conflicts? Any ideas what could be causing this with the refresh, as no c…

---

## [Alexa & Docker desktop does not respond to my voice after exiting my SSH connection](https://discourse.nodered.org/t/alexa-docker-desktop-does-not-respond-to-my-voice-after-exiting-my-ssh-connection/83984)

<div class="topic-metadata">

**Author:** [@questuk](https://discourse.nodered.org/u/questuk)\
**Replies:** 5\
**Last updated:** [25 December 2023 07:54 UTC](https://discourse.nodered.org/t/alexa-docker-desktop-does-not-respond-to-my-voice-after-exiting-my-ssh-connection/83984 "2023-12-25T07:54:00Z")

</div>

For this first test only, I am NOT using Docker. I installed NodeRED and alexa-remote2-applestrudel 5.0.48 onto a remote Linux PC. I then SSH into the linux PC from my host linux PC. I then start NodeRED, initialise Ale…

---

## [The order of node execution and the relationship between different rule chains](https://discourse.nodered.org/t/the-order-of-node-execution-and-the-relationship-between-different-rule-chains/83947)

<div class="topic-metadata">

**Author:** [@Yesung](https://discourse.nodered.org/u/Yesung)\
**Replies:** 6\
**Last updated:** [25 December 2023 01:24 UTC](https://discourse.nodered.org/t/the-order-of-node-execution-and-the-relationship-between-different-rule-chains/83947 "2023-12-25T01:24:58Z")

</div>

I would like to ask for advice: (1) As shown in rule 3, if a node introduces two branches, which branch will be executed first? What is the execution order of nodes in different branches? (2) As shown in Rule 1 and Rul…

---

## [NR backup and restore flows and nodes](https://discourse.nodered.org/t/nr-backup-and-restore-flows-and-nodes/19170)

<div class="topic-metadata">

**Author:** [@kenkoknz](https://discourse.nodered.org/u/kenkoknz)\
**Replies:** 3\
**Last updated:** [24 December 2023 22:01 UTC](https://discourse.nodered.org/t/nr-backup-and-restore-flows-and-nodes/19170 "2023-12-24T22:01:39Z")

</div>

Hi, I have to clean install Pi Buster and NR on a pi ,following the docs, the installation went smoothly and all is working good. I have done a bacup of all files in .nodered folders. I take it to restore the flows I …

---

## [MQTT over Websockets](https://discourse.nodered.org/t/mqtt-over-websockets/83992)

<div class="topic-metadata">

**Author:** [@FireWizard52](https://discourse.nodered.org/u/FireWizard52)\
**Replies:** 10\
**Last updated:** [24 December 2023 21:55 UTC](https://discourse.nodered.org/t/mqtt-over-websockets/83992 "2023-12-24T21:55:07Z")

</div>

Hello all, I try to retrieve data from the Notification service of the Royal Netherlands Meteorological Institute (KNMI), but I do not have any experience with MQTT over Websockets and so this is quite new for me. Per…

---

## [Securing Node-Red](https://discourse.nodered.org/t/securing-node-red/3561)

<div class="topic-metadata">

**Author:** [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Replies:** 33\
**Last updated:** [24 December 2023 19:50 UTC](https://discourse.nodered.org/t/securing-node-red/3561 "2023-12-24T19:50:48Z")

</div>

I have come to beg for a beginners guide to securing Node-Red which has dashboard elements and is open to the internet. Setting adminAuth & httpNodeAuth as described inSecurity is ok, though I had to sudo npm i bcryptjs…

---

## [Messages sent via "On Start" only reliable on partial deploy but not during " nodered.service" start. Possible?](https://discourse.nodered.org/t/messages-sent-via-on-start-only-reliable-on-partial-deploy-but-not-during-nodered-service-start-possible/83989)

<div class="topic-metadata">

**Author:** [@Mike-FUT](https://discourse.nodered.org/u/Mike-FUT)\
**Replies:** 15\
**Last updated:** [24 December 2023 17:18 UTC](https://discourse.nodered.org/t/messages-sent-via-on-start-only-reliable-on-partial-deploy-but-not-during-nodered-service-start-possible/83989 "2023-12-24T17:18:12Z")

</div>

Hi All, I believe the subject already says it really. I'm running latest Node-RED release with Node 18 and I just finished a big bunch of code that is supposed to run whenever I deploy, NR crashes (luckily rarely happe…

---

## [I am getting error while install the node "npm install node-red-contrib-whatsapp-link"](https://discourse.nodered.org/t/i-am-getting-error-while-install-the-node-npm-install-node-red-contrib-whatsapp-link/84000)

<div class="topic-metadata">

**Author:** [@saraltech](https://discourse.nodered.org/u/saraltech)\
**Replies:** 1\
**Last updated:** [24 December 2023 07:39 UTC](https://discourse.nodered.org/t/i-am-getting-error-while-install-the-node-npm-install-node-red-contrib-whatsapp-link/84000 "2023-12-24T07:39:50Z")

</div>

@Colin : I saw your answers to the subject problem in the following thread: While installing the node, I am getting following errors: C:\\Users\\sinharde.node-red\>npm install node-red-contrib-whatsapp-link npm ERR! cod…

---

## [Athom 15W 1400lm RGBCCT Bulb (LB01-15W-E27)](https://discourse.nodered.org/t/athom-15w-1400lm-rgbcct-bulb-lb01-15w-e27/83997)

<div class="topic-metadata">

**Author:** [@AD2TM](https://discourse.nodered.org/u/AD2TM)\
**Replies:** 1\
**Last updated:** [24 December 2023 00:11 UTC](https://discourse.nodered.org/t/athom-15w-1400lm-rgbcct-bulb-lb01-15w-e27/83997 "2023-12-24T00:11:24Z")

</div>

I would like to be able to adjust the colors on this bulb, but I do not know where to start. What I wouold like to do is once turned on at sunset, which works, set the brilliance to about 95% At about 11:00PM turn the …

---

## [Presence detection - ESP32 Bluetooth Classic scanner](https://discourse.nodered.org/t/presence-detection-esp32-bluetooth-classic-scanner/83988)

<div class="topic-metadata">

**Author:** [@krambriw](https://discourse.nodered.org/u/krambriw)\
**Replies:** 1\
**Last updated:** [23 December 2023 23:45 UTC](https://discourse.nodered.org/t/presence-detection-esp32-bluetooth-classic-scanner/83988 "2023-12-23T23:45:38Z")

</div>

Here is a little interesting project if you are looking for presence detection to be used in your home automation & security system. Myself, I have since years been using Andrew Freyer's Monitor project. How I am using …

---

## ["RequestError: connect ECONNREFUSED 127.0.0.1:443"](https://discourse.nodered.org/t/requesterror-connect-econnrefused-127-0-0-1-443/83993)

<div class="topic-metadata">

**Author:** [@LinkView\_Maze](https://discourse.nodered.org/u/LinkView_Maze)\
**Replies:** 9\
**Last updated:** [23 December 2023 19:25 UTC](https://discourse.nodered.org/t/requesterror-connect-econnrefused-127-0-0-1-443/83993 "2023-12-23T19:25:45Z")

</div>

Hello I Have this error message with node-red v 3.1.3 with request HTTP get What is the probleme ? I have the same flow in node-red v3.0.2 is ok. Thank You

---

## [Failed serial connection to Arduino: No such file or directory error](https://discourse.nodered.org/t/failed-serial-connection-to-arduino-no-such-file-or-directory-error/83970)

<div class="topic-metadata">

**Author:** [@amooro\_123](https://discourse.nodered.org/u/amooro_123)\
**Replies:** 13\
**Last updated:** [23 December 2023 16:16 UTC](https://discourse.nodered.org/t/failed-serial-connection-to-arduino-no-such-file-or-directory-error/83970 "2023-12-23T16:16:25Z")

</div>

I cannot get the serial node to connect to my Arduino Uno on a Zimaboard running Debian 11. Node-red v3.1.3 node.js v16.20.2 This is the error message I get in the debug window when I deploy: "\[serialconfig:0f4961208…

---

## [Moxa RestFul Api](https://discourse.nodered.org/t/moxa-restful-api/83982)

<div class="topic-metadata">

**Author:** [@damica51](https://discourse.nodered.org/u/damica51)\
**Replies:** 0\
**Last updated:** [23 December 2023 14:35 UTC](https://discourse.nodered.org/t/moxa-restful-api/83982 "2023-12-23T14:35:17Z")

</div>

Is anybody using some of the Moxa "Remote I/O" units along with "RestFul Api"?

---

## [Best strategy for Reading & Sorting Electricity Cost Array](https://discourse.nodered.org/t/best-strategy-for-reading-sorting-electricity-cost-array/7929)

<div class="topic-metadata">

**Author:** [@Ian](https://discourse.nodered.org/u/Ian)\
**Replies:** 34\
**Last updated:** [23 December 2023 13:15 UTC](https://discourse.nodered.org/t/best-strategy-for-reading-sorting-electricity-cost-array/7929 "2023-12-23T13:15:10Z")

</div>

Hi I have just switched electricity suppliers to Octopus Energy who I think are maybe one of the first to have variable half hour rates in the UK depending on wholesale price. Naturally I want to make some switching dec…

---

## [Using Fuzzy Logic Sugeno In Node Red](https://discourse.nodered.org/t/using-fuzzy-logic-sugeno-in-node-red/83976)

<div class="topic-metadata">

**Author:** [@fikrinizargustiyana](https://discourse.nodered.org/u/fikrinizargustiyana)\
**Replies:** 1\
**Last updated:** [23 December 2023 10:08 UTC](https://discourse.nodered.org/t/using-fuzzy-logic-sugeno-in-node-red/83976 "2023-12-23T10:08:42Z")

</div>

Can anyone share information regarding nodes for Sugeno fuzzy logic? I'm having trouble configuring fuzzy logic on node -red

---

## [Cannot start service nodered: Address already in use](https://discourse.nodered.org/t/cannot-start-service-nodered-address-already-in-use/83972)

<div class="topic-metadata">

**Author:** [@Shwowak](https://discourse.nodered.org/u/Shwowak)\
**Replies:** 2\
**Last updated:** [22 December 2023 21:47 UTC](https://discourse.nodered.org/t/cannot-start-service-nodered-address-already-in-use/83972 "2023-12-22T21:47:44Z")

</div>

ERROR: for nodered Cannot start service nodered: Address already in use ERROR: for nodered Cannot start service nodered: Address already in use ERROR: Encountered errors while bringing up the project.

---

## [TCP in Node Red Docker Container](https://discourse.nodered.org/t/tcp-in-node-red-docker-container/83966)

<div class="topic-metadata">

**Author:** [@jmcauliffe](https://discourse.nodered.org/u/jmcauliffe)\
**Replies:** 3\
**Last updated:** [22 December 2023 19:51 UTC](https://discourse.nodered.org/t/tcp-in-node-red-docker-container/83966 "2023-12-22T19:51:48Z")

</div>

Hello, I have node red running in a docker container on a raspberry pi and I am trying to send commands over TCP/IP using the TCP I/O node to another computer on my network that runs a server. However, because the docke…

---

## [Default label of function node](https://discourse.nodered.org/t/default-label-of-function-node/83967)

<div class="topic-metadata">

**Author:** [@GammaKappa](https://discourse.nodered.org/u/GammaKappa)\
**Replies:** 4\
**Last updated:** [22 December 2023 19:32 UTC](https://discourse.nodered.org/t/default-label-of-function-node/83967 "2023-12-22T19:32:25Z")

</div>

When I drag a new function node on the work space it is labeled "function 2". Why does it have an index '2' ?

---

## [M5Stack Voltmeter](https://discourse.nodered.org/t/m5stack-voltmeter/83730)

<div class="topic-metadata">

**Author:** [@LA9KY](https://discourse.nodered.org/u/LA9KY)\
**Replies:** 22\
**Last updated:** [22 December 2023 18:19 UTC](https://discourse.nodered.org/t/m5stack-voltmeter/83730 "2023-12-22T18:19:48Z")

</div>

Hi, new to the forum, have a few flows running with easy basic tasks. Now I am trying to find a way to read dc voltage using M5Stack Voltmeter based on ADS1115 on i2c. I can not get any of the nodes to read values fro…

---

## [Calling one function node from another function node](https://discourse.nodered.org/t/calling-one-function-node-from-another-function-node/83958)

<div class="topic-metadata">

**Author:** [@magnusso](https://discourse.nodered.org/u/magnusso)\
**Replies:** 6\
**Last updated:** [22 December 2023 17:52 UTC](https://discourse.nodered.org/t/calling-one-function-node-from-another-function-node/83958 "2023-12-22T17:52:02Z")

</div>

To simplify flows, I would like to call a function node f2 and send a message from f2, from function node f1. What is your opinion of the following solution? \[ { "id": "e0daef4e151b606a", "type": "in…

---

## [Setup Decimal/Hex to binary for buffer-parser](https://discourse.nodered.org/t/setup-decimal-hex-to-binary-for-buffer-parser/83933)

<div class="topic-metadata">

**Author:** [@JohnnyPicnic](https://discourse.nodered.org/u/JohnnyPicnic)\
**Replies:** 8\
**Last updated:** [22 December 2023 17:27 UTC](https://discourse.nodered.org/t/setup-decimal-hex-to-binary-for-buffer-parser/83933 "2023-12-22T17:27:33Z")

</div>

I'm having trouble converting a single decimal to binary and then parsing it with buffer-parser. Let say I have decimal number 256. I'm converting that to a binary string and then into a buffer. var payload = msg.paylo…

---

## [Missing 'Manage Pallet' option, was working just fine](https://discourse.nodered.org/t/missing-manage-pallet-option-was-working-just-fine/83960)

<div class="topic-metadata">

**Author:** [@dougle03](https://discourse.nodered.org/u/dougle03)\
**Replies:** 5\
**Last updated:** [22 December 2023 17:26 UTC](https://discourse.nodered.org/t/missing-manage-pallet-option-was-working-just-fine/83960 "2023-12-22T17:26:31Z")

</div>

Evening all, Odd problem this evening. Pallet manager is missing and so are any non-native nodes like the Home Assistant suit. Was working just fine and no recent changes. Have NR running in docker on a Rpi4 running B…

---

## [So trick to reference exported enum?](https://discourse.nodered.org/t/so-trick-to-reference-exported-enum/83644)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 13\
**Last updated:** [22 December 2023 17:20 UTC](https://discourse.nodered.org/t/so-trick-to-reference-exported-enum/83644 "2023-12-22T17:20:19Z")

</div>

So trick to reference exported enum? How do you reference an exported enum? const { LGTV } = require('lgtv-ip-control'); const TV = new LGTV('x.x.x.x', 'xx:xx:xx:xx:xx:xx', XXXXXXXX'); Object.keys(Keys).forEach(key =\> …

---

## [Simulate the best production sequence with the shortest time](https://discourse.nodered.org/t/simulate-the-best-production-sequence-with-the-shortest-time/83961)

<div class="topic-metadata">

**Author:** [@Manu77](https://discourse.nodered.org/u/Manu77)\
**Replies:** 0\
**Last updated:** [22 December 2023 16:58 UTC](https://discourse.nodered.org/t/simulate-the-best-production-sequence-with-the-shortest-time/83961 "2023-12-22T16:58:37Z")

</div>

Hello, we would like to design equipment with a Robot that can perform several operations. we have several machines with different times, is there a node that allows various simulations to be carried out based on time ,…

---

## [Can't install any node running node-red in with docker compose](https://discourse.nodered.org/t/cant-install-any-node-running-node-red-in-with-docker-compose/83789)

<div class="topic-metadata">

**Author:** [@AxelRHD](https://discourse.nodered.org/u/AxelRHD)\
**Replies:** 16\
**Last updated:** [22 December 2023 14:15 UTC](https://discourse.nodered.org/t/cant-install-any-node-running-node-red-in-with-docker-compose/83789 "2023-12-22T14:15:01Z")

</div>

Hi. I just installed node-red with the following docker compose configuration: version: '3' services: mosquitto: image: eclipse-mosquitto container\_name: mosquitto restart: unless-stopped volum…

---

## [File lister: path in variable](https://discourse.nodered.org/t/file-lister-path-in-variable/83926)

<div class="topic-metadata">

**Author:** [@Medestrac](https://discourse.nodered.org/u/Medestrac)\
**Replies:** 12\
**Last updated:** [22 December 2023 12:47 UTC](https://discourse.nodered.org/t/file-lister-path-in-variable/83926 "2023-12-22T12:47:47Z")

</div>

Hi, I need to check if a file already exist in a folder. I use "file-lister" from node-red-contrib-fs, and it works well, but only if I give it the folder, for example: Start Folder = C:/Users/me/flows/ This folder is…

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

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