I'm encountering the very same problem within weewx 4.10.2.
I've downloaded your modified sqlite.py, but it is identical to the
released version.
If running wee_report I get the error
Generating as of last timestamp in the database.
Using configuration file /etc/weewx/weewx.conf
Traceback (most recent call last):
File "/usr/share/weewx/weedb/sqlite.py", line 39, in guarded_fn
return fn(*args, **kwargs)
File "/usr/share/weewx/weedb/sqlite.py", line 233, in execute
return sqlite3.Cursor.execute(self, *args, **kwargs)
sqlite3.OperationalError: no such function: RADIANS
weewx is running on a raspberry pi3 using bullseye, i.e linux 5.10.78-7
Chris Nelson schrieb am Freitag, 25. November 2022 um 04:48:12 UTC+1:
> Thanks Tom.
>
> As you suspected...
>
> $ python -c "import sqlite3; sqlite3.connect(':memory:').execute('SELECT
> RADIANS(1.0)')"
> Traceback (most recent call last):
> File "<string>", line 1, in <module>
>
> sqlite3.OperationalError: no such function: RADIANS
> $ python3 -c "import sqlite3; sqlite3.connect(':memory:').execute('SELECT
> RADIANS(1.0)')"
> Traceback (most recent call last):
> File "<string>", line 1, in <module>
>
> sqlite3.OperationalError: no such function: RADIANS
>
> I replaced sqlite.py with your modified one and all is well. I also
> deleted the sqlite.pyc file at the same location and cleared the Firefox
> cache.
>
> A beautiful day in Phoenix today... https://cjnaz.duckdns.org/weewx/
> Thank you,
> cjn
>
> On Thursday, November 24, 2022 at 12:42:07 PM UTC-7 [email protected]
> wrote:
>
>> I've had the same problem on the Mac. Apparently, there are modern
>> sqlite3 libraries out there that were not compiled with
>> the DSQLITE_ENABLE_MATH_FUNCTIONS option.
>>
>> To test, run this:
>>
>> *python -c "import sqlite3; sqlite3.connect(':memory:').execute('SELECT
>> RADIANS(1.0)')"*
>>
>>
>> If you get the error
>>
>> sqlite3.OperationalError: no such function: RADIANS
>>
>>
>> then your library was not compiled with the flag.
>>
>> I've changed to code to explicitly test for the math functions rather
>> than rely on a version number. Replace your copy of weedb/sqlite.py
>> (usually found in /usr/share/weewx/weedb/sqlite.py) with this one.
>> <https://raw.githubusercontent.com/weewx/weewx/cbd8b570cfa0488721db5739c73a26c4fd2fe78b/bin/weedb/sqlite.py>
>>
>>
>>
>>
>>
>>
>> On Thu, Nov 24, 2022 at 11:25 AM Chris Nelson <[email protected]> wrote:
>>
>>> Hum... I still have the problem. I've read the
>>> <https://groups.google.com/g/weewx-user/c/VMUPd4l5H_w/m/o0cl7EJEBQAJ>Version
>>>
>>> 4.9.0 available
>>> <https://groups.google.com/g/weewx-user/c/VMUPd4l5H_w/m/o0cl7EJEBQAJ>
>>> and weedb.OperationalError: no such function: RADIANS
>>> <https://groups.google.com/g/weewx-user/c/WQAUCUAKe18/m/fjsbwJSWBQAJ>
>>> threads, and the issue was to be fixed in 4.9.1. I had updated from 4.8.0
>>> to 4.9.1 on Nov 11 and have the problem since then. Hints please. Thank
>>> you.
>>>
>>> The report generator seems to crash when generating the Month page. Day
>>> and Week pages update as expected. It appears that weewx is still trying
>>> to use the RADIANS function in sqlite3.
>>>
>>> I'm on Centos 7 with weewx running the official (ancient) Python3
>>> install, and running via systemd.
>>>
>>> $ yum info weewx
>>> ...
>>> Installed Packages
>>> Name : weewx
>>> Arch : noarch
>>> Version : 4.9.1
>>> Release : 1.el7
>>> Size : 5.5 M
>>> Repo : installed
>>> From repo : weewx
>>> Summary : weather software
>>> URL : http://www.weewx.com
>>>
>>> The webpage displays
>>> About this station ♦
>>>
>>> Hardware
>>> AcuRite 01035
>>> Latitude
>>> 33° 16.92' N
>>> Longitude
>>> 111° 44.39' W
>>> Altitude
>>> 1285 feet
>>> Server uptime
>>> 0 days, 0 hours, 28 minutes
>>> WeeWX uptime
>>> 0 days, 0 hours, 28 minutes
>>> WeeWX version
>>> 4.9.1
>>> Skin
>>> Seasons 4.9.1
>>>
>>> The systemd unit file has...
>>> [Service]
>>> ExecStart=/usr/bin/python3 /usr/share/weewx/weewxd --daemon
>>> --pidfile=/var/run/weewx.pid /etc/weewx/weewx.conf
>>>
>>> Python3 (ancient) version...
>>> $ python3 -V
>>> Python 3.6.8
>>>
>>> The sqlite3 version is (ancient) per the base os...
>>> $ python3 -c "import sqlite3; print(sqlite3.sqlite_version)"
>>> 3.7.17
>>>
>>> Attached is the log...
>>>
>>>
>>>
>>> On Friday, October 28, 2022 at 2:34:56 AM UTC-7 [email protected] wrote:
>>>
>>>> Tnx. I didn't know that this is connected :-)
>>>>
>>> --
>>>
>> 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 on the web visit
>>> https://groups.google.com/d/msgid/weewx-user/fa146277-2a97-46c7-b8db-ee380e74998an%40googlegroups.com
>>>
>>> <https://groups.google.com/d/msgid/weewx-user/fa146277-2a97-46c7-b8db-ee380e74998an%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 on the web visit
https://groups.google.com/d/msgid/weewx-user/ddc49edd-00b8-473a-b379-47a40a496e13n%40googlegroups.com.
