Node not deleting entirely

General
1

I have a small flow running that I had previously being pushing some data to ubidots via the ubidots-out node. I have quit using ubidots so I deleted the node from my flow.

It no longer shows up in my flow anywhere, but seems to still be running in the background. I don't get any messages from it in the debug window, but I see a lot of logs in the command prompt related to this node getting connected, etc.

If I go to the pallette, it won't let me remove it since its 'in use'. I am not sure where it is in use or how to figure out to remove it altogether from my project.

can you direct me on which way to head?

2

You may need to take some screen shots and post them...

(I see someone else smarter than me is also now replying, so I'll leave what I said at that)

3

image
image727Ă—841 48.9 KB

image
image640Ă—697 30.8 KB

image
image1433Ă—892 65.4 KB

start with this?

4

It probably has a Configuration Node lurking in the background.

If you open the info sidebar and search for whatever node type is reported as "in use", you should find something in the config node section. Double click to open its edit dialog and delete it.

5

Thanks gentlemen!

This is what I see under configuration nodes (at least if I am going to the right place).

The ubidots node doesn't show up here.

image
image617Ă—501 12.7 KB

6

What do you see if you Search (from menu or Ctrl-F) for ubidots.

If nothing then stop node-red and start it again in a terminal. Post the full console output here, including the errors you are seeing which should appear there.

7

Hi Colin,

This is what I get with a general search. It shows the Ubidots icon but nothing happens when I click or doubleclick on it.

image
image1130Ă—934 20.5 KB

I will try a stop and restart and see what happens. I hadn't tried that.

8

Sounds like there is a configuration node that still exists. In the left hand sidebar click the configuration tab and see if there is an unused node. If so delete it then try to remove the node.

9

After I restarted node red, this is what I got in the terminal.

image
image1920Ă—1178 138 KB

I am no longer getting lots of ubidot connections logs in the terminal like I was before.

But it still shows as in-use in the palette.
image

I'm not sure what the "BAIL ON" line represents?
that might be related, but it mentions the ubidots_in node when the one that shows in use is the ubidot-out.

10

Do you mean the right hand? I don't see anything on the left hand sidebar such as configuration

image

11

I think we have been through looking for a config node earlier in the thread and it seems it isn't that.

12

If you open the flows file with a text editor and search for ubidots does it find it? Perhaps better to make of copy of the file first and look at that. Though hopefully you have been backing it up anyway. If it does find it then post that section of the file. When posting logs and similar then please copy/paste rather than screenshot. Use the </> button at the top of the forum entry window when pasting it in.

13

here is what I get when exporting current flow

This is what I get when exporting current flow. 
[
    {
        "id": "8eba06c2d561584a",
        "type": "tab",
        "label": "Flow 1",
        "disabled": false,
        "info": "",
        "env": []
    },
    {
        "id": "3f964824e41821b8",
        "type": "modbus-read",
        "z": "8eba06c2d561584a",
        "name": "",
        "topic": "",
        "showStatusActivities": true,
        "logIOActivities": false,
        "showErrors": true,
        "unitid": "",
        "dataType": "HoldingRegister",
        "adr": "0",
        "quantity": "10",
        "rate": "2",
        "rateUnit": "s",
        "delayOnStart": false,
        "startDelayTime": "",
        "server": "a39cafbda5d1a286",
        "useIOFile": false,
        "ioFile": "",
        "useIOForPayload": false,
        "emptyMsgOnFail": false,
        "x": 150,
        "y": 200,
        "wires": [
            [],
            [
                "dcf04a493af33c1b"
            ]
        ]
    },
    {
        "id": "dcf04a493af33c1b",
        "type": "function",
        "z": "8eba06c2d561584a",
        "name": "get the data we want",
        "func": "\n//pull the variables we want out of the array\n//divide by 10 to get the resolution right\n\nvar p1Amps = msg.payload.data [0]/10;\nvar p2Amps = msg.payload.data [2]/10;\nvar p1Hours = msg.payload.data [4]/10;\nvar p2Hours = msg.payload.data [6]/10;\nvar waterlevel = msg.payload.data [8]/10;\n\n// separate them and add a topic to send to the local dashboard.\n\nvar p1A = { payload: p1Amps, topic: \"Pump 1 Amps\" };\nvar p2A = { payload: p2Amps, topic: \"Pump 2 Amps\" };\nvar p1H = { payload: p1Hours, topic: \"Pump 1 Hours\" };\nvar p2H = { payload: p2Hours, topic: \"Pump 2 Hours\" };\nvar watlev = { payload: waterlevel, topic: \"Water Level\" };\n\n\n\n//collect the data and format it in one payload to send to sqlite\nvar sqlite= {}\nsqlite.payload = { \"Pump 1 Amps\": p1Amps, \"Pump 2 Amps\": p2Amps, \"Pump 1 Hours\": p1Hours, \"Pump 2 Hours\": p2Hours, \"Water Level\": waterlevel};\n\n//return the variables on individual node outputs\nreturn [p1A, p2A, p1H, p2H, watlev, sqlite];\n\n",
        "outputs": 6,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 400,
        "y": 200,
        "wires": [
            [
                "a7d9d7b6f2d5d187",
                "9d01d7bd2e0e2adc"
            ],
            [
                "7aa4f90ceea3e66f",
                "9d01d7bd2e0e2adc"
            ],
            [
                "1f6d7455338598e2"
            ],
            [
                "6010df42fb592dc9"
            ],
            [
                "2d8bb3a2398c9bce",
                "9d01d7bd2e0e2adc"
            ],
            [
                "870f74b5fed802d7",
                "cd718b1ffe8dd8f0"
            ]
        ]
    },
    {
        "id": "a7d9d7b6f2d5d187",
        "type": "debug",
        "z": "8eba06c2d561584a",
        "name": "P1 amps",
        "active": false,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "true",
        "targetType": "full",
        "statusVal": "",
        "statusType": "auto",
        "x": 880,
        "y": 180,
        "wires": []
    },
    {
        "id": "7aa4f90ceea3e66f",
        "type": "debug",
        "z": "8eba06c2d561584a",
        "name": "P2 amps",
        "active": false,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "true",
        "targetType": "full",
        "statusVal": "",
        "statusType": "auto",
        "x": 880,
        "y": 220,
        "wires": []
    },
    {
        "id": "1f6d7455338598e2",
        "type": "debug",
        "z": "8eba06c2d561584a",
        "name": "P1 hours",
        "active": false,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "true",
        "targetType": "full",
        "statusVal": "",
        "statusType": "auto",
        "x": 880,
        "y": 260,
        "wires": []
    },
    {
        "id": "6010df42fb592dc9",
        "type": "debug",
        "z": "8eba06c2d561584a",
        "name": "P2 hours",
        "active": false,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "true",
        "targetType": "full",
        "statusVal": "",
        "statusType": "auto",
        "x": 880,
        "y": 300,
        "wires": []
    },
    {
        "id": "2d8bb3a2398c9bce",
        "type": "debug",
        "z": "8eba06c2d561584a",
        "name": "level",
        "active": false,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "true",
        "targetType": "full",
        "statusVal": "",
        "statusType": "auto",
        "x": 870,
        "y": 340,
        "wires": []
    },
    {
        "id": "9d01d7bd2e0e2adc",
        "type": "ui_chart",
        "z": "8eba06c2d561584a",
        "name": "",
        "group": "5898ce021b9512c6",
        "order": 0,
        "width": 0,
        "height": 0,
        "label": "local chart",
        "chartType": "line",
        "legend": "false",
        "xformat": "HH:mm:ss",
        "interpolate": "linear",
        "nodata": "",
        "dot": false,
        "ymin": "",
        "ymax": "",
        "removeOlder": "5",
        "removeOlderPoints": "2500",
        "removeOlderUnit": "3600",
        "cutout": 0,
        "useOneColor": false,
        "useUTC": false,
        "colors": [
            "#1f77b4",
            "#aec7e8",
            "#ff7f0e",
            "#2ca02c",
            "#98df8a",
            "#d62728",
            "#ff9896",
            "#9467bd",
            "#c5b0d5"
        ],
        "outputs": 1,
        "useDifferentColor": false,
        "className": "",
        "x": 890,
        "y": 440,
        "wires": [
            []
        ]
    },
    {
        "id": "870f74b5fed802d7",
        "type": "debug",
        "z": "8eba06c2d561584a",
        "name": "SQlite",
        "active": false,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "true",
        "targetType": "full",
        "statusVal": "",
        "statusType": "auto",
        "x": 870,
        "y": 400,
        "wires": []
    },
    {
        "id": "6d26aef86a598ff8",
        "type": "inject",
        "z": "8eba06c2d561584a",
        "name": "reset local dashboard graph",
        "props": [
            {
                "p": "payload"
            },
            {
                "p": "topic",
                "vt": "str"
            }
        ],
        "repeat": "",
        "crontab": "",
        "once": false,
        "onceDelay": 0.1,
        "topic": "",
        "payload": "[ ]",
        "payloadType": "json",
        "x": 180,
        "y": 420,
        "wires": [
            [
                "9d01d7bd2e0e2adc"
            ]
        ]
    },
    {
        "id": "09a078dc88def992",
        "type": "sqlite",
        "z": "8eba06c2d561584a",
        "mydb": "9cd4a3cdd1baab8c",
        "sqlquery": "msg.topic",
        "sql": "INSERT INTO rhod_testing (LEVEL, PUMPONEAMPS)\nVALUES (msg.payload.P1amps,msg.payload.P2amps);\n",
        "name": "Rhododendron SQlite",
        "x": 740,
        "y": 720,
        "wires": [
            []
        ]
    },
    {
        "id": "935d4e40d3897d6d",
        "type": "debug",
        "z": "8eba06c2d561584a",
        "name": "to SQlite",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "topic",
        "targetType": "msg",
        "statusVal": "",
        "statusType": "auto",
        "x": 720,
        "y": 780,
        "wires": []
    },
    {
        "id": "cd718b1ffe8dd8f0",
        "type": "function",
        "z": "8eba06c2d561584a",
        "name": "Rhododendron SQlite",
        "func": "//compile msg to send to sqlite. add time in the first column. SqLite interprets \"current_timestamp and returns the correct time in the DB\"\n\nvar dbMsg = {\n \"topic\": \"INSERT INTO Rhododendron VALUES ( CURRENT_TIMESTAMP, \" + msg.payload[\"Pump 1 Amps\"] + \", \" + msg.payload[\"Pump 2 Amps\"] + \",  \" + msg.payload[\"Pump 1 Hours\"] + \",  \" + msg.payload[\"Pump 2 Hours\"] + \",  \" + msg.payload[\"Water Level\"] + \")\"\n}\nreturn dbMsg;\n",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 460,
        "y": 740,
        "wires": [
            [
                "935d4e40d3897d6d",
                "09a078dc88def992"
            ]
        ]
    },
    {
        "id": "a47db449e7205e14",
        "type": "comment",
        "z": "8eba06c2d561584a",
        "name": "disect the array coming via modbus",
        "info": "",
        "x": 420,
        "y": 120,
        "wires": []
    },
    {
        "id": "7c2956420f6f0c12",
        "type": "comment",
        "z": "8eba06c2d561584a",
        "name": "load information into msg.topic to send to Sqlite",
        "info": "",
        "x": 420,
        "y": 660,
        "wires": []
    },
    {
        "id": "a39cafbda5d1a286",
        "type": "modbus-client",
        "name": "",
        "clienttype": "tcp",
        "bufferCommands": true,
        "stateLogEnabled": false,
        "queueLogEnabled": false,
        "tcpHost": "10.16.41.1",
        "tcpPort": "502",
        "tcpType": "DEFAULT",
        "serialPort": "/dev/ttyUSB",
        "serialType": "RTU-BUFFERD",
        "serialBaudrate": "9600",
        "serialDatabits": "8",
        "serialStopbits": "1",
        "serialParity": "none",
        "serialConnectionDelay": "100",
        "serialAsciiResponseStartDelimiter": "0x3A",
        "unit_id": "1",
        "commandDelay": "1",
        "clientTimeout": "5000",
        "reconnectOnTimeout": true,
        "reconnectTimeout": "1000",
        "parallelUnitIdsAllowed": false
    },
    {
        "id": "5898ce021b9512c6",
        "type": "ui_group",
        "name": "Default",
        "tab": "36adcc21cef5324f",
        "order": 1,
        "disp": true,
        "width": "29",
        "collapse": false,
        "className": ""
    },
    {
        "id": "9cd4a3cdd1baab8c",
        "type": "sqlitedb",
        "db": "/home/leslie/SQlite Databases/Rhododendron",
        "mode": "RWC"
    },
    {
        "id": "36adcc21cef5324f",
        "type": "ui_tab",
        "name": "level graph",
        "icon": "dashboard",
        "disabled": false,
        "hidden": false
    }
]
This is what I get when exporting all flows. 
[
    {
        "id": "8eba06c2d561584a",
        "type": "tab",
        "label": "Flow 1",
        "disabled": false,
        "info": "",
        "env": []
    },
    {
        "id": "a39cafbda5d1a286",
        "type": "modbus-client",
        "name": "",
        "clienttype": "tcp",
        "bufferCommands": true,
        "stateLogEnabled": false,
        "queueLogEnabled": false,
        "tcpHost": "10.16.41.1",
        "tcpPort": "502",
        "tcpType": "DEFAULT",
        "serialPort": "/dev/ttyUSB",
        "serialType": "RTU-BUFFERD",
        "serialBaudrate": "9600",
        "serialDatabits": "8",
        "serialStopbits": "1",
        "serialParity": "none",
        "serialConnectionDelay": "100",
        "serialAsciiResponseStartDelimiter": "0x3A",
        "unit_id": "1",
        "commandDelay": "1",
        "clientTimeout": "5000",
        "reconnectOnTimeout": true,
        "reconnectTimeout": "1000",
        "parallelUnitIdsAllowed": false
    },
    {
        "id": "36adcc21cef5324f",
        "type": "ui_tab",
        "name": "level graph",
        "icon": "dashboard",
        "disabled": false,
        "hidden": false
    },
    {
        "id": "d337100f15b0caf3",
        "type": "ui_base",
        "theme": {
            "name": "theme-light",
            "lightTheme": {
                "default": "#0094CE",
                "baseColor": "#0094CE",
                "baseFont": "-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,sans-serif",
                "edited": true,
                "reset": false
            },
            "darkTheme": {
                "default": "#097479",
                "baseColor": "#097479",
                "baseFont": "-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,sans-serif",
                "edited": false
            },
            "customTheme": {
                "name": "Untitled Theme 1",
                "default": "#4B7930",
                "baseColor": "#4B7930",
                "baseFont": "-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,sans-serif"
            },
            "themeState": {
                "base-color": {
                    "default": "#0094CE",
                    "value": "#0094CE",
                    "edited": false
                },
                "page-titlebar-backgroundColor": {
                    "value": "#0094CE",
                    "edited": false
                },
                "page-backgroundColor": {
                    "value": "#fafafa",
                    "edited": false
                },
                "page-sidebar-backgroundColor": {
                    "value": "#ffffff",
                    "edited": false
                },
                "group-textColor": {
                    "value": "#1bbfff",
                    "edited": false
                },
                "group-borderColor": {
                    "value": "#ffffff",
                    "edited": false
                },
                "group-backgroundColor": {
                    "value": "#ffffff",
                    "edited": false
                },
                "widget-textColor": {
                    "value": "#111111",
                    "edited": false
                },
                "widget-backgroundColor": {
                    "value": "#0094ce",
                    "edited": false
                },
                "widget-borderColor": {
                    "value": "#ffffff",
                    "edited": false
                },
                "base-font": {
                    "value": "-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,sans-serif"
                }
            },
            "angularTheme": {
                "primary": "indigo",
                "accents": "blue",
                "warn": "red",
                "background": "grey",
                "palette": "light"
            }
        },
        "site": {
            "name": "Node-RED Dashboard",
            "hideToolbar": "false",
            "allowSwipe": "false",
            "lockMenu": "false",
            "allowTempTheme": "true",
            "dateFormat": "DD/MM/YYYY",
            "sizes": {
                "sx": 48,
                "sy": 48,
                "gx": 6,
                "gy": 6,
                "cx": 6,
                "cy": 6,
                "px": 0,
                "py": 0
            }
        }
    },
    {
        "id": "5898ce021b9512c6",
        "type": "ui_group",
        "name": "Default",
        "tab": "36adcc21cef5324f",
        "order": 1,
        "disp": true,
        "width": "29",
        "collapse": false,
        "className": ""
    },
    {
        "id": "9cd4a3cdd1baab8c",
        "type": "sqlitedb",
        "db": "/home/leslie/SQlite Databases/Rhododendron",
        "mode": "RWC"
    },
    {
        "id": "3f964824e41821b8",
        "type": "modbus-read",
        "z": "8eba06c2d561584a",
        "name": "",
        "topic": "",
        "showStatusActivities": true,
        "logIOActivities": false,
        "showErrors": true,
        "unitid": "",
        "dataType": "HoldingRegister",
        "adr": "0",
        "quantity": "10",
        "rate": "2",
        "rateUnit": "s",
        "delayOnStart": false,
        "startDelayTime": "",
        "server": "a39cafbda5d1a286",
        "useIOFile": false,
        "ioFile": "",
        "useIOForPayload": false,
        "emptyMsgOnFail": false,
        "x": 150,
        "y": 200,
        "wires": [
            [],
            [
                "dcf04a493af33c1b"
            ]
        ]
    },
    {
        "id": "dcf04a493af33c1b",
        "type": "function",
        "z": "8eba06c2d561584a",
        "name": "get the data we want",
        "func": "\n//pull the variables we want out of the array\n//divide by 10 to get the resolution right\n\nvar p1Amps = msg.payload.data [0]/10;\nvar p2Amps = msg.payload.data [2]/10;\nvar p1Hours = msg.payload.data [4]/10;\nvar p2Hours = msg.payload.data [6]/10;\nvar waterlevel = msg.payload.data [8]/10;\n\n// separate them and add a topic to send to the local dashboard.\n\nvar p1A = { payload: p1Amps, topic: \"Pump 1 Amps\" };\nvar p2A = { payload: p2Amps, topic: \"Pump 2 Amps\" };\nvar p1H = { payload: p1Hours, topic: \"Pump 1 Hours\" };\nvar p2H = { payload: p2Hours, topic: \"Pump 2 Hours\" };\nvar watlev = { payload: waterlevel, topic: \"Water Level\" };\n\n\n\n//collect the data and format it in one payload to send to sqlite\nvar sqlite= {}\nsqlite.payload = { \"Pump 1 Amps\": p1Amps, \"Pump 2 Amps\": p2Amps, \"Pump 1 Hours\": p1Hours, \"Pump 2 Hours\": p2Hours, \"Water Level\": waterlevel};\n\n//return the variables on individual node outputs\nreturn [p1A, p2A, p1H, p2H, watlev, sqlite];\n\n",
        "outputs": 6,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 400,
        "y": 200,
        "wires": [
            [
                "a7d9d7b6f2d5d187",
                "9d01d7bd2e0e2adc"
            ],
            [
                "7aa4f90ceea3e66f",
                "9d01d7bd2e0e2adc"
            ],
            [
                "1f6d7455338598e2"
            ],
            [
                "6010df42fb592dc9"
            ],
            [
                "2d8bb3a2398c9bce",
                "9d01d7bd2e0e2adc"
            ],
            [
                "870f74b5fed802d7",
                "cd718b1ffe8dd8f0"
            ]
        ]
    },
    {
        "id": "a7d9d7b6f2d5d187",
        "type": "debug",
        "z": "8eba06c2d561584a",
        "name": "P1 amps",
        "active": false,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "true",
        "targetType": "full",
        "statusVal": "",
        "statusType": "auto",
        "x": 880,
        "y": 180,
        "wires": []
    },
    {
        "id": "7aa4f90ceea3e66f",
        "type": "debug",
        "z": "8eba06c2d561584a",
        "name": "P2 amps",
        "active": false,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "true",
        "targetType": "full",
        "statusVal": "",
        "statusType": "auto",
        "x": 880,
        "y": 220,
        "wires": []
    },
    {
        "id": "1f6d7455338598e2",
        "type": "debug",
        "z": "8eba06c2d561584a",
        "name": "P1 hours",
        "active": false,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "true",
        "targetType": "full",
        "statusVal": "",
        "statusType": "auto",
        "x": 880,
        "y": 260,
        "wires": []
    },
    {
        "id": "6010df42fb592dc9",
        "type": "debug",
        "z": "8eba06c2d561584a",
        "name": "P2 hours",
        "active": false,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "true",
        "targetType": "full",
        "statusVal": "",
        "statusType": "auto",
        "x": 880,
        "y": 300,
        "wires": []
    },
    {
        "id": "2d8bb3a2398c9bce",
        "type": "debug",
        "z": "8eba06c2d561584a",
        "name": "level",
        "active": false,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "true",
        "targetType": "full",
        "statusVal": "",
        "statusType": "auto",
        "x": 870,
        "y": 340,
        "wires": []
    },
    {
        "id": "9d01d7bd2e0e2adc",
        "type": "ui_chart",
        "z": "8eba06c2d561584a",
        "name": "",
        "group": "5898ce021b9512c6",
        "order": 0,
        "width": 0,
        "height": 0,
        "label": "local chart",
        "chartType": "line",
        "legend": "false",
        "xformat": "HH:mm:ss",
        "interpolate": "linear",
        "nodata": "",
        "dot": false,
        "ymin": "",
        "ymax": "",
        "removeOlder": "5",
        "removeOlderPoints": "2500",
        "removeOlderUnit": "3600",
        "cutout": 0,
        "useOneColor": false,
        "useUTC": false,
        "colors": [
            "#1f77b4",
            "#aec7e8",
            "#ff7f0e",
            "#2ca02c",
            "#98df8a",
            "#d62728",
            "#ff9896",
            "#9467bd",
            "#c5b0d5"
        ],
        "outputs": 1,
        "useDifferentColor": false,
        "className": "",
        "x": 890,
        "y": 440,
        "wires": [
            []
        ]
    },
    {
        "id": "870f74b5fed802d7",
        "type": "debug",
        "z": "8eba06c2d561584a",
        "name": "SQlite",
        "active": false,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "true",
        "targetType": "full",
        "statusVal": "",
        "statusType": "auto",
        "x": 870,
        "y": 400,
        "wires": []
    },
    {
        "id": "6d26aef86a598ff8",
        "type": "inject",
        "z": "8eba06c2d561584a",
        "name": "reset local dashboard graph",
        "props": [
            {
                "p": "payload"
            },
            {
                "p": "topic",
                "vt": "str"
            }
        ],
        "repeat": "",
        "crontab": "",
        "once": false,
        "onceDelay": 0.1,
        "topic": "",
        "payload": "[ ]",
        "payloadType": "json",
        "x": 180,
        "y": 420,
        "wires": [
            [
                "9d01d7bd2e0e2adc"
            ]
        ]
    },
    {
        "id": "09a078dc88def992",
        "type": "sqlite",
        "z": "8eba06c2d561584a",
        "mydb": "9cd4a3cdd1baab8c",
        "sqlquery": "msg.topic",
        "sql": "INSERT INTO rhod_testing (LEVEL, PUMPONEAMPS)\nVALUES (msg.payload.P1amps,msg.payload.P2amps);\n",
        "name": "Rhododendron SQlite",
        "x": 740,
        "y": 720,
        "wires": [
            []
        ]
    },
    {
        "id": "935d4e40d3897d6d",
        "type": "debug",
        "z": "8eba06c2d561584a",
        "name": "to SQlite",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "topic",
        "targetType": "msg",
        "statusVal": "",
        "statusType": "auto",
        "x": 720,
        "y": 780,
        "wires": []
    },
    {
        "id": "cd718b1ffe8dd8f0",
        "type": "function",
        "z": "8eba06c2d561584a",
        "name": "Rhododendron SQlite",
        "func": "//compile msg to send to sqlite. add time in the first column. SqLite interprets \"current_timestamp and returns the correct time in the DB\"\n\nvar dbMsg = {\n \"topic\": \"INSERT INTO Rhododendron VALUES ( CURRENT_TIMESTAMP, \" + msg.payload[\"Pump 1 Amps\"] + \", \" + msg.payload[\"Pump 2 Amps\"] + \",  \" + msg.payload[\"Pump 1 Hours\"] + \",  \" + msg.payload[\"Pump 2 Hours\"] + \",  \" + msg.payload[\"Water Level\"] + \")\"\n}\nreturn dbMsg;\n",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 460,
        "y": 740,
        "wires": [
            [
                "935d4e40d3897d6d",
                "09a078dc88def992"
            ]
        ]
    },
    {
        "id": "a47db449e7205e14",
        "type": "comment",
        "z": "8eba06c2d561584a",
        "name": "disect the array coming via modbus",
        "info": "",
        "x": 420,
        "y": 120,
        "wires": []
    },
    {
        "id": "7c2956420f6f0c12",
        "type": "comment",
        "z": "8eba06c2d561584a",
        "name": "load information into msg.topic to send to Sqlite",
        "info": "",
        "x": 420,
        "y": 660,
        "wires": []
    }
]

I'm not sure why there is a difference since I can only see one flow but its seems like the all flows has more information.

I have searched and can't find anything about "ubidot" in either of these files.

Sorry, my node red server is running in a proxmox VM at the moment, and I can't copy/paste from that terminal. I should have ssh'ed for you.

14

Try clearing the cache in your browser (using the menus) then refresh the node-red page and try again. Alternatively try a different browser or connect from a different computer.

15

that did it!
Thanks.

16

(You may want to mark the post that showed you the solution as the solution.
That way others can use it for help if they are stuck with a similar problem.)
:wink:

1 Like
17

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.