search

stas-demydiuk / domoticz-zigbee2mqtt-plugin

zigbee2mqtt plugin for domoticz
MIT License
136 stars 98 forks source link

SQL give errors with this plugin #706

Closed arjanvanleent closed 3 years ago

arjanvanleent commented 3 years ago

With the last update I get SQL errors. When I downgrade the plugin the errors are gone.

See also : https://www.domoticz.com/forum/viewtopic.php?f=6&t=36971

Don't know which version is working correct but the 1 I restored was pulled at 31-07-2021

Put general information here

Additional information Zigbee2MQTT version: plugin: v.3.1.0-beta, zigbee2mqtt: v.1.21.1 (zStack3x0 20200830) Version: 2021.1 (build 13495) Build Hash: 811e1cfa4 Compile Date: 2021-09-09 08:49:21 dzVents Version: 3.1.8 Python Version: 3.7.3 (default, Jul 25 2020, 13:03:44) [GCC 8.3.0]

Logs Attach any additional logs here which might be useful: mqtt, domoticz, plugin logs

`2021-09-12 11:36:03.915 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available 2021-09-12 12:35:56.557 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='Location')") : no more rows available 2021-09-12 13:05:00.453 Error: SQL Query("INSERT INTO MultiMeter (DeviceRowID, Value1, Value2, Value3, Value4, Value5, Value6) VALUES ('530', '9472167', '0', '798', '0', '0', '0')") : no more rows available 2021-09-12 13:05:01.474 Error: Zigbee: Update to 'UnitEx' failed to update any DeviceStatus records for key 28/0x00158d000408d44b_signal/62 2021-09-12 15:31:17.625 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='DzVentsLogLevel')") : no more rows available 2021-09-12 16:01:07.058 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='WebLocalNetworks')") : no more rows available 2021-09-12 16:03:33.542 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='DzVentsLogLevel')") : no more rows available

2021-09-12 19:38:06.145 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SecStatus')") : no more rows available`

stas-demydiuk commented 3 years ago

Looks like an issue with Domoticz.Configuration feature provided by Domoticz's plugins framework. Since it is smth that is used by the plugin in all cases and you are the first who has this issue, I would assume that smth is broken in your Domoticz setup. Could you please try to do a clean Domoticz setup and check if you will still have the issue.

arjanvanleent commented 3 years ago

SQL error are gone with a clean new install and restore backup on a different system. Still need to test it on my production Domoticz.

But now DZvents give alot of errors on my new system. 2021-09-15 12:40:53.507 Error: EventSystem: in /home/arjan/domoticz/dzVents/runtime/dzVents.lua: ...oticz/dzVents/runtime/device-adapters/generic_device.lua:67: attempt to index a nil value (field '_') 2021-09-15 12:40:53.529 Error: EventSystem: in /home/arjan/domoticz/dzVents/runtime/dzVents.lua: ...oticz/dzVents/runtime/device-adapters/generic_device.lua:67: attempt to index a nil value (field '_')

At the same time in DZvents Device current state `1445 2021-09-15 12:40:53 Zigbee - Hal Temperatuur (Link Quality) 147 147/147
1448 2021-09-15 12:40:53 Zigbee - Hal Temperatuur (Temperature) 21.5 0/21.5
1449 2021-09-15 12:40:53 Zigbee - Hal Temperatuur (Humidity) 66 66/0
1450 2021-09-15 12:40:53 Hal Temperatuur 21.5;66.1;0 0/21.5;66.1;0

` This happen when Zigbee updates a sensor or switch but not always

Also the dimmer switch doesn't show the current state. When I change the dimmer the lamp is changed but the widget in domoticz goes back to the old postition.

BTW what does "smth" mean

stas-demydiuk commented 3 years ago

smth stands for something

stas-demydiuk commented 3 years ago

Closing the issue for now, feel free to reopen it in case you find something related to plugin

odelma commented 2 years ago

Hi, there is at least some indication that the "no more rows available" error has some relation to this plugin: https://github.com/domoticz/domoticz/issues/4938#issuecomment-940428277

Creo2005 commented 2 years ago 
2022-01-23 17:32:59.581 Error: SQL Query("SELECT HardwareID, DeviceID, Unit, Name, [Type], SubType, nValue, sValue, SwitchType, SignalLevel, BatteryLevel, Options, Description, LastLevel, Color, LastUpdate FROM DeviceStatus WHERE (HardwareID==16) AND (ID==173)") : no more rows available
2022-01-23 17:48:25.520 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2022-01-23 18:13:45.407 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2022-01-23 19:39:44.622 Error: SQL Query("SELECT Value FROM Meter WHERE (DeviceRowID='165' AND Date>='2022-01-23') ORDER BY Date LIMIT 1") : no more rows available
mcmellow commented 2 years ago

plugin: v.3.1.0-beta, zigbee2mqtt: v.1.24.0-dev (zStack3x0 20211217) Receiving also the following errors

2022-03-14 14:54:57.146 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SecStatus')") : no more rows available 2022-03-14 15:47:37.831 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available 2022-03-15 11:15:44.545 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available 2022-03-15 11:31:12.637 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available 2022-03-15 23:22:14.998 Error: SQL Query("UPDATE DeviceStatus SET SignalLevel=12, BatteryLevel=255, nValue=0, sValue='0.0', LastUpdate='2022-03-15 23:22:14' WHERE (ID = 46)") : no more rows available 2022-03-16 09:05:01.154 Error: SQL Query("INSERT INTO Percentage (DeviceRowID, Percentage) VALUES ('202', '0')") : no more rows available 2022-03-16 15:38:30.587 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available 2022-03-16 16:17:52.191 Error: SQL Query("SELECT MIN(Value1), MIN(Value2), MIN(Value5), MIN(Value6) FROM MultiMeter WHERE (DeviceRowID='37' AND Date>='2022-03-16')") : no more rows available What to do to avoid theses errors

sammyke007 commented 2 years ago

Were you ever able to fix this? I also get image since updating to the latest v3.1 today.

Misiek1105 commented 2 years ago

Hello After upgrade I have the same problem with SQL. Maybe somebody solved this problem ?

odelma commented 1 year ago

Cannot think of any other reason than something happening when a status message is received via mqtt, somehow the sql statement (maybe related to domoticz.config) is obscured to something that does not reflect anything meaningful and thus it does not return any rows.

Can you @stas-demydiuk still look into this? It can be something in Domoticz (python extended plugin framework?) but on the other hand this is not reported by any other plugin so it seems to be something specific to this one. I installed couple of climate devices (Moes BHT-002) and they report status (a bit too) often which seems to be resulting into much more of these messages than I used to see. From this morning:

2023-01-02 09:00:17.084 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 09:01:58.736 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerEnergy')") : no more rows available
2023-01-02 09:05:28.099 Error: SQL Query("SELECT sValue FROM DeviceStatus WHERE (ID=535)") : no more rows available
2023-01-02 09:06:55.857 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 09:06:58.911 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerEnergy')") : no more rows available
2023-01-02 09:08:59.140 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerEnergy')") : no more rows available
2023-01-02 09:12:54.707 Error: SQL Query("SELECT COUNT(*) FROM Timers WHERE (DeviceRowID==1924) AND (TimerPlan==0)") : no more rows available
2023-01-02 09:12:59.637 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 09:13:24.875 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 09:16:47.600 Error: SQL Query("SELECT Total, Total FROM Rain WHERE (DeviceRowID=792 AND Date>='2023-01-02') ORDER BY ROWID DESC LIMIT 1") : no more rows available
2023-01-02 09:21:45.958 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerEnergy')") : no more rows available
2023-01-02 09:28:53.001 Error: SQL Query("SELECT Name,nValue,sValue FROM DeviceStatus WHERE (HardwareID==43) AND (DeviceID=='zigbee2mqtt_0x00158d0004aade95') AND (Unit == 1) AND (Type==84) AND (Subtype==16)") : no more rows available
2023-01-02 09:33:01.696 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 09:34:01.880 Error: SQL Query("SELECT Value FROM Meter WHERE (DeviceRowID='1758' AND Date>='2023-01-02') ORDER BY Date LIMIT 1") : no more rows available
2023-01-02 09:35:19.511 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 09:37:22.150 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 09:40:21.832 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 09:40:48.143 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 09:42:01.977 Error: SQL Query("SELECT Value FROM Meter WHERE (DeviceRowID='1746' AND Date>='2023-01-02') ORDER BY Date LIMIT 1") : no more rows available
2023-01-02 09:43:02.902 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerEnergy')") : no more rows available
2023-01-02 09:46:03.172 Error: SQL Query("SELECT Value FROM Meter WHERE (DeviceRowID='1758' AND Date>='2023-01-02') ORDER BY Date LIMIT 1") : no more rows available
2023-01-02 09:46:30.308 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 09:47:20.255 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 09:48:03.675 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerEnergy')") : no more rows available
2023-01-02 09:48:20.041 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 09:50:07.115 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 09:53:19.464 Error: SQL Query("SELECT AddjValue,AddjMulti FROM DeviceStatus WHERE (HardwareID=43 AND DeviceID='0x84ba20fffe8a0e68_climate_zigbee2mqtt' AND Unit=1 AND Type=80 AND SubType=1)") : no more rows available
2023-01-02 09:56:53.713 Error: SQL Query("SELECT MIN(Value), MAX(Value) FROM Meter WHERE (DeviceRowID=665 AND Date>='2023-01-02')") : no more rows available
2023-01-02 09:58:04.420 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 10:02:32.563 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 10:02:47.890 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 10:04:47.479 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 10:08:05.786 Error: SQL Query("SELECT ID, Activators, SceneType FROM Scenes WHERE (Activators!='')") : no more rows available
2023-01-02 10:14:06.025 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 10:16:43.044 Error: SQL Query("SELECT Total, Total FROM Rain WHERE (DeviceRowID=792 AND Date>='2023-01-02') ORDER BY ROWID DESC LIMIT 1") : no more rows available
2023-01-02 10:22:48.067 Error: SQL Query("SELECT AddjValue,AddjMulti FROM DeviceStatus WHERE (HardwareID=43 AND DeviceID='0x84ba20fffe8a0e68_climate_zigbee2mqtt' AND Unit=1 AND Type=80 AND SubType=1)") : no more rows available
2023-01-02 10:23:23.733 Error: SQL Query("SELECT Name,nValue,sValue FROM DeviceStatus WHERE (HardwareID==43) AND (DeviceID=='0x50325ffffe401d5d_climate_zigbee2mqtt') AND (Unit == 1) AND (Type==242) AND (Subtype==1)") : no more rows available
2023-01-02 10:26:21.816 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 10:27:32.132 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 10:28:02.058 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 10:32:47.244 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerWater')") : no more rows available
2023-01-02 10:35:19.445 Error: SQL Query("SELECT MIN(Value), MAX(Value) FROM Meter WHERE (DeviceRowID=833 AND Date>='2023-01-02')") : no more rows available
2023-01-02 10:45:19.688 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 10:48:44.568 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 10:55:19.584 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 11:00:16.909 Error: SQL Query("SELECT AddjValue,AddjMulti FROM DeviceStatus WHERE (HardwareID=43 AND DeviceID='0x50325ffffe401d5d_climate_zigbee2mqtt' AND Unit=1 AND Type=80 AND SubType=1)") : no more rows available
2023-01-02 11:01:27.710 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 11:04:48.925 Error: SQL Query("SELECT ID, Activators, SceneType FROM Scenes WHERE (Activators!='')") : no more rows available
2023-01-02 11:08:41.495 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerWater')") : no more rows available
2023-01-02 11:10:33.292 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 11:10:40.680 Error: SQL Query("SELECT Total, Total FROM Rain WHERE (DeviceRowID=792 AND Date>='2023-01-02') ORDER BY ROWID DESC LIMIT 1") : no more rows available
2023-01-02 11:14:01.421 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerEnergy')") : no more rows available
2023-01-02 11:15:25.129 Error: SQL Query("SELECT Name,nValue,sValue FROM DeviceStatus WHERE (HardwareID==43) AND (DeviceID=='0x50325ffffe401d5d_climate_zigbee2mqtt') AND (Unit == 1) AND (Type==242) AND (Subtype==1)") : no more rows available
2023-01-02 11:17:58.930 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 11:34:55.892 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 11:35:38.144 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerEnergy')") : no more rows available
2023-01-02 11:39:19.508 Error: SQL Query("SELECT Total, Total FROM Rain WHERE (DeviceRowID=792 AND Date>='2023-01-02') ORDER BY ROWID DESC LIMIT 1") : no more rows available
2023-01-02 11:41:06.261 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SecStatus')") : no more rows available
2023-01-02 11:56:58.875 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 12:00:24.011 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 12:02:33.234 Error: SQL Query("SELECT AddjValue,AddjMulti FROM DeviceStatus WHERE (HardwareID=43 AND DeviceID='0x50325ffffe401d5d_climate_zigbee2mqtt' AND Unit=1 AND Type=80 AND SubType=1)") : no more rows available
2023-01-02 12:04:18.955 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerEnergy')") : no more rows available
2023-01-02 12:05:19.416 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 12:06:19.234 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerEnergy')") : no more rows available
2023-01-02 12:08:40.233 Error: SQL Query("SELECT MIN(Value), MAX(Value) FROM Meter WHERE (DeviceRowID=833 AND Date>='2023-01-02')") : no more rows available
2023-01-02 12:11:19.704 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 12:15:20.176 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 12:16:22.975 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 12:17:20.755 Error: SQL Query("SELECT Value FROM Meter WHERE (DeviceRowID='1738' AND Date>='2023-01-02') ORDER BY Date LIMIT 1") : no more rows available
2023-01-02 12:18:53.221 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 12:19:20.802 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 12:23:21.153 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerEnergy')") : no more rows available
2023-01-02 12:23:25.666 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 12:28:26.254 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 12:29:37.827 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerEnergy')") : no more rows available
2023-01-02 12:32:21.769 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 12:35:22.139 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 12:36:30.328 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 12:45:23.701 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 12:48:54.783 Error: SQL Query("SELECT Total, Total FROM Rain WHERE (DeviceRowID=792 AND Date>='2023-01-02') ORDER BY ROWID DESC LIMIT 1") : no more rows available
2023-01-02 12:50:23.900 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerEnergy')") : no more rows available
2023-01-02 12:52:30.421 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 13:09:05.233 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 13:10:26.234 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 13:12:47.447 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 13:20:27.881 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 13:33:54.726 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 13:36:29.734 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerEnergy')") : no more rows available
2023-01-02 13:44:05.721 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 13:45:33.552 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 13:48:12.666 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 13:50:32.383 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 13:52:31.344 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 13:56:40.320 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 14:06:28.001 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 14:08:09.267 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 14:10:12.120 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerEnergy')") : no more rows available
2023-01-02 14:16:00.706 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 14:24:34.588 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 14:29:35.126 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerEnergy')") : no more rows available
2023-01-02 14:29:58.311 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 14:34:37.225 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 14:34:37.244 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 14:36:36.051 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerEnergy')") : no more rows available
2023-01-02 14:39:36.372 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerEnergy')") : no more rows available
2023-01-02 14:40:35.798 Error: SQL Query("SELECT Name,nValue,sValue FROM DeviceStatus WHERE (HardwareID==43) AND (DeviceID=='0x00158d0004aade95_voltage_zigbee2mqtt') AND (Unit == 1) AND (Type==243) AND (Subtype==8)") : no more rows available
2023-01-02 14:46:48.118 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 14:50:37.797 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 14:52:47.930 Error: SQL Query("SELECT AddjValue,AddjMulti FROM DeviceStatus WHERE (HardwareID=43 AND DeviceID='0x84ba20fffe8a0e68_climate_zigbee2mqtt' AND Unit=1 AND Type=80 AND SubType=1)") : no more rows available
2023-01-02 14:54:48.542 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SecStatus')") : no more rows available
2023-01-02 14:56:38.545 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerEnergy')") : no more rows available
2023-01-02 15:00:05.996 Error: SQL Query("SELECT ID, Name FROM DeviceStatus WHERE (HardwareID=25 AND DeviceID='00082338' AND Unit=1 AND Type=243 AND SubType=31)") : no more rows available
2023-01-02 15:01:18.060 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SecStatus')") : no more rows available
2023-01-02 15:04:00.200 Error: SQL Query("SELECT MIN(Value), MAX(Value) FROM Meter WHERE (DeviceRowID=833 AND Date>='2023-01-02')") : no more rows available
2023-01-02 15:04:48.507 Error: SQL Query("SELECT Total, Total FROM Rain WHERE (DeviceRowID=792 AND Date>='2023-01-02') ORDER BY ROWID DESC LIMIT 1") : no more rows available
2023-01-02 15:15:17.999 Error: SQL Query("SELECT AddjValue,AddjMulti FROM DeviceStatus WHERE (HardwareID=43 AND DeviceID='0x84ba20fffe8a0e68_climate_zigbee2mqtt' AND Unit=1 AND Type=80 AND SubType=1)") : no more rows available
2023-01-02 15:16:40.998 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerEnergy')") : no more rows available
2023-01-02 15:27:48.552 Error: SQL Query("SELECT a.DeviceRowID, b.Type, b.HardwareID FROM LightSubDevices a, DeviceStatus b WHERE (a.ParentID=='1923') AND (b.ID == a.DeviceRowID) AND (a.DeviceRowID!=a.ParentID)") : no more rows available
2023-01-02 15:29:48.646 Error: SQL Query("SELECT Total, Total FROM Rain WHERE (DeviceRowID=792 AND Date>='2023-01-02') ORDER BY ROWID DESC LIMIT 1") : no more rows available
2023-01-02 15:31:59.730 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2023-01-02 15:32:19.039 Error: SQL Query("UPDATE DeviceStatus SET SignalLevel=12, BatteryLevel=255, nValue=0, sValue='0.0;17966800.0', LastUpdate='2023-01-02 15:32:19' WHERE (ID = 672)") : no more rows available
2023-01-02 15:40:46.028 Error: SQL Query("SELECT MIN(Total), MAX(Total) FROM Rain WHERE (DeviceRowID=1130 AND Date>='2023-01-02')") : no more rows available
2023-01-02 15:41:43.539 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
2023-01-02 15:43:18.200 Error: SQL Query("SELECT Value FROM Meter WHERE (DeviceRowID='1758' AND Date>='2023-01-02') ORDER BY Date LIMIT 1") : no more rows available

Usually there has been a few of these in this time frame.

Anjerlaan commented 1 year ago

I have the same issue…after a fresh install of domoticz and Domoticz-zigbee2mqtt plug-in (with plug-ins manager)