Re: [weewx-user] Monthly and Yearly standard reports showing code instead of data

Sun, 24 Aug 2025 14:16:32 -0700

MariaDB is supposed to be a drop-in replacement for MySQL so it sounds like a bug. :) 

I am glad you got things working.

---
pablo


On 2025-08-24 17:02, tommy Teague wrote:
I reverted to sqlite and the data populates as expected. I'll look at making backups now... 

Regards,

Tommy

On Sunday, August 24, 2025 at 4:35:48 PM UTC-4 Pablo Sanchez wrote:

    Ah, that does make sense why you want to piggyback off of your
    existing Maria DB installation.

    Have a look at https://github.com/benbjohnson/litestream as a
    method to continuously back up the DB to a remote server.

    Personally, I rsync the entire weemx data directory to another
    server. I may lose some data but probably not relevant. ;)

    Cheers!
    ---
    pablo


    On August 24, 2025 16:21:59 tommy Teague <[email protected]> wrote:


    Thank you all for the quick replies.

    I use Maria for several home automation projects here at the
    house so figured it was a no brainer. I use this Windows PC as a
    common file location and DB server, OTA TV recording, etc. etc.

    Could I store the sqlite file on a network drive to cut down on
    the rpi sdcard writes? Or just live with the data loss risk and
    perform backups?

    Regards,

    Tommy

    On Sunday, August 24, 2025 at 4:16:34 PM UTC-4 Tom Keffer wrote:

        Indeed. See the wiki article on SQLite vs MySQL
        <https://github.com/weewx/weewx/wiki/SQLite-vs-MySQL> on just
        this subject.

        On Sun, Aug 24, 2025 at 12:48 PM Pablo Sanchez
        <[email protected]> wrote:

            Tommy,

            As it is a new installation, it be worth trying SQLite.

            As a database geek, I also run SQLite. There is no need
            to incur the overhead of setting up and running
            MariaDB/MySQL for a single-user environment. SQLite is
            light weight and self-contained. If you want to query it,
            you can install a client and muck around.

            Cheers!

            ---
            pablo


            On 2025-08-24 15:25, Tom Keffer wrote:

            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
            
<https://groups.google.com/d/msgid/weewx-user/CAPq0zEB%2B%2BHHAtExoacTem8d-LF29E8yKdfXWncLwd9VQh7aeYA%40mail.gmail.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/2e4152d6-2d5d-4a50-94b3-92072e27be17%40hillsandlakes.com
            
<https://groups.google.com/d/msgid/weewx-user/2e4152d6-2d5d-4a50-94b3-92072e27be17%40hillsandlakes.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/3379112e-55d9-4043-ad31-2bd18ee46f1bn%40googlegroups.com
    
<https://groups.google.com/d/msgid/weewx-user/3379112e-55d9-4043-ad31-2bd18ee46f1bn%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/0c42505e-a3cc-46fd-a2b1-aab792b26845n%40googlegroups.com <https://groups.google.com/d/msgid/weewx-user/0c42505e-a3cc-46fd-a2b1-aab792b26845n%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/c98d05a8-60aa-47d9-96d7-a2c881373256%40hillsandlakes.com.

Reply via email to