Hardware setup, node management, no records shown

On various Hardware and OS systems: pi / windows / routers / nas, etc

Moderator: leecollings

Post Reply
donverweij
Posts: 8
Joined: Tuesday 06 February 2024 18:00
Target OS: NAS (Synology & others)
Domoticz version: 2024.4
Contact:

Hardware setup, node management, no records shown

Post by donverweij »

Hi, I installed Docker image 2024.4 on a Synology DS920+ using Synology Container Manager (DSM7.2).
Following all the steps in the manuals (thanks for all the detailed instructions) I got Domotizc running :) .
My Aeotic Z-Stick Gen5 (OpenZWAVE USB) was recognized in Hardware. I then went to Setup to include my first Z-Wave node.
This also worked. I got my Fibaro Plug added. But there was no record of the plug (data) shown in this screen :?: .
I thought the adding process had not finished correctly so tried inluding the same plug again.
I got my Fibaro Plug inluded again. But there was still no record of the plug (data) shown in this screen.
But checking Devices the added Plug was shown (6 ID's/ functions records) and the plug worked. Although there was still no node record of the plug.

In the log I found: errors about - no such table
2024-02-09 11:04:00.263 Error: SQL Query("SELECT ID FROM ZWaveNodes WHERE (HardwareID==2) AND (HomeID==3425308926) AND (NodeID==1)") : no such table: ZWaveNodes
2024-02-09 11:04:00.263 Error: SQL Query("INSERT INTO ZWaveNodes (HardwareID, HomeID, NodeID, Name,ProductDescription) VALUES (2,3425308926,1,'Controller','AEON Labs ZW090 Z-Stick Gen5 EU')") : no such table: ZWaveNodes
2024-02-09 11:04:00.265 Error: SQL Query("SELECT ID FROM ZWaveNodes WHERE (HardwareID==2) AND (HomeID==3425308926) AND (NodeID==3)") : no such table: ZWaveNodes
2024-02-09 11:04:00.265 Error: SQL Query("INSERT INTO ZWaveNodes (HardwareID, HomeID, NodeID, ProductDescription) VALUES (2,3425308926,3,'FIBARO System FGWPE/F Wall Plug Gen5')") : no such table: ZWaveNodes
2024-02-09 11:04:00.309 Error: SQL Query("SELECT PollTime FROM ZWaveNodes WHERE (HardwareID==2) AND (HomeID==3425308926) AND (NodeID==1)") : no such table: ZWaveNodes

Did the inlude node process failed? Or did I miss a step in the installation on the database part? Any suggestion is appreciated.
Docker image 2024-4 on a Synology DS920+ using Synology Container Manager (DSM7-2).
Docker image 2024.7 on a Raspberry pi 4B
User avatar
waltervl
Posts: 5148
Joined: Monday 28 January 2019 18:48
Target OS: Linux
Domoticz version: 2024.7
Location: NL
Contact:

Re: Hardware setup, node management, no records shown

Post by waltervl »

I hope you are using Zwave-JS-UI as the openzwave integration you are trying to use is Deprecated and will be removed soon. see https://www.domoticz.com/wiki/Zwave

As you are a new Domoticz user please remove the Openzwave USB hardware Gateway in Domoticz and start with Zwave-JS-UI (and MQTT)
https://www.domoticz.com/wiki/Zwave-JS-UI
Domoticz running on Udoo X86 (on Ubuntu)
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
donverweij
Posts: 8
Joined: Tuesday 06 February 2024 18:00
Target OS: NAS (Synology & others)
Domoticz version: 2024.4
Contact:

Re: Hardware setup, node management, no records shown

Post by donverweij »

waltervl wrote: Friday 09 February 2024 13:08 I hope you are using Zwave-JS-UI as the openzwave integration you are trying to use is Deprecated and will be removed soon. see https://www.domoticz.com/wiki/Zwave

As you are a new Domoticz user please remove the Openzwave USB hardware Gateway in Domoticz and start with Zwave-JS-UI (and MQTT)
https://www.domoticz.com/wiki/Zwave-JS-UI
Thanks Walter, I'll remove Openzwave integration and will install Zwave-JS-UI.
Docker image 2024-4 on a Synology DS920+ using Synology Container Manager (DSM7-2).
Docker image 2024.7 on a Raspberry pi 4B
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest