# 🎉 Node-RED 2.0.3 Released

**URL:** <https://discourse.nodered.org/t/node-red-2-0-3-released/48816>\
**Category:** News\
**Created:** [23 July 2021 13:46 UTC](https://discourse.nodered.org/t/node-red-2-0-3-released/48816 "2021-07-23T13:46:33Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [23 July 2021 13:46 UTC](https://discourse.nodered.org/t/node-red-2-0-3-released/48816/1 "2021-07-23T13:46:33Z")

</div>

Node-RED 2.0.3 is now available.

This sweeps up a number of fixes for the HTTP Request node:

> **[Release 2.0.3: Maintenance Release · node-red/node-red](https://github.com/node-red/node-red/releases/tag/2.0.3)**
>
> Nodes
> 
> HTML: Fix HTML parsing when body is included in the select tag Fixes #3079
> HTTP Request: Preserve case of user-provided http headers in request node Fixes #3081
> HTTP Request: Set decompress ...

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [23 July 2021 17:29 UTC](https://discourse.nodered.org/t/node-red-2-0-3-released/48816/2 "2021-07-23T17:29:19Z")

</div>

My live server moved over from 1.3.5 to 2.0.3 and all seems well.

---

<div class="post-metadata">

**Author:** ![ohrenweide](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ohrenweide/32/45450_2.png) [@ohrenweide](https://discourse.nodered.org/u/ohrenweide)\
**Post date:** [24 July 2021 19:29 UTC](https://discourse.nodered.org/t/node-red-2-0-3-released/48816/3 "2021-07-24T19:29:42Z")

</div>

With version 2.0.2 everything worked perfectly for me. After updating to version 2.0.3, HTTP search queries via the Spotify API suddenly no longer returned any results: no error occurred (statusCode: 200), but there were never any search hits (tracks.total = 0). Therefore, I have now (successfully) rolled back to version 2.0.2.

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [24 July 2021 19:38 UTC](https://discourse.nodered.org/t/node-red-2-0-3-released/48816/4 "2021-07-24T19:38:24Z")

</div>

@ohrenweide could you share some more specific details so we can investigate?

---

<div class="post-metadata">

**Author:** ![ohrenweide](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ohrenweide/32/45450_2.png) [@ohrenweide](https://discourse.nodered.org/u/ohrenweide)\
**Post date:** [24 July 2021 20:00 UTC](https://discourse.nodered.org/t/node-red-2-0-3-released/48816/5 "2021-07-24T20:00:38Z")

</div>

```auto
[{"id":"6eebf8b7e1230fe3","type":"function","z":"646f539c81d60090","name":"Suchbegriff ermitteln","func":"msg.url='https://api.spotify.com/v1/search?q=assassin%20john%20mayer%20NOT%20karaoke%20NOT%20arcade&type=track'\n\nmsg.headers = {\n 'Accept': 'application/json',\n 'Content-Type' : 'application/json',\n 'Authorization' : 'Bearer ' + global.get(\"spotify_access_token\")\n};\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[{"var":"he","module":"he"}],"x":510,"y":220,"wires":[["3baf8b9997ee57c5"]]},{"id":"3baf8b9997ee57c5","type":"http request","z":"646f539c81d60090","name":"Titelsuche ausführen (Spotify API)","method":"GET","ret":"obj","paytoqs":"ignore","url":"","tls":"","persist":false,"proxy":"","authType":"","credentials":{},"x":800,"y":220,"wires":[["c1b1d366e7af776c"]]},{"id":"f0f97fad1ab353c1","type":"inject","z":"646f539c81d60090","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":320,"y":220,"wires":[["6eebf8b7e1230fe3"]]},{"id":"c1b1d366e7af776c","type":"debug","z":"646f539c81d60090","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":1070,"y":220,"wires":[]}]

```

This simplified flow works with 2.0.2 but doesn't work with 2.0.3  
Please let me know what else would help you to investigate.

 ![grafik](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/6/7601d4931f08f601a0d6acc2be160a1586f9e911.png)

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [25 July 2021 09:53 UTC](https://discourse.nodered.org/t/node-red-2-0-3-released/48816/6 "2021-07-25T09:53:52Z")

</div>

Hi @ohrenweide

the workaround for you is to change the url to:

```auto
msg.url='https://api.spotify.com/v1/search?q=assassin john mayer NOT karaoke NOT arcade&type=track'

```

An issue had been identified between 1.x and 2.x where a url with non-url safe characters in was now being rejected by the node. The fix for that in 2.0.2 meant we would url-encode the url to make sure it was safe.

However, you've highlighted this will break urls that already have escaped entities in (the `%20` in place of `' '`) - because the `%` will get doubly escaped.

Hence the workaround to change the `%20` back to `' '` in the url you pass in.

Once we get the proper fix in 2.0.4, your code should continue unaffected with either format.

---

<div class="post-metadata">

**Author:** ![ohrenweide](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ohrenweide/32/45450_2.png) [@ohrenweide](https://discourse.nodered.org/u/ohrenweide)\
**Post date:** [25 July 2021 10:08 UTC](https://discourse.nodered.org/t/node-red-2-0-3-released/48816/7 "2021-07-25T10:08:28Z")

</div>

@knolleary  
Thanks for investigating and fixing this so fast. I will wait for 2.0.4 then.

---

<div class="post-metadata">

**Author:** ![Dimitris](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dimitris/32/45273_2.png) [@Dimitris](https://discourse.nodered.org/u/Dimitris)\
**Post date:** [25 July 2021 16:08 UTC](https://discourse.nodered.org/t/node-red-2-0-3-released/48816/8 "2021-07-25T16:08:25Z")

</div>

This simple flow does not work for me in any 2.0.1, 2.0.2, 2.0.3 but it works in 1.3.5

```auto
[{"id":"6e52b77106dbf0a5","type":"postgres","z":"d053359ce32d4637","postgresdb":"52553d9bbf1a0ae3","name":"pg3","output":true,"perrow":false,"rowspermsg":"1","return_on_error":false,"limit_queries":"0","limit_by":"payload","limit_value":"1","limit_drop_intermediate":false,"limit_drop_if_in_queue":false,"outputs":true,"x":270,"y":100,"wires":[["d2aeca35f144cc15"]]},{"id":"d2aeca35f144cc15","type":"debug","z":"d053359ce32d4637","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":470,"y":100,"wires":[]},{"id":"714ae184092c9dc0","type":"inject","z":"d053359ce32d4637","name":"","props":[{"p":"payload"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"select * from wind_speed order by dt desc limit 10","payloadType":"str","x":80,"y":100,"wires":[["6e52b77106dbf0a5"]]},{"id":"52553d9bbf1a0ae3","type":"postgresdb","cfgname":"pgsql3","hostname":"my.private.url","port":"5432","db":"weather_stations","ssl":false}]

```

I don't know if it is a bug in postgres node or in node-red \> v2.x.x.

---

<div class="post-metadata">

**Author:** ![hardillb](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/hardillb/32/12373_2.png) [@hardillb](https://discourse.nodered.org/u/hardillb)\
**Post date:** [25 July 2021 16:35 UTC](https://discourse.nodered.org/t/node-red-2-0-3-released/48816/9 "2021-07-25T16:35:31Z")

</div>

What if any errors are shown in the logs when you run it?

---

<div class="post-metadata">

**Author:** ![Dimitris](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dimitris/32/45273_2.png) [@Dimitris](https://discourse.nodered.org/u/Dimitris)\
**Post date:** [25 July 2021 16:36 UTC](https://discourse.nodered.org/t/node-red-2-0-3-released/48816/10 "2021-07-25T16:36:30Z")

</div>

Nothing at all !!!

---

<div class="post-metadata">

**Author:** ![hardillb](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/hardillb/32/12373_2.png) [@hardillb](https://discourse.nodered.org/u/hardillb)\
**Post date:** [25 July 2021 16:40 UTC](https://discourse.nodered.org/t/node-red-2-0-3-released/48816/11 "2021-07-25T16:40:21Z")

</div>

Which postgres node? there are several on flows. Also the problem is without a postgress database to test against, it's going to be hard to track this down.

I suggest you raise this against the node it's self first as hopefully they will be in a better place to debug this and then raise it against the core project if it is not a problem with the node it's self.

---

<div class="post-metadata">

**Author:** ![Dimitris](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dimitris/32/45273_2.png) [@Dimitris](https://discourse.nodered.org/u/Dimitris)\
**Post date:** [25 July 2021 16:44 UTC](https://discourse.nodered.org/t/node-red-2-0-3-released/48816/12 "2021-07-25T16:44:23Z")

</div>

the node is "node-red-contrib-re-postgres".  
I have tried also " node-red-contrib-mydb" and another one which I don't remember (I think "node-red-contrib-postgrestor-next"), with no results.  
All the above worked perfecty in v1.3.5

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [25 July 2021 16:49 UTC](https://discourse.nodered.org/t/node-red-2-0-3-released/48816/13 "2021-07-25T16:49:16Z")

</div>

Can you share more details on how you're running Node-RED? What version of nodejs etc?

---

<div class="post-metadata">

**Author:** ![Dimitris](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dimitris/32/45273_2.png) [@Dimitris](https://discourse.nodered.org/u/Dimitris)\
**Post date:** [25 July 2021 16:53 UTC](https://discourse.nodered.org/t/node-red-2-0-3-released/48816/14 "2021-07-25T16:53:31Z")

</div>

I have installed it in docker in two systems. A raspberry pi and a hosted VPS. Both have the same results. The installation is fresh. No other nodes are installed. Only the node to access postgresql.  
In docker container console:

```auto
bash-5.0$ npm --version
6.14.13
bash-5.0$ node --version
v14.17.3

```

---

<div class="post-metadata">

**Author:** ![hardillb](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/hardillb/32/12373_2.png) [@hardillb](https://discourse.nodered.org/u/hardillb)\
**Post date:** [25 July 2021 17:23 UTC](https://discourse.nodered.org/t/node-red-2-0-3-released/48816/15 "2021-07-25T17:23:00Z")

</div>

Can we get a better description of "doesn't work".

I've pulled a standard docker postgres image and used the command line tools to create a "weather\_stations" database with a table called "wind\_speed" with a column called "dt" and I get the following in the logs:

```auto
25 Jul 18:18:18 - [error] [postgres:pg3] error: relation "wind_speed" does not exist
error: relation "wind_speed" does not exist
    at Connection.parseE (/opt/share/playing/node-red/test/testUserDir/node_modules/pg/lib/connection.js:614:13)
    at Connection.parseMessage (/opt/share/playing/node-red/test/testUserDir/node_modules/pg/lib/connection.js:413:19)
    at Socket.<anonymous> (/opt/share/playing/node-red/test/testUserDir/node_modules/pg/lib/connection.js:129:22)
    at Socket.emit (events.js:314:20)
    at addChunk (_stream_readable.js:297:12)
    at readableAddChunk (_stream_readable.js:272:9)
    at Socket.Readable.push (_stream_readable.js:213:10)
    at TCP.onStreamRead (internal/stream_base_commons.js:188:23) {
  length: 109,
  severity: 'ERROR',
  code: '42P01',
  detail: undefined,
  hint: undefined,
  position: '15',
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'parse_relation.c',
  line: '1376',
  routine: 'parserOpenTable'
}
select * from wind_speed order by dt desc limit 10
undefined

```

---

<div class="post-metadata">

**Author:** ![Dimitris](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dimitris/32/45273_2.png) [@Dimitris](https://discourse.nodered.org/u/Dimitris)\
**Post date:** [25 July 2021 17:26 UTC](https://discourse.nodered.org/t/node-red-2-0-3-released/48816/16 "2021-07-25T17:26:50Z")

</div>

Doesn't work means that there is nothing at the output of debug node. Not in nodered logs. Like nothing is happening when I click inject node.  
If you want I can give you the credentials in a PM to access my postgres db.

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [25 July 2021 17:42 UTC](https://discourse.nodered.org/t/node-red-2-0-3-released/48816/17 "2021-07-25T17:42:04Z")

</div>

Must admit when I tried the Postgres-re node recently and it failed I just moved on and used another. It was the digitaloak one I used I think

---

<div class="post-metadata">

**Author:** ![Dimitris](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dimitris/32/45273_2.png) [@Dimitris](https://discourse.nodered.org/u/Dimitris)\
**Post date:** [25 July 2021 17:44 UTC](https://discourse.nodered.org/t/node-red-2-0-3-released/48816/18 "2021-07-25T17:44:19Z")

</div>

ok. I will try it and report back. Thank you!

---

<div class="post-metadata">

**Author:** ![Dimitris](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dimitris/32/45273_2.png) [@Dimitris](https://discourse.nodered.org/u/Dimitris)\
**Post date:** [25 July 2021 17:58 UTC](https://discourse.nodered.org/t/node-red-2-0-3-released/48816/19 "2021-07-25T17:58:00Z")

</div>

Finally !!!! This node works. THANK YOU !!!

---

<div class="post-metadata">

**Author:** ![JoseGodinho](https://avatars.discourse-cdn.com/v4/letter/j/f4b2a3/32.png) [@JoseGodinho](https://discourse.nodered.org/u/JoseGodinho)\
**Post date:** [25 July 2021 21:11 UTC](https://discourse.nodered.org/t/node-red-2-0-3-released/48816/20 "2021-07-25T21:11:29Z")

</div>

Inject Node : Pop down window does not match the injected value, when using the inject now.

Having deployed the inject node with one value, this is the value that appears on the pop down window, even if we changed it and use the inject now box.

[Next page](https://discourse.nodered.org/t/node-red-2-0-3-released/48816.md?page=2)