Hello: I have 2 instances of node-red (both v1.1.1), one running on a Mac (Dev) and another on an RPi4 (installed today, prod). I have one table that pulls data from a mySQL database and displays it on the dashboard.
My table works perfectly on the Mac and I exported/imported the flow to the RPi but the table does not show on the RPi. The query is pulling the data but the table area is blank (no headers, no data). Other elements (date-picker etc.) show up correctly.
Flow:
Working table:
Missing table:
I have disabled/enabled the node, added a brand new ui-table node but I cannot get it to show. Any idea what else I could try? Thanks for your help
Table data captured from debug node:
[{"Date":"2020-07-02","Time":"07 10 PM","Source":"automation","Event":"switch","Device":"Virtual LED Notification 2","Value":"off"},{"Date":"2020-07-02","Time":"07 10 PM","Source":"events","Event":"lock","Device":"Front Lock","Value":"locked"},{"Date":"2020-07-02","Time":"06 55 PM","Source":"events","Event":"switch","Device":"Couch Lamp","Value":"on"},{"Date":"2020-07-02","Time":"06 55 PM","Source":"events","Event":"switch","Device":"Couch Lamp","Value":"on"},{"Date":"2020-07-02","Time":"06 54 PM","Source":"automation","Event":"switch","Device":"Virtual Bookcase Lights","Value":"on"},{"Date":"2020-07-02","Time":"06 54 PM","Source":"automation","Event":"switch","Device":"Virtual Couch Lamp","Value":"on"},{"Date":"2020-07-02","Time":"06 44 PM","Source":"automation","Event":"switch","Device":"Virtual LED Notification 1","Value":"off"},{"Date":"2020-07-02","Time":"06 44 PM","Source":"events","Event":"lock","Device":"Garage Lock","Value":"locked"},{"Date":"2020-07-02","Time":"06 43 PM","Source":"events","Event":"contact","Device":"Garage Door","Value":"closed"},{"Date":"2020-07-02","Time":"06 43 PM","Source":"events","Event":"door","Device":"Garage Door","Value":"closed"},{"Date":"2020-07-02","Time":"06 34 PM","Source":"events","Event":"door","Device":"Garage Door","Value":"open"},{"Date":"2020-07-02","Time":"06 34 PM","Source":"events","Event":"contact","Device":"Garage Door","Value":"open"},{"Date":"2020-07-02","Time":"06 34 PM","Source":"automation","Event":"switch","Device":"Virtual LED Notification 1","Value":"on"},{"Date":"2020-07-02","Time":"06 34 PM","Source":"events","Event":"lock","Device":"Garage Lock","Value":"unlocked"},{"Date":"2020-07-02","Time":"06 25 PM","Source":"events","Event":"switch","Device":"Bookcase Lamps","Value":"on"},{"Date":"2020-07-02","Time":"06 25 PM","Source":"events","Event":"illuminance","Device":"Bookcase Multisensor","Value":"11"},{"Date":"2020-07-02","Time":"06 25 PM","Source":"automation","Event":"switch","Device":"Virtual Bookcase Lux","Value":"on"},{"Date":"2020-07-02","Time":"06 10 PM","Source":"events","Event":"illuminance","Device":"Bookcase Multisensor","Value":"49"},{"Date":"2020-07-02","Time":"06 10 PM","Source":"events","Event":"switch","Device":"Bookcase Lamps","Value":"off"},{"Date":"2020-07-02","Time":"06 10 PM","Source":"automation","Event":"switch","Device":"Virtual Bookcase Lux","Value":"off"},{"Date":"2020-07-02","Time":"05 35 PM","Source":"events","Event":"illuminance","Device":"Bookcase Multisensor","Value":"17"},{"Date":"2020-07-02","Time":"05 35 PM","Source":"events","Event":"switch","Device":"Bookcase Lamps","Value":"on"},{"Date":"2020-07-02","Time":"05 35 PM","Source":"automation","Event":"switch","Device":"Virtual Bookcase Lux","Value":"on"},{"Date":"2020-07-02","Time":"03 21 PM","Source":"events","Event":"held","Device":"Kitchen Switch","Value":"1"},{"Date":"2020-07-02","Time":"03 21 PM","Source":"events","Event":"lastEvent","Device":"Kitchen Switch","Value":" Tap ▼"},{"Date":"2020-07-02","Time":"03 21 PM","Source":"events","Event":"switch","Device":"Kitchen Switch","Value":"off"},{"Date":"2020-07-02","Time":"03 21 PM","Source":"events","Event":"pushed","Device":"Kitchen Switch","Value":"1"},{"Date":"2020-07-02","Time":"03 21 PM","Source":"events","Event":"lastEvent","Device":"Kitchen Switch","Value":" Tap ▲"},{"Date":"2020-07-02","Time":"03 21 PM","Source":"events","Event":"switch","Device":"Kitchen Switch","Value":"on"},{"Date":"2020-07-02","Time":"03 21 PM","Source":"events","Event":"switch","Device":"Breakfast Nook Switch","Value":"on"},{"Date":"2020-07-02","Time":"03 21 PM","Source":"automation","Event":"switch","Device":"Virtual LED Notification 2","Value":"off"},{"Date":"2020-07-02","Time":"03 21 PM","Source":"events","Event":"lock","Device":"Front Lock","Value":"locked"},{"Date":"2020-07-02","Time":"03 20 PM","Source":"automation","Event":"switch","Device":"Virtual LED Notification 2","Value":"on"},{"Date":"2020-07-02","Time":"03 20 PM","Source":"events","Event":"lock","Device":"Front Lock","Value":"unlocked"},{"Date":"2020-07-02","Time":"03 20 PM","Source":"events","Event":"lastCodeName","Device":"Front Lock","Value":"Siliva G"},{"Date":"2020-07-02","Time":"02 13 PM","Source":"events","Event":"held","Device":"Kitchen Switch","Value":"1"},{"Date":"2020-07-02","Time":"02 13 PM","Source":"events","Event":"lastEvent","Device":"Kitchen Switch","Value":" Tap ▼"},{"Date":"2020-07-02","Time":"02 13 PM","Source":"events","Event":"switch","Device":"Kitchen Switch","Value":"off"},{"Date":"2020-07-02","Time":"01 49 PM","Source":"events","Event":"held","Device":"Breakfast Nook Switch","Value":"1"},{"Date":"2020-07-02","Time":"01 49 PM","Source":"events","Event":"lastEvent","Device":"Breakfast Nook Switch","Value":" Tap ▼"},{"Date":"2020-07-02","Time":"01 49 PM","Source":"events","Event":"switch","Device":"Breakfast Nook Switch","Value":"off"},{"Date":"2020-07-02","Time":"01 46 PM","Source":"events","Event":"pushed","Device":"Kitchen Switch","Value":"1"},{"Date":"2020-07-02","Time":"01 46 PM","Source":"events","Event":"lastEvent","Device":"Kitchen Switch","Value":" Tap ▲"},{"Date":"2020-07-02","Time":"01 46 PM","Source":"events","Event":"switch","Device":"Kitchen Switch","Value":"on"},{"Date":"2020-07-02","Time":"01 46 PM","Source":"events","Event":"pushed","Device":"Breakfast Nook Switch","Value":"1"},{"Date":"2020-07-02","Time":"01 46 PM","Source":"events","Event":"lastEvent","Device":"Breakfast Nook Switch","Value":" Tap ▲"},{"Date":"2020-07-02","Time":"01 46 PM","Source":"events","Event":"switch","Device":"Breakfast Nook Switch","Value":"on"},{"Date":"2020-07-02","Time":"12 34 PM","Source":"events","Event":"held","Device":"Kitchen Switch","Value":"1"},{"Date":"2020-07-02","Time":"12 34 PM","Source":"events","Event":"lastEvent","Device":"Kitchen Switch","Value":" Tap ▼"},{"Date":"2020-07-02","Time":"12 34 PM","Source":"events","Event":"switch","Device":"Kitchen Switch","Value":"off"},{"Date":"2020-07-02","Time":"12 34 PM","Source":"events","Event":"pushed","Device":"Kitchen Switch","Value":"1"},{"Date":"2020-07-02","Time":"12 05 PM","Source":"events","Event":"pushed","Device":"Kitchen Switch","Value":"1"},{"Date":"2020-07-02","Time":"12 05 PM","Source":"events","Event":"lastEvent","Device":"Kitchen Switch","Value":" Tap ▲"},{"Date":"2020-07-02","Time":"12 05 PM","Source":"events","Event":"switch","Device":"Kitchen Switch","Value":"on"},{"Date":"2020-07-02","Time":"12 04 PM","Source":"events","Event":"pushed","Device":"Kitchen Switch","Value":"7"},{"Date":"2020-07-02","Time":"12 04 PM","Source":"events","Event":"lastEvent","Device":"Kitchen Switch","Value":" Tap ▲▲▲▲▲▲▲"},{"Date":"2020-07-02","Time":"11 54 AM","Source":"automation","Event":"switch","Device":"Virtual LED Notification 2","Value":"off"},{"Date":"2020-07-02","Time":"11 53 AM","Source":"events","Event":"lock","Device":"Front Lock","Value":"locked"},{"Date":"2020-07-02","Time":"11 46 AM","Source":"automation","Event":"switch","Device":"Virtual LED Notification 2","Value":"on"},{"Date":"2020-07-02","Time":"11 46 AM","Source":"events","Event":"lock","Device":"Front Lock","Value":"unlocked"},{"Date":"2020-07-02","Time":"08 39 AM","Source":"events","Event":"switch","Device":"Bookcase Lamps","Value":"off"},{"Date":"2020-07-02","Time":"08 39 AM","Source":"events","Event":"illuminance","Device":"Bookcase Multisensor","Value":"34"},{"Date":"2020-07-02","Time":"08 39 AM","Source":"automation","Event":"switch","Device":"Virtual Bookcase Lux","Value":"off"},{"Date":"2020-07-02","Time":"08 32 AM","Source":"events","Event":"contact","Device":"Garage Door","Value":"closed"},{"Date":"2020-07-02","Time":"08 32 AM","Source":"events","Event":"door","Device":"Garage Door","Value":"closed"},{"Date":"2020-07-02","Time":"08 31 AM","Source":"automation","Event":"switch","Device":"Virtual LED Notification 1","Value":"off"},{"Date":"2020-07-02","Time":"08 31 AM","Source":"events","Event":"lock","Device":"Garage Lock","Value":"locked"},{"Date":"2020-07-02","Time":"08 28 AM","Source":"automation","Event":"switch","Device":"Virtual LED Notification 1","Value":"on"},{"Date":"2020-07-02","Time":"08 28 AM","Source":"events","Event":"lock","Device":"Garage Lock","Value":"unlocked"},{"Date":"2020-07-02","Time":"08 28 AM","Source":"events","Event":"lastCodeName","Device":"Garage Lock","Value":"Rakesh"},{"Date":"2020-07-02","Time":"08 28 AM","Source":"events","Event":"door","Device":"Garage Door","Value":"open"},{"Date":"2020-07-02","Time":"08 28 AM","Source":"events","Event":"contact","Device":"Garage Door","Value":"open"},{"Date":"2020-07-02","Time":"08 24 AM","Source":"events","Event":"switch","Device":"Bookcase Lamps","Value":"on"},{"Date":"2020-07-02","Time":"08 24 AM","Source":"events","Event":"illuminance","Device":"Bookcase Multisensor","Value":"18"},{"Date":"2020-07-02","Time":"08 24 AM","Source":"automation","Event":"switch","Device":"Virtual Bookcase Lux","Value":"on"},{"Date":"2020-07-02","Time":"08 00 AM","Source":"events","Event":"switch","Device":"Living Room 1","Value":"off"},{"Date":"2020-07-02","Time":"08 00 AM","Source":"events","Event":"switch","Device":"Door Way Mirror","Value":"off"},{"Date":"2020-07-02","Time":"07 59 AM","Source":"automation","Event":"switch","Device":"Virtual Entry Way AM","Value":"off"},{"Date":"2020-07-02","Time":"07 45 AM","Source":"events","Event":"door","Device":"Garage Door","Value":"closed"},{"Date":"2020-07-02","Time":"07 45 AM","Source":"events","Event":"contact","Device":"Garage Door","Value":"closed"},{"Date":"2020-07-02","Time":"07 44 AM","Source":"automation","Event":"switch","Device":"Virtual LED Notification 1","Value":"off"},{"Date":"2020-07-02","Time":"07 44 AM","Source":"events","Event":"lock","Device":"Garage Lock","Value":"locked"},{"Date":"2020-07-02","Time":"07 44 AM","Source":"events","Event":"contact","Device":"Garage Door","Value":"open"},{"Date":"2020-07-02","Time":"07 44 AM","Source":"events","Event":"door","Device":"Garage Door","Value":"open"},{"Date":"2020-07-02","Time":"07 44 AM","Source":"automation","Event":"switch","Device":"Virtual LED Notification 1","Value":"on"},{"Date":"2020-07-02","Time":"07 44 AM","Source":"events","Event":"lock","Device":"Garage Lock","Value":"unlocked"},{"Date":"2020-07-02","Time":"07 43 AM","Source":"events","Event":"switch","Device":"Breakfast Nook Switch","Value":"off"},{"Date":"2020-07-02","Time":"07 43 AM","Source":"events","Event":"held","Device":"Breakfast Nook Switch","Value":"1"},{"Date":"2020-07-02","Time":"07 43 AM","Source":"events","Event":"held","Device":"Kitchen Switch","Value":"1"},{"Date":"2020-07-02","Time":"07 43 AM","Source":"events","Event":"lastEvent","Device":"Kitchen Switch","Value":" Tap ▼"},{"Date":"2020-07-02","Time":"07 43 AM","Source":"events","Event":"switch","Device":"Kitchen Switch","Value":"off"},{"Date":"2020-07-02","Time":"07 30 AM","Source":"events","Event":"switch","Device":"Bedroom Lamp","Value":"off"},{"Date":"2020-07-02","Time":"07 29 AM","Source":"automation","Event":"switch","Device":"Virtual Bedroom Lamp","Value":"off"},{"Date":"2020-07-02","Time":"06 22 AM","Source":"events","Event":"sunriseTime","Device":"sunrise time","Value":"2020-07-03T11:23:00.000Z"},{"Date":"2020-07-02","Time":"06 22 AM","Source":"events","Event":"sunrise","Device":"sunrise","Value":"true"},{"Date":"2020-07-02","Time":"06 15 AM","Source":"events","Event":"switch","Device":"Bedroom Lamp","Value":"on"},{"Date":"2020-07-02","Time":"06 14 AM","Source":"automation","Event":"switch","Device":"Virtual Bedroom Lamp","Value":"on"},{"Date":"2020-07-02","Time":"05 56 AM","Source":"events","Event":"pushed","Device":"Kitchen Switch","Value":"1"},{"Date":"2020-07-02","Time":"05 56 AM","Source":"events","Event":"switch","Device":"Kitchen Switch","Value":"on"},{"Date":"2020-07-02","Time":"05 56 AM","Source":"events","Event":"lastEvent","Device":"Kitchen Switch","Value":" Tap ▲"},{"Date":"2020-07-02","Time":"05 56 AM","Source":"events","Event":"switch","Device":"Breakfast Nook Switch","Value":"on"},{"Date":"2020-07-02","Time":"05 15 AM","Source":"events","Event":"switch","Device":"Living Room 1","Value":"on"},{"Date":"2020-07-02","Time":"05 15 AM","Source":"events","Event":"switch","Device":"Door Way Mirror","Value":"on"},{"Date":"2020-07-02","Time":"05 14 AM","Source":"automation","Event":"switch","Device":"Virtual Entry Way AM","Value":"on"},{"Date":"2020-07-02","Time":"03 14 AM","Source":"automation","Event":"switch","Device":"Virtual False Garage","Value":"off"},{"Date":"2020-07-02","Time":"03 14 AM","Source":"automation","Event":"switch","Device":"Virtual False Garage","Value":"on"},{"Date":"2020-07-02","Time":"03 14 AM","Source":"events","Event":"door","Device":"Garage Door","Value":"closed"},{"Date":"2020-07-02","Time":"03 14 AM","Source":"events","Event":"contact","Device":"Garage Door","Value":"closed"},{"Date":"2020-07-02","Time":"03 14 AM","Source":"events","Event":"contact","Device":"Garage Door","Value":"open"},{"Date":"2020-07-02","Time":"03 14 AM","Source":"events","Event":"door","Device":"Garage Door","Value":"open"},{"Date":"2020-07-02","Time":"03 03 AM","Source":"automation","Event":"switch","Device":"Virtual False Garage","Value":"off"},{"Date":"2020-07-02","Time":"03 03 AM","Source":"automation","Event":"switch","Device":"Virtual False Garage","Value":"on"},{"Date":"2020-07-02","Time":"03 03 AM","Source":"events","Event":"contact","Device":"Garage Door","Value":"closed"},{"Date":"2020-07-02","Time":"03 03 AM","Source":"events","Event":"door","Device":"Garage Door","Value":"closed"},{"Date":"2020-07-02","Time":"03 03 AM","Source":"events","Event":"contact","Device":"Garage Door","Value":"open"},{"Date":"2020-07-02","Time":"03 03 AM","Source":"events","Event":"door","Device":"Garage Door","Value":"open"},{"Date":"2020-07-02","Time":"03 03 AM","Source":"automation","Event":"switch","Device":"Virtual False Garage","Value":"off"},{"Date":"2020-07-02","Time":"03 03 AM","Source":"automation","Event":"switch","Device":"Virtual False Garage","Value":"on"},{"Date":"2020-07-02","Time":"03 02 AM","Source":"events","Event":"door","Device":"Garage Door","Value":"closed"},{"Date":"2020-07-02","Time":"03 02 AM","Source":"events","Event":"contact","Device":"Garage Door","Value":"closed"},{"Date":"2020-07-02","Time":"03 02 AM","Source":"events","Event":"contact","Device":"Garage Door","Value":"open"},{"Date":"2020-07-02","Time":"03 02 AM","Source":"events","Event":"door","Device":"Garage Door","Value":"open"},{"Date":"2020-07-02","Time":"03 02 AM","Source":"automation","Event":"switch","Device":"Virtual False Garage","Value":"off"},{"Date":"2020-07-02","Time":"03 02 AM","Source":"automation","Event":"switch","Device":"Virtual False Garage","Value":"on"},{"Date":"2020-07-02","Time":"03 01 AM","Source":"events","Event":"contact","Device":"Garage Door","Value":"closed"},{"Date":"2020-07-02","Time":"03 01 AM","Source":"events","Event":"door","Device":"Garage Door","Value":"closed"},{"Date":"2020-07-02","Time":"03 01 AM","Source":"events","Event":"contact","Device":"Garage Door","Value":"open"},{"Date":"2020-07-02","Time":"03 01 AM","Source":"events","Event":"door","Device":"Garage Door","Value":"open"},{"Date":"2020-07-02","Time":"03 00 AM","Source":"automation","Event":"switch","Device":"Virtual Bedroom Button","Value":"off"}]
UPDATE: A restart of node-red fixed it. Leaving this here in case it helps someone else.
