Welcome to the Cumulus Support forum.

Latest Cumulus MX V4 release 4.4.2 (build 4085) - 12 March 2025

Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024

Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)

Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki

If you are posting a new Topic about an error or if you need help PLEASE read this first viewtopic.php?p=164080#p164080

SQLiteException

From Cumulus MX version 3 build 3044 the development baton passed to Mark Crossley. Mark has been responsible for all the Builds since, and has recently released Cumulus MX version 4. He has made the code available on GitHub. It is Mark's hope that others will join in this development, but at the very least he welcomes your ideas for future developments (see Cumulus MX Development suggestions).

Moderator: mcrossley

Post Reply
Mudary
Posts: 15
Joined: Sat 30 May 2015 10:20 pm
Weather Station: Davis Pro 2
Operating System: RPi 3+ Buster
Location: Edmonton

SQLiteException

Post by Mudary »

RPI3+
CumulusMX 4022 (downgraded from current version) Build 4043 - Version 4.2.1 - this version was working until I upgraded to Build 4043 - Version 4.3.0.
MXdiag folder zipped.
Thanks Mudary
You do not have the required permissions to view the files attached to this post.
User avatar
mcrossley
Posts: 14384
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: SQLiteException

Post by mcrossley »

If you downgraded did you restore a backup of the diary.db file from v4.0.0?

As per the release notes, the weather diary database (diary.db) gets upgraded on the first run of MX, and so is incompatible with earlier versions.

If you use the weather diary, then restore a backup version. If you do not use the weather diary you can just delete the diary.db file and it will be recreated.
Mudary
Posts: 15
Joined: Sat 30 May 2015 10:20 pm
Weather Station: Davis Pro 2
Operating System: RPi 3+ Buster
Location: Edmonton

Re: SQLiteException

Post by Mudary »

Works when deleted diary.db, Ill try to upgrade to 4.3.0
Mudary
Posts: 15
Joined: Sat 30 May 2015 10:20 pm
Weather Station: Davis Pro 2
Operating System: RPi 3+ Buster
Location: Edmonton

Re: SQLiteException

Post by Mudary »

/opt/dotnet/shared/Microsoft.NETCore.App/8.0.5/libSystem.IO.Ports.Native.so: cannot open shared object file: No such file or directory
/home/pi/CumulusMX/runtimes/unix/lib/net8.0/libSystem.IO.Ports.Native.so: cannot open shared object file: No such file or directory
/home/pi/CumulusMX/runtimes/linux-arm/native/liblibSystem.IO.Ports.Native.so: cannot open shared object file: No such file or directory
/opt/dotnet/shared/Microsoft.NETCore.App/8.0.5/liblibSystem.IO.Ports.Native.so: cannot open shared object file: No such file or directory
/home/pi/CumulusMX/runtimes/unix/lib/net8.0/liblibSystem.IO.Ports.Native.so: cannot open shared object file: No such file or directory
/home/pi/CumulusMX/runtimes/linux-arm/native/libSystem.IO.Ports.Native: cannot open shared object file: No such file or directory
/opt/dotnet/shared/Microsoft.NETCore.App/8.0.5/libSystem.IO.Ports.Native: cannot open shared object file: No such file or directory
/home/pi/CumulusMX/runtimes/unix/lib/net8.0/libSystem.IO.Ports.Native: cannot open shared object file: No such file or directory
/home/pi/CumulusMX/runtimes/linux-arm/native/liblibSystem.IO.Ports.Native: cannot open shared object file: No such file or directory
Mudary
Posts: 15
Joined: Sat 30 May 2015 10:20 pm
Weather Station: Davis Pro 2
Operating System: RPi 3+ Buster
Location: Edmonton

Re: SQLiteException

Post by Mudary »

text file uploaded 4.3.0
Screen is there but no weather information
You do not have the required permissions to view the files attached to this post.
Mudary
Posts: 15
Joined: Sat 30 May 2015 10:20 pm
Weather Station: Davis Pro 2
Operating System: RPi 3+ Buster
Location: Edmonton

Re: SQLiteException

Post by Mudary »

Current CumulusMX install 4.3.0, gauges showing nothing.

Running RPI 3+ Buster 32-bit OS
2024-12-05 10:00:25.949 System.FormatException: The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character among the padding characters.
at System.Convert.FromBase64CharPtr(Char* inputPtr, Int32 inputLength)
at System.Convert.FromBase64String(String s)

Zip included.
You do not have the required permissions to view the files attached to this post.
User avatar
mcrossley
Posts: 14384
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: SQLiteException

Post by mcrossley »

Mudary wrote: Wed 04 Dec 2024 11:21 pm /opt/dotnet/shared/Microsoft.NETCore.App/8.0.5/libSystem.IO.Ports.Native.so: cannot open shared object file: No such file or directory
....
Those errors would indicate you have not copied all the files out of the zip - in particular the runtimes folder.
Mudary wrote: Thu 05 Dec 2024 5:08 pm Current CumulusMX install 4.3.0, gauges showing nothing.

Running RPI 3+ Buster 32-bit OS
2024-12-05 10:00:25.949 System.FormatException: The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character among the padding characters.
at System.Convert.FromBase64CharPtr(Char* inputPtr, Int32 inputLength)
at System.Convert.FromBase64String(String s)
That error indicates you have not copied over the uniqueid.txt file from your previous installation.
Mudary
Posts: 15
Joined: Sat 30 May 2015 10:20 pm
Weather Station: Davis Pro 2
Operating System: RPi 3+ Buster
Location: Edmonton

Re: SQLiteException

Post by Mudary »

I did a stupid erasing of CumulusMX directory without saving a backup. I copied over the distribution files and copied CumulusMX-4063. I also didn't save the dayfile.txt so I'll be starting from new or the uniqueid.txt.
You do not have the required permissions to view the files attached to this post.
Mudary
Posts: 15
Joined: Sat 30 May 2015 10:20 pm
Weather Station: Davis Pro 2
Operating System: RPi 3+ Buster
Location: Edmonton

Re: SQLiteException

Post by Mudary »

Using 4.2.1 4043 until a new update after 4.3.0, I was so frustrated that I erased the CumulusMX folder on my RPI 3+ without backing it up first. I'll try again to so if I can undelete that folder.
Post Reply