Devices dissappeared from Switches, Groups, Temperature, Weather and Other tabs after update

[hestia]

new test,
as it was working on my prod env with

Code: Select all

Version: 2022.2 (build 15022)
Build Hash: af4316cb7
Compile Date: 2023-02-03 16:33:14

Screenshot 2023-03-05 185237.png (52.15 KiB) Viewed 712 times

I've exported the DB and imported the DB to the test env with

Code: Select all

Version: 2023.1 (build 15098)
Build Hash: 867c4e8fa
Compile Date: 2023-02-24 07:56:50

And it didn't work

Screenshot 2023-03-05 183939.png (92.53 KiB) Viewed 712 times

The AF device is not visible

It seems there was a change between both versions...

[waltervl]

Do you see an Active user mentioned in menu Setup - About?
What are the user device settings in menu Setup - Users for the logged in user?

[hestia]

Active user mentioned in menu Setup - About

yes for the adm user, because no "About" for no adm user
I've put all the devices for both users with no change (for adm user I've never put any devices in the user definition and it was working well, now for the 2023-02-03 16:33:14 version, the adm user has no devices and it works)

[Sunhw]

Perhaps it helps:
I had the same problem, I just updated to domoticz beta ( pi@raspberrypi:~/domoticz $ ./updatebeta)
All my settings are onscreen again.

Have a nice weekend

[reinestein]

I'm already running Domoticz beta .

[hestia]

Perhaps it helps:
I had the same problem, I just updated to domoticz beta ( pi@raspberrypi:~/domoticz $ ./updatebeta)
All my settings are onscreen again.

Have a nice weekend

Hi,
could you be more specific about the version you are ok with?
On my side:
from

Code: Select all

Version: 2023.1 (build 15098)
Build Hash: 867c4e8fa
Compile Date: 2023-02-24 07:56:50
dzVents Version: 3.1.8
Python Version: 3.9.2 (default, Mar 12 2021, 04:06:34) [GCC 10.2.1 20210110]

to

Code: Select all

Version: 2023.1 (build 15163)
Build Hash: ec057e0bf
Compile Date: 2023-03-16 17:37:02
dzVents Version: 3.1.8
Python Version: 3.9.2 (default, Mar 12 2021, 04:06:34) [GCC 10.2.1 20210110]

same issue!

[hestia]

what I did
via ssh

Code: Select all

sqlite3 domoticz.db "select ID from DeviceStatus order by Name" > /tmp/DeviceID.txt

via windows
get the file to Excel (via ftp) like this in column F

deviceOrder.xlsx

(133.82 KiB) Downloaded 29 times

copy / paste column A to notepad
you get something like this

Code: Select all

sqlite3 domoticz.db "UPDATE DeviceStatus SET [Order]=1176 WHERE ID=1919"
sqlite3 domoticz.db "UPDATE DeviceStatus SET [Order]=1178 WHERE ID=1918"
sqlite3 domoticz.db "UPDATE DeviceStatus SET [Order]=1180 WHERE ID=1917"
sqlite3 domoticz.db "UPDATE DeviceStatus SET [Order]=1182 WHERE ID=2734"
sqlite3 domoticz.db "UPDATE DeviceStatus SET [Order]=1184 WHERE ID=2718"

via ssh
stop dz
bk the database in an other file
copy / paste the notepad to the command line to execute all the sql orders
restart dz
done!

[hestia]

But when I added 2 new devices they didn't show up
I had to change their order again with a lower one, as if there was a limit!!!

Code: Select all

sqlite3 domoticz.db "UPDATE DeviceStatus SET [Order]=17 WHERE ID=3042"
sqlite3 domoticz.db "UPDATE DeviceStatus SET [Order]=19 WHERE ID=3041"

[hestia]

and this did not solve the issue with the Plan filter.
I did the same thing with the DeviceToPlansMap table

Code: Select all

sqlite3 domoticz.db "UPDATE DeviceToPlansMap SET [Order]=538 WHERE ID=728"

with no success