Sorry, my fault: I've modified skin.conf for weekly created images. And I've used windDir instead of wind within weekwinddir - I've assumed aspelling error (naming the image ...winddir but using wind as observation. Mysterious (to me) why that triggered failure of wee_report. After fixing my error wee_report runs fine.
Michael Waldor schrieb am Donnerstag, 9. März 2023 um 08:57:42 UTC+1: > 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 tke...@gmail.com >> 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 <cjnc...@gmail.com> 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 kac...@gmail.com 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 weewx-user+...@googlegroups.com. >>>> >>> 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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/8c0ce8f7-f1fa-482c-9f19-49adfe49ef58n%40googlegroups.com.