Errors: "no more rows available"

[Theo-NL]

Since the update of the plugin from 3.0.0 to 3.1.0.-beta I regularly get such errors in the Domoticz log (all ending in “no more rows available).

2022-02-17 13:51:23.866 Error: SQL Query("SELECT MIN(Value1), MIN(Value2), MIN(Value5), MIN(Value6) FROM MultiMeter WHERE (DeviceRowID='135' AND Date>='2022-02-17')") : no more rows available 2022-02-17 14:27:06.494 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available 2022-02-17 15:13:03.175 Error: SQL Query("SELECT ID, Name FROM Cameras where enabled = '1' ORDER BY ID ASC") : no more rows available 2022-02-17 15:21:45.995 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available 2022-02-17 15:55:45.041 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available

RaspberryPi 3b Domoticz Version: 2022.1 Python Version: 3.7.3 Plugin Version 3.1.0.-beta Zigbee2mqtt v.1.23.0 (zStack12 20190608) Zigbee CC2531 coordinator USB-dongle (soon the CC2652RB)

What could be the problem ?

Thanks in advance !

Regards, Theo (NL).

[jjnh]

Same issues here after updating Domoticz, Zigbee2Mqtt and the Zigbee2Mqtt Plugin to the most recent versions.

[odelma]

+1

[mcmellow]

Domoticz Build 14285, plugin: v.3.1.0-beta, zigbee2mqtt: v.1.24.0-dev (zStack3x0 20211217) Having the same error msg as Theo-NL

[odelma]

Also still seeing these errors in the Domoticz log:

[sammyke007]

+1

[2N3819]

Same issue for me.

plugin: v.3.1.0-beta, zigbee2mqtt: v.1.23.0 (zStack3x0

About Domoticz Version: 2022.1 Build Hash: c9526851b Compile Date: 2022-01-31 08:34:32 dzVents Version: 3.1.8 Python Version: 3.7.3 (default, Jan 22 2021, 20:04:44) [GCC 8.3.0]

[Xenomes]

Got the same kind of errors

2022-07-18 21:14:33.570 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2022-07-18 21:21:33.482 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available
2022-07-18 21:28:33.550 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : no more rows available

Domoticz Version: 2022.1 (build 14394) Build Hash: 678cd4b89 Compile Date: 2022-07-18 07:48:03 dzVents Version: 3.1.8 Python Version: 3.8.10 (default, Jun 22 2022, 20:18:18) [GCC 9.4.0] plugin version: Zigbee2MQTT Plugin (v. 3.1.0-beta)

[stas-demydiuk]

Closing in favor of #817 discussion