Hello,
I use the mySQL Binding to store a value every day. This value is already in the database.
Database changed
MariaDB [openhab]> select * from Item1;
±--------------------±------+
| Time | Value |
±--------------------±------+
| 2019-09-06 12:35:00 | 193 |
| 2019-09-06 12:40:00 | 193 |
| 2019-09-06 12:42:00 | 193 |
| 2019-09-06 12:43:00 | 193 |
| 2019-09-06 12:44:00 | 193 |
| 2019-09-06 12:45:00 | 193 |
| 2019-09-07 00:00:00 | 193 |
±--------------------±------+
Then I try to show some of the entries with a chart in my sitemap the following errors are shown in my log.
2019-09-07 10:56:32.700 [WARN ] [thome.ui.internal.chart.ChartServlet] - Chart generation failed: null
2019-09-07 10:56:33.749 [WARN ] [thome.ui.internal.chart.ChartServlet] - Chart generation failed: null
2019-09-07 10:56:33.894 [WARN ] [thome.ui.internal.chart.ChartServlet] - Chart generation failed: null
==> /var/log/openhab2/events.log <==
2019-09-07 10:56:34.158 [ome.event.ItemCommandEvent] - Item ‘Wasserstand_Grafik’ received command 2
2019-09-07 10:56:34.185 [vent.ItemStateChangedEvent] - Wasserstand_Grafik changed from 1 to 2
==> /var/log/openhab2/openhab.log <==
2019-09-07 10:56:34.226 [WARN ] [thome.ui.internal.chart.ChartServlet] - Chart generation failed: null
2019-09-07 10:56:34.527 [WARN ] [thome.ui.internal.chart.ChartServlet] - Chart generation failed: null
2019-09-07 10:56:34.553 [WARN ] [thome.ui.internal.chart.ChartServlet] - Chart generation failed: null
2019-09-07 10:56:34.839 [WARN ] [thome.ui.internal.chart.ChartServlet] - Chart generation failed: null
==> /var/log/openhab2/events.log <==
2019-09-07 10:56:34.982 [ome.event.ItemCommandEvent] - Item ‘Wasserstand_Grafik’ received command 1
2019-09-07 10:56:35.003 [vent.ItemStateChangedEvent] - Wasserstand_Grafik changed from 2 to 1
==> /var/log/openhab2/openhab.log <==
2019-09-07 10:56:35.139 [WARN ] [thome.ui.internal.chart.ChartServlet] - Chart generation failed: null
2019-09-07 10:56:35.394 [WARN ] [thome.ui.internal.chart.ChartServlet] - Chart generation failed: null
This is my coding of my sitemap:
Frame label="Zisterne" {
Text item=ZTime label="Zeit" icon="clock"
Text item=Depth label="Abstand zum Wasser in cm" icon="flow"
Text item=Wasserstand label="Wasserstand in cm" icon="flow"
Switch item=Wasserstand_Grafik label="Zeitraum" icon="clock" mappings=[1="Tag", 2="Woche"]
Chart item=Wasserstand service="mysql" period=D refresh=300 visibility=[Wasserstand_Grafik==1, Wasserstand_Grafik=="Uninitialized"]
Chart item=Wasserstand service="mysql" period=W refresh=300 visibility=[Wasserstand_Grafik==2]
}
Any ideas why no value of mysql is shown?
Thanks