Fix energy dashboard, gas sensor

[swa72]

see https://github.com/home-assistant/frontend/issues/17010

[swa72]

• Open PhPMyAdmin
• Use https://www.epochconverter.com/ to get correct time for the > -> XXX
• SELECT * FROMstatisticsWHEREmetadata_id="117" ANDstart_ts> XXX
• visually find the first row with 0 in sum and not that id 3117192
• Alternative: select t.*, t.sum - t.sum_previous as difference from (select s.*, lag(s.sum) over (partition by s.metadata_id order by s.start_ts) as sum_previous from statistics s) t where t.metadata_id = 117 and t.sum < t.sum_previous order by t.start_ts desc;
• Note the sum of the row before 0: 5816.840000004125
• Note the row id of the row with sum 0: 3117192

Then run

UPDATE statistics SET sum = sum + 5816.840000004125 WHERE metadata_id="117" AND id>=2992418

and afterwards fix the absolute last value in ID117 manually