I had weewx 4,8 installed on a raspberry pi 4 mod B 8GB ram Everything was running smoothly and was working fine, archiving and retrieving correctly from sqlite database After the installation of weewx 4.9 the function wee_reports was not working correctly due to an exception.
I have an exception on RADIANT function when running wee_reports. The function looks like missing return sqlite3.Cursor.execute(self, *args, **kwargs) sqlite3.OperationalError: no such function: RADIANS During handling of the above exception, another exception occurred: File "/usr/share/weewx/weedb/sqlite.py", line 44, in guarded_fn raise weedb.OperationalError(e) weedb.OperationalError: no such function: RADIANS Can you give me a hint? Thanks, Raffaello On Tue, Oct 25, 2022 at 2:26 AM vince <vinceska...@gmail.com> wrote: > Quick check using *python3 -c "import sqlite3; > print(sqlite3.sqlite_version)" * > > On Monday, October 24, 2022 at 4:14:00 PM UTC-7 Tom Keffer wrote: > >> One glitch that could affect new users running older operating systems. >> >> Older versions of the Seasons skin plot wind direction over time. >> Unfortunately, they do this by taking the scalar average of the wind >> directions, instead of the vector average. For example, directions 350°, >> 0°, and 10° would average out to 120°, not the 0° you would expect. >> >> The version of Seasons in V4.9 fixes this problem, but it uses SQL >> queries that use mathematical functions that were introduced in sqlite in >> v3.35, which came out about a year and a half ago. Not all versions of >> sqlite have caught up. >> >> Bottom line: if you're installing a new version of the Seasons skin you >> could encounter this problem. There are several easy workarounds. Let me >> know if you have the problem. >> >> MySQL users are not affected. >> >> Cheers, >> >> -tk >> >> >> >> On Mon, Oct 24, 2022 at 2:57 PM Tom Keffer <tke...@gmail.com> wrote: >> >>> Some new features, some bug fixes. For the most part, upwardly compatible >>> with earlier releases. See the upgrade guide >>> <http://www.weewx.com/docs/upgrading.htm#Upgrading_to_V4.9> for the two >>> obscure exceptions. >>> >>> Available in the usual places. >>> >>> >>> 4.9.0 10/24/2022 >>> Fix problem that create 'ghost' values for VantageVue stations. >>> Fix problem that causes `leafWet3` and `leafWet4` to be emitted in VP2 >>> stations that do not have the necessary sensors. >>> Fixes issue #771. >>> >>> Try waking the Vantage console before giving up on LOOP errors. >>> Better Vantage diagnostics. >>> Fixes issue #772. >>> >>> Add missing 30-day barometer graph to Smartphone skin. >>> Fixes issue #774. >>> >>> Fix check for reuse_ssl for Python versions greater than 3.10. >>> Fixes issue #775. >>> >>> The utility wee_reports can now be invoked by specifying a --date and >>> --time. >>> Fixes issue #776. >>> >>> Allow timestamps that are not integers. >>> Fixes issue #779. >>> >>> Add localization file for Traditional Chinese. Thanks to user lyuxingliu! >>> PR #777. >>> >>> Don't swallow syntax errors when wee_config is looking for drivers. >>> >>> Include 'wind' in daily summary if 'windSpeed' is present. >>> >>> Refine translations for French skin. Thanks to user Pascal! >>> >>> Allow a custom cipher to be specified for FTP uploads. See option 'cipher' >>> under [[FTP]]. >>> >>> Ensure that rundir exists and has correct permissions in weewx-multi >>> >>> Allow auto-provisioning feature of Seasons to work when using a SQL >>> expression >>> for option data_type in the ImageGenerator. Fixes issue #782. >>> >>> Allow constants albedo, cn, and cd to be specified when calculating ET. >>> See the User's Guide. Resolves issue #730. >>> >>> Fix problem that prevented wee_reports from using a default location >>> for weewx.conf. >>> >>> Post location of the configuration file and the top-level module to the >>> station >>> registry. Thanks to Vince! PR #705. >>> >>> Fix minor install warning under Python 3.10. Fixes issue #799. >>> >>> Fix problem where xtypes.ArchiveTable.get_series() does not pass option_dict >>> on to get_aggregate(). Fixes issue #797 >>> >>> Added copytruncate option to default log rotation configuration. Thanks to >>> user sastorsl. Addresses PR #791. >>> >>> Update the default and example rules in rsyslog configuration. The output >>> from the weewx daemon goes to weewxd.log whereas the output from wee_xxx >>> utilities goes to weewx.log. Also added examples of how to deal with >>> systemd/journald messing with log output. Addresses PR#788 and PR#790. >>> Thanks to user sastorsl. >>> >>> Allow additional aggregation intervals for observation type $wind. In >>> particular, 'vecdir' and 'vecavg' can be done for aggregation intervals >>> other >>> than multiples of a day. >>> Fixes issue #800. >>> >>> -- > 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 weewx-user+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/179e7a04-6bc1-4ef6-913b-d66e456ddf8cn%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/179e7a04-6bc1-4ef6-913b-d66e456ddf8cn%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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CANOEND-mkifRUad8LrHXTr6viQVqwGxho%2Bv_6tcvBu1-rai3Hg%40mail.gmail.com.