Comparing gas categories looks strange

Moderator: leecollings

Post Reply
dietje
Posts: 2
Joined: Wednesday 11 January 2023 10:30
Target OS: Raspberry Pi / ODroid
Domoticz version:
Contact:

Comparing gas categories looks strange

Post by dietje »

Hi All,

First post here and I'm using Domoticz on my pi2 for over a year with loads of joy and most of the time without any issues.
However, since a couple of days, my Gas meter is acting strange. It will take over 20 seconds to show the graphics and if I want to compare the values with last year, it seems like all years are shown from 2023 till 470 bc. If I export the graphic to excel, I see the
the row Categories from -470 up to 2023 :?
all other graphics seems to be normal, except the loading of the page need more time.
ie. Electric meter is fine with all graphics, so it really is this one particular idx.

I have found a similar issue on Git (issue 4856) but that was after a new build.

Since that moment I also see other things in the log which I have never seen before but I doubt whether that has something to do with the issue above:
Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : no more rows available
Error: SQL Query("SELECT ID, Name FROM Cameras where enabled = '1' ORDER BY ID ASC") : no more rows available

I would love to share a picture but it seems like I'm not able to use links outside this domain
Any idea is more than welcome
dietje
Posts: 2
Joined: Wednesday 11 January 2023 10:30
Target OS: Raspberry Pi / ODroid
Domoticz version:
Contact:

Re: Comparing gas categories looks strange

Post by dietje »

Solved!
While searching in the database for deviating values in table Meter_Calendar, I saw a date value with just a 'yyyy' in stead of 'yyyy-mm-dd'
After updating the record, it was all OK.

Of course the question came up like 'How???'
no clue so far! :?:

Post can be closed!
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest