# Droplist won't update since new 2.1.0 release

**URL:** <https://discourse.nodered.org/t/droplist-wont-update-since-new-2-1-0-release/53018>\
**Category:** General\
**Created:** [31 October 2021 17:49 UTC](https://discourse.nodered.org/t/droplist-wont-update-since-new-2-1-0-release/53018 "2021-10-31T17:49:26Z")\
**Posts on this page:** 19\
**Page:** 1

<div class="post-metadata">

**Author:** ![ylechasseur](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ylechasseur/32/6549_2.png) [@ylechasseur](https://discourse.nodered.org/u/ylechasseur)\
**Post date:** [31 October 2021 17:49 UTC](https://discourse.nodered.org/t/droplist-wont-update-since-new-2-1-0-release/53018/1 "2021-10-31T17:49:26Z")

</div>

Hi,  
I have Something bizarre since the new 2.1.0 version. On each tab, I use a control\_ui to get the active tab to avoid having any unrequired transactions (query DB).  
It was working nice and since the last update, I have this behaviour:

1. The required query is done on the DB
2. I have my Object array in my msg. options as usual
3. The droplist won't populate anymore

If instead, I don't use the ui\_control and use an inject node (automatic after 0.1 second ) it works well.

I am wondering if anyone notice anything like this ?

Best  
Yves

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [31 October 2021 18:04 UTC](https://discourse.nodered.org/t/droplist-wont-update-since-new-2-1-0-release/53018/2 "2021-10-31T18:04:23Z")

</div>

Using, for example, debug nodes, work out exactly what in the flows is not doing what it should.

---

<div class="post-metadata">

**Author:** ![ylechasseur](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ylechasseur/32/6549_2.png) [@ylechasseur](https://discourse.nodered.org/u/ylechasseur)\
**Post date:** [31 October 2021 18:25 UTC](https://discourse.nodered.org/t/droplist-wont-update-since-new-2-1-0-release/53018/3 "2021-10-31T18:25:08Z")

</div>

Hi Colin,

I do used the debug node for both UI\_control  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/b/db97fa87b5392a4a7b5bad543eaf06f23c503216.png)  
and for my droplist  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/b/4bd6641329ec4a79aeda12046ef8ad661719fb30.png)

and for the droplist

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/8/2/82e4637b334dbf5adcdd6eef1203cf759a0bbdab.png)

very strange - as I was writing, works well before the update..

Thanks  
Yves

---

<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:** [31 October 2021 19:41 UTC](https://discourse.nodered.org/t/droplist-wont-update-since-new-2-1-0-release/53018/4 "2021-10-31T19:41:42Z")

</div>

Make sure you have updated to v2.1.3

---

<div class="post-metadata">

**Author:** ![ylechasseur](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ylechasseur/32/6549_2.png) [@ylechasseur](https://discourse.nodered.org/u/ylechasseur)\
**Post date:** [1 November 2021 11:45 UTC](https://discourse.nodered.org/t/droplist-wont-update-since-new-2-1-0-release/53018/5 "2021-11-01T11:45:57Z")

</div>

Thanks for the reply,

I will do the updates,

Here what happened ;

I rollback to 2.5 (My backup done previous updating) after 2.1 installation, when I get the problems.

I am still on 2.5 and the problem came back once I updated the Dashboard nodes.

I will install 2.1 and then, do I have to install the sp 2.1.2 and then 2.1.3 or, once 2.1 is reinstalled, I can simply install 2.1.3 over it and skip 2.1.2 ?

I imagine I unzip and copy over the files into the proper folder ?

best

Yves

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [1 November 2021 12:01 UTC](https://discourse.nodered.org/t/droplist-wont-update-since-new-2-1-0-release/53018/6 "2021-11-01T12:01:45Z")

</div>

> [@ylechasseur](#):
>
> I rollback to 2.5

2.5 of what?

> [@ylechasseur](#):
>
> I imagine I unzip and copy over the files into the proper folder ?

No, what OS are you on and how did you install node-red initially and how did you upgrade to 2.1.0?

---

<div class="post-metadata">

**Author:** ![ylechasseur](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ylechasseur/32/6549_2.png) [@ylechasseur](https://discourse.nodered.org/u/ylechasseur)\
**Post date:** [1 November 2021 16:08 UTC](https://discourse.nodered.org/t/droplist-wont-update-since-new-2-1-0-release/53018/7 "2021-11-01T16:08:54Z")

</div>

Sorry, I mean 2.05  
Node-red is running under PI  
NodeJ : v12.22.6  
Linux: Linux 5.10.63-v7l+ #1457 SMP Tue Sep 28 11:26:14 BST 2021 armv7l GNU/Linux

I did the update to Node-Red 2.1.3 and still the same beaviours.

I will update my Nodej version to the newest supported by my OS and my linux as well.

Keep you posted

Yves

---

<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:** [1 November 2021 16:11 UTC](https://discourse.nodered.org/t/droplist-wont-update-since-new-2-1-0-release/53018/8 "2021-11-01T16:11:23Z")

</div>

Hi @ylechasseur

The Dashboard set of nodes are independent of the core. Upgrading the core node-red to 2.1.x should not have any effect on the dashboard behaviour.

Likewise, upgrading node.js and linux, whilst always good to keep current, are not going to play any part in figuring out what is happening here.

What version of Node-RED Dashboard have you got installed?

---

<div class="post-metadata">

**Author:** ![ylechasseur](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ylechasseur/32/6549_2.png) [@ylechasseur](https://discourse.nodered.org/u/ylechasseur)\
**Post date:** [1 November 2021 21:15 UTC](https://discourse.nodered.org/t/droplist-wont-update-since-new-2-1-0-release/53018/9 "2021-11-01T21:15:04Z")

</div>

Hi Nick,

Thanks for your reply, it is very appreciated.

All the droplist won't populate but all the other fields (Textbox or label) are populated by the Mysql Query result. I have several tabs with mix of Droplist othe field types and they all have the same behaviors.  
The switch node validate the Tab name and it is working well.

- Queries are done
- the droplist won't populate.

On the same tab, if instead I use Inject,

- Queries are done
- the droplist are populated.

Thanks a lot and thanks so mutch for this wonderful product

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/6/160db0031c87c4227128bf200355455915b9e5f2.png)

Node-Red : 2.1.3  
nodeJ: node-v16.13.0  
Rasp Pi : has been updated as well

On the console logs, I get this error message when I open a TAB who should to a request on My SQL

1 Nov 16:50:14 - [warn] [http response:http out dash] No response object

Here is an exemple the code

```auto
[{"id":"a7829e8b94ca047e","type":"subflow","name":"Query - Dynamic","info":"","category":"","in":[{"x":65,"y":75,"wires":[{"id":"350789b45ba53fb3"}]}],"out":[{"x":560,"y":75,"wires":[{"id":"1331a762b80ebe09","port":0}]}],"env":[],"meta":{},"color":"#DDAA99"},{"id":"1331a762b80ebe09","type":"mysql","z":"a7829e8b94ca047e","mydb":"a9587441.1a7a98","name":"DB - Bmind","x":430,"y":75,"wires":[[]]},{"id":"350789b45ba53fb3","type":"function","z":"a7829e8b94ca047e","name":"prepareQuerysc","func":"var query=msg.sql;\nmsg.topic = query;\nreturn msg;\n\n\n\n","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":230,"y":75,"wires":[["1331a762b80ebe09"]]},{"id":"a9587441.1a7a98","type":"MySQLdatabase","name":"DB - Bmind","host":"192.168.0.254","port":"3306","db":"Raysub1","tz":"","charset":""},{"id":"d2b3f29cabb012cb","type":"ui_ui_control","z":"20638da65a4e7b54","name":"","events":"all","x":105,"y":135,"wires":[["05c833f73d466912"]]},{"id":"05c833f73d466912","type":"switch","z":"20638da65a4e7b54","name":"","property":"name","propertyType":"msg","rules":[{"t":"eq","v":"Inventory-Add","vt":"str"},{"t":"else"}],"checkall":"true","repair":false,"outputs":2,"x":95,"y":180,"wires":[["07f99f3172d5edef","bf07927bcae33e6f"],[]]},{"id":"bf07927bcae33e6f","type":"link out","z":"20638da65a4e7b54","name":"","links":["6c231bb996139c64","dca4c8df7dc25830"],"x":255,"y":135,"wires":[]},{"id":"dca4c8df7dc25830","type":"link in","z":"20638da65a4e7b54","name":"selection_in","links":["bf07927bcae33e6f"],"x":360,"y":240,"wires":[["bb3e23d67b251664"]]},{"id":"bb3e23d67b251664","type":"change","z":"20638da65a4e7b54","name":"Set Query","rules":[{"t":"set","p":"sql","pt":"msg","to":"SELECT * FROM Parts_Category;","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":495,"y":240,"wires":[["560c968aa12f489e"]]},{"id":"560c968aa12f489e","type":"subflow:a7829e8b94ca047e","z":"20638da65a4e7b54","name":"","env":[],"x":690,"y":240,"wires":[["5803d21104f84ce3"]]},{"id":"5803d21104f84ce3","type":"function","z":"20638da65a4e7b54","name":"format array of objects for dropdown ","func":"//Reformat array to work with dashboard\nvar reformattedArray = msg.payload.map(obj =>{\n //declare the reformatted object\n var rObj = {};\n //format it for drop down\n //\"label\":\"value\" is the format so lets move the value to the label and add some txt as well\n //you can also replce the txt with a var if you want\n rObj[obj.name] = obj.idCategory;\n return rObj;\n});\nmsg.payload = reformattedArray;\nreturn msg;\n\n//Reformat array to work with dashboard\n/*var reformattedArray = msg.payload.map(obj =>{\nvar rObj = {};\nrObj[obj.boatname+\" \"+obj.temp.toFixed(1)+\"°C\"+' | '+(((obj.temp*9)/5)+32).toFixed(1)+\"°F\"] = obj.idboat;\nreturn rObj;\n});*/\n\n","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":990,"y":240,"wires":[["2928df797d4babb6"]]},{"id":"2928df797d4babb6","type":"change","z":"20638da65a4e7b54","name":"","rules":[{"t":"set","p":"options","pt":"msg","to":"payload","tot":"msg"},{"t":"set","p":"topic","pt":"msg","to":"Part Category","tot":"str"},{"t":"set","p":"records","pt":"msg","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":1295,"y":240,"wires":[["33d76b4e1856fd0e"]]},{"id":"33d76b4e1856fd0e","type":"ui_dropdown","z":"20638da65a4e7b54","name":"DL_Part_Cat","label":"{{msg.topic}}","tooltip":"","place":"","group":"9a0a523fe3e4c330","order":1,"width":6,"height":1,"passthru":true,"multiple":false,"options":[{"label":"","value":"","type":"str"}],"payload":"","topic":"SelectDone","topicType":"msg","className":"","x":1525,"y":240,"wires":[["f4c08d8dbe946b66","47c40e86839fc384"]],"outputLabels":["loulou"]},{"id":"f4c08d8dbe946b66","type":"change","z":"20638da65a4e7b54","name":"Cat_Part_ID","rules":[{"t":"set","p":"Cat_Part_ID","pt":"flow","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":1795,"y":240,"wires":[[]]},{"id":"9a0a523fe3e4c330","type":"ui_group","name":"DropList","tab":"8a11ed5db152ab89","order":4,"disp":false,"width":"18","collapse":false,"className":""},{"id":"8a11ed5db152ab89","type":"ui_tab","name":"Inventory-Add","icon":"dashboard","order":12,"disabled":false,"hidden":false}]

```

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [2 November 2021 01:05 UTC](https://discourse.nodered.org/t/droplist-wont-update-since-new-2-1-0-release/53018/10 "2021-11-02T01:05:09Z")

</div>

What version of node-red-dashboard are you running? (you can get this from the palette manager or from the node-red startup log)

There was a problem with the ui-dropdown but I beleive it was fixed in version 2.8.0 - note the current release of the dashboard is v3.1.0

---

<div class="post-metadata">

**Author:** ![ylechasseur](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ylechasseur/32/6549_2.png) [@ylechasseur](https://discourse.nodered.org/u/ylechasseur)\
**Post date:** [2 November 2021 09:43 UTC](https://discourse.nodered.org/t/droplist-wont-update-since-new-2-1-0-release/53018/11 "2021-11-02T09:43:28Z")

</div>

Hi ,

Here the full story:

1. Backup my PI Micro SD

2. Update from 2.0.5 to 2.1.0

3. Problems with UI\_dropdown

4. Try to find out what could be wrong

5. When back PI Micro SD (version 2.05)

6. Last Weekend on my original PI Micro SD card with Node-red 2.0.5

7. Several nodes updated

8. Upgrade to Dashboard 3.1

9. Same problem with UI\_dropdown as when I upgrade from 2.05 to 2.1

10. Yesterday

11. Update Node-red to 2.1.3

12. Update Nodej to 16.x

13. Update linux to leastest

Still the same UI\_dropdown problems

Thanks to all, it is very appreciated  
Yves

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [2 November 2021 09:55 UTC](https://discourse.nodered.org/t/droplist-wont-update-since-new-2-1-0-release/53018/12 "2021-11-02T09:55:50Z")

</div>

> [@ylechasseur](#):
>
> The switch node validate the Tab name and it is working well.
> 
> - Queries are done
> - the droplist won't populate.
> 
> On the same tab, if instead I use Inject,
> 
> - Queries are done
> - the droplist are populated.

If you are getting two different results from a node when you send it a message (if everything else is the same) then there must be a difference in the message you are sending in the two cases. Use debug nodes set to output Complete Message and look for the difference.

---

<div class="post-metadata">

**Author:** ![ylechasseur](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ylechasseur/32/6549_2.png) [@ylechasseur](https://discourse.nodered.org/u/ylechasseur)\
**Post date:** [2 November 2021 10:15 UTC](https://discourse.nodered.org/t/droplist-wont-update-since-new-2-1-0-release/53018/13 "2021-11-02T10:15:45Z")

</div>

Hi Colin,

That is the problem,  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/8/8/882f15910dec932543b22aff7ec20d7db9e59b32.png)

This is the print screen debug - Using Inject Nodes (2) (UI\_control goes not used)  
Inject 1 - Send Empty Payload to clear the fields  
Inject 2 - Delay 1 second and Inject

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/9/5979edb1a551e13966efe3d1c21bcd0204815f87.png)

Before the UI\_DROPDOWN  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/6/d69bbcdcf0214f57403a8502ba3daad844ca2905.png)

After UI\_DROPDOWN - Selection can be made in the UI\_DropDown  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/e/e/ee0537b70f6e8bf3f65927a9ec0236b8c18a0f89.png)

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/b/0b68f6fdcac876a380097e3038c7c27c2d5a586b.png)

Now without Inject but using UI\_Control to validate the active TAB

1. Top link, send Empty msg,payload to clear fields on the tab
2. The other one, wait 1 second

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/a/0a8e0fd773c70187d4fe785e258be26a258e1e0d.png)

and my UI\_DROPDOWN - Empty  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/c/0c15f75a8ce9b027cee3f99cc9d692b97d6ffe25.png)

et voilà

Best

Yves

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [2 November 2021 11:22 UTC](https://discourse.nodered.org/t/droplist-wont-update-since-new-2-1-0-release/53018/14 "2021-11-02T11:22:56Z")

</div>

In the flow you provided you have a function node after the mysql node. Can you add a debug node (set to display the complete msg object) and show us what that gives.

Also what happens if you click on the dropdown in the dashboard. In my tests while it initially shows empty, once you click on it, a list shows up.

---

<div class="post-metadata">

**Author:** ![ylechasseur](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ylechasseur/32/6549_2.png) [@ylechasseur](https://discourse.nodered.org/u/ylechasseur)\
**Post date:** [2 November 2021 11:50 UTC](https://discourse.nodered.org/t/droplist-wont-update-since-new-2-1-0-release/53018/15 "2021-11-02T11:50:53Z")

</div>

Hi, Sorry I forget to add this printscreen

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/c/bcd824b7a54aea24d53f34f6d94cd92cd7493c34.png)

So the Debug messages showed on the previous post  
MSG1 : The result is exactly the same for both ways to populate the UI\_DropDown ( UI\_control or Inject)  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/4/54eaa6faad560ce9ddf493707237056c15dde56c.png)

MSG2:

**UI\_Control** : No debug message because can't do any selection in the UI\_DropDown - Empty  
**Inject** : The Selection I have done

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/9/99582bed3870a7aabff1ed327358d13183c9eab0.png)  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/1/419895cc8fcd681a8d0351834eab0c26379c8567.png)

it is probably a small thing, and I have the same behaviors for all UI\_Dropdown even. if I have several UI\_DropDown on the same TAB and as well on other tabs

Best

Yves

---

<div class="post-metadata">

**Author:** ![ylechasseur](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ylechasseur/32/6549_2.png) [@ylechasseur](https://discourse.nodered.org/u/ylechasseur)\
**Post date:** [4 November 2021 08:56 UTC](https://discourse.nodered.org/t/droplist-wont-update-since-new-2-1-0-release/53018/16 "2021-11-04T08:56:46Z")

</div>

Hi,

The problem seems to be or related to UI\_CONTROL. I am using this node on several tabs to get the active tabs name or number and then doing tab related task. Often to refresh display label and, as UI\_dropDown, they won't refresh until I remove the UI\_Control from the page (even if it is not connected to anything ) and then it is working.

Best

Yves

---

<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:** [4 November 2021 08:59 UTC](https://discourse.nodered.org/t/droplist-wont-update-since-new-2-1-0-release/53018/17 "2021-11-04T08:59:49Z")

</div>

Do you need more than one ? I would think you can use a single ui\_control node to receive the data/events and then use link nodes to send to other tabs.

---

<div class="post-metadata">

**Author:** ![ylechasseur](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ylechasseur/32/6549_2.png) [@ylechasseur](https://discourse.nodered.org/u/ylechasseur)\
**Post date:** [5 November 2021 20:20 UTC](https://discourse.nodered.org/t/droplist-wont-update-since-new-2-1-0-release/53018/18 "2021-11-05T20:20:20Z")

</div>

Hi dceejay,

I didn't realize to use only one UI\_control. I will clean up my app and see if it will help ( it should)

Thanks a lot for your help

Yves

---

<div class="post-metadata">

**Author:** ![ylechasseur](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ylechasseur/32/6549_2.png) [@ylechasseur](https://discourse.nodered.org/u/ylechasseur)\
**Post date:** [9 November 2021 17:52 UTC](https://discourse.nodered.org/t/droplist-wont-update-since-new-2-1-0-release/53018/19 "2021-11-09T17:52:36Z")

</div>

Hi,

Following DceeJay I removed almost all my UI\_control that I was miss using and with the new version improvements, it wasn't compliant anymore.

By doing that, it clean up the app as well as making de DropDown working

Thanks a lot DceeJay for the suggestion