Page 1 of 1

Hardware setup, node management, no records shown

Posted: Friday 09 February 2024 12:23
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.

Re: Hardware setup, node management, no records shown

Posted: Friday 09 February 2024 13:08
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

Re: Hardware setup, node management, no records shown

Posted: Friday 09 February 2024 14:00
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.