Another user reported a similar problem <https://groups.google.com/g/weewx-user/c/pbDm1jFNkwQ/m/EvqWMwaqAQAJ> last year. The point of commonality is MariaDB running on Windows.
This is not a configuration that I can recreate (nor is it supported). I suspect the problem has something to do with the case-insensitive nature of Windows, but I don't really know. Unless you have some compelling reason to use MariaDB (or MySQL), I would strongly suggest that you just use sqlite3. -tk On Sun, Aug 24, 2025 at 12:09 PM tommy Teague <[email protected]> wrote: > Howdy > > Newbie here. Recently found and installed weewx to connect to Acurite 5n1 > USB display > Everything is working except the reports have a couple issues. > > weewx 5.1 running on rpi zero 2 w - Ubuntu Server 24.04.3 LTS fully updated > MariaDB 10.11.2 running on Windows 11 > weewx.conf setup to connect to mysql using ID/PW: weewx/weewx > > On the monthly report I'm seeing: > > TEMPERATURE (F), RAIN (in), WIND SPEED (mph) HEAT COOL AVG MEAN DEG DEG > WIND DOM DAY TEMP HIGH TIME LOW TIME DAYS DAYS RAIN SPEED HIGH TIME DIR > --------------------------------------------------------------------------------------- > 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 87.6 96.0 15:30 > 75.2 00:00 $day.heatdeg.sum.format($Temp,$NONE,add_label=False) > $day.cooldeg.sum.format($Temp,$NONE,add_label=False) 0.00 3.3 9.9 12:49 0 > 21 82.9 100.3 16:40 71.8 06:50 > $day.heatdeg.sum.format($Temp,$NONE,add_label=False) > $day.cooldeg.sum.format($Temp,$NONE,add_label=False) 0.00 1.5 11.4 19:45 > 292 22 79.4 93.6 14:50 72.1 05:30 > $day.heatdeg.sum.format($Temp,$NONE,add_label=False) > $day.cooldeg.sum.format($Temp,$NONE,add_label=False) 0.00 1.1 10.4 16:35 14 > 23 77.4 89.9 12:05 73.9 13:20 > $day.heatdeg.sum.format($Temp,$NONE,add_label=False) > $day.cooldeg.sum.format($Temp,$NONE,add_label=False) 1.70 1.0 9.9 17:03 90 > 24 76.3 89.8 14:30 70.3 07:05 > $day.heatdeg.sum.format($Temp,$NONE,add_label=False) > $day.cooldeg.sum.format($Temp,$NONE,add_label=False) 0.03 2.2 8.3 11:42 354 > > On the yearly report I'm seeing: > > MEAN MEAN DEG DEG >= <= <= <= YR MO MAX MIN MEAN DAYS DAYS HI DAY LOW DAY > 90 32 32 0 > ------------------------------------------------------------------------------------------------ > 2025 01 2025 02 2025 03 2025 04 2025 05 2025 06 2025 07 2025 08 > $month.outTemp.meanmax.format($Temp,$NONE,add_label=False) > $month.outTemp.meanmin.format($Temp,$NONE,add_label=False) 80.5 > $month.heatdeg.sum.format($Temp,$NONE,add_label=False) > $month.cooldeg.sum.format($Temp,$NONE,add_label=False) 100.3 21 70.3 24 > $month.outTemp.max_ge($Hot).format($Count,$NONE,add_label=False) > $month.outTemp.max_le($Cold).format($Count,$NONE,add_label=False) > $month.outTemp.min_le($Cold).format($Count,$NONE,add_label=False) > $month.outTemp.min_le($VeryCold).format($Count,$NONE,add_label=False) 2025 > 09 2025 10 2025 11 2025 12 > ------------------------------------------------------------------------------------------------ > $year.outTemp.meanmax.format($Temp,$NONE,add_label=False) > $year.outTemp.meanmin.format($Temp,$NONE,add_label=False) 80.5 > $year.heatdeg.sum.format($Temp,$NONE,add_label=False) > $year.cooldeg.sum.format($Temp,$NONE,add_label=False) 100.3 Aug 70.3 Aug > $year.outTemp.max_ge($Hot).format($Count,$NONE,add_label=False) > $year.outTemp.max_le($Cold).format($Count,$NONE,add_label=False) > $year.outTemp.min_le($Cold).format($Count,$NONE,add_label=False) > $year.outTemp.min_le($VeryCold).format($Count,$NONE,add_label=False) > > Any fixes for these items? > > Regards, > > Tommy > > -- > You received this message because you are subscribed to the Google Groups > "weewx-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion visit > https://groups.google.com/d/msgid/weewx-user/71b7628d-6a56-4dfe-81cb-1937db075e12n%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/71b7628d-6a56-4dfe-81cb-1937db075e12n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEB%2B%2BHHAtExoacTem8d-LF29E8yKdfXWncLwd9VQh7aeYA%40mail.gmail.com.
