Page 2 of 2
Re: Devices dissappeared from Switches, Groups, Temperature, Weather and Other tabs after update
Posted: Sunday 05 March 2023 18:53
by 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 714 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 714 times
The AF device is not visible
It seems there was a change between both versions...
Re: Devices dissappeared from Switches, Groups, Temperature, Weather and Other tabs after update
Posted: Sunday 05 March 2023 19:36
by 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?
Re: Devices dissappeared from Switches, Groups, Temperature, Weather and Other tabs after update
Posted: Sunday 05 March 2023 20:04
by 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)
Re: Devices dissappeared from Switches, Groups, Temperature, Weather and Other tabs after update
Posted: Saturday 11 March 2023 20:03
by 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
Re: Devices dissappeared from Switches, Groups, Temperature, Weather and Other tabs after update
Posted: Sunday 12 March 2023 11:40
by reinestein
I'm already running Domoticz beta
.
Re: Devices dissappeared from Switches, Groups, Temperature, Weather and Other tabs after update
Posted: Sunday 19 March 2023 11:37
by hestia
Sunhw wrote: ↑Saturday 11 March 2023 20:03
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!
Re: Devices dissappeared from Switches, Groups, Temperature, Weather and Other tabs after update
Posted: Sunday 19 March 2023 15:42
by 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
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!
Re: Devices dissappeared from Switches, Groups, Temperature, Weather and Other tabs after update
Posted: Sunday 19 March 2023 16:23
by 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"
Re: Devices dissappeared from Switches, Groups, Temperature, Weather and Other tabs after update
Posted: Sunday 19 March 2023 17:23
by 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