Three things: 1. Let's see what's actually in your database.
*show tables in weewxwftest;* 2. Can we see the output of *wee_debug --info* Double check that the utility obfuscated any passwords you might have in weewx.conf. 3. Just to double check: you only have one weewx.conf file, right? On Thu, Jul 8, 2021 at 11:38 PM 'Jan-Jaap van der Geer' via weewx-user < weewx-user@googlegroups.com> wrote: > The log doesn't seem to tell anything special: > > [/share/homes/admin/weewxwftest] # cat /var/log/messages | grep > wee_database > Jul 9 08:23:30 qnap user.info wee_database[20528] INFO weewx.manager: > Dropping daily summary tables from 'weewxwftest' ... > Jul 9 08:23:30 qnap user.info wee_database[20528] INFO weewx.manager: > Dropped daily summary tables from database 'weewxwftest' > Jul 9 08:23:49 qnap user.info wee_database[21058] INFO __main__: All > daily summaries will be rebuilt. > Jul 9 08:23:56 qnap user.info wee_database[21058] INFO weewx.manager: > Created daily summary tables > Jul 9 08:23:56 qnap user.info wee_database[21058] INFO __main__: > Rebuilding daily summaries in database 'weewxwftest' ... > Jul 9 08:23:56 qnap user.info wee_database[21058] INFO weewx.manager: > Starting backfill of daily summaries > Jul 9 08:32:32 qnap user.info wee_database[21058] INFO weewx.manager: > Processed 132119 records to backfill 208 day summaries in 515.43 seconds > Jul 9 08:32:32 qnap user.info wee_database[21058] INFO __main__: Rebuild > of daily summaries in database 'weewxwftest' complete > > (I had to run it again as the log from yesterday had already been purged > but I suppose the result is the same. I did watch the log and didn't notice > anything interesting at the time) > > Thanks, > Jan-Jaap > On Friday, July 9, 2021 at 3:57:22 AM UTC+2 tke...@gmail.com wrote: > >> How about the log from when you tried dropping and rebuilding the >> database? >> >> On Thu, Jul 8, 2021 at 2:29 PM 'Jan-Jaap van der Geer' via weewx-user < >> weewx...@googlegroups.com> wrote: >> >>> I have the exact same errors as fpb: >>> >>> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR weewx.cheetahgenerator: >>> Generate failed with exception '<class 'NameMapper.NotFound'>' >>> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR weewx.cheetahgenerator: >>> **** Ignoring template >>> /share/homes/admin/weewxwf/skins/Seasons/NOAA/NOAA-%Y-%m.txt.tmpl >>> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR weewx.cheetahgenerator: >>> **** Reason: cannot find 'raw' while searching for 'day.wind.count.raw' >>> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR weewx.cheetahgenerator: >>> **** Traceback (most recent call last): >>> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR weewx.cheetahgenerator: >>> **** File >>> "/share/CACHEDEV1_DATA/homes/admin/weewxwf/bin/weewx/cheetahgenerator.py", >>> line 326, in generate >>> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR weewx.cheetahgenerator: >>> **** unicode_string = compiled_template.respond() >>> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR weewx.cheetahgenerator: >>> **** File >>> "_share_homes_admin_weewxwf_skins_Seasons_NOAA_NOAA__Y__m_txt_tmpl.py", >>> line 430, in respond >>> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR weewx.cheetahgenerator: >>> **** NotFound: cannot find 'raw' while searching for 'day.wind.count.raw' >>> >>> I don't really understand what this 'new schema' and 'old schema' is, >>> but I tried: >>> >>> wee_database --drop-daily >>> wee_database --rebuild-daily >>> >>> both without changing the binding in weewx.conf and after changing it. >>> Right now I have >>> >>> [[wx_binding]] >>> # The database must match one of the sections in [Databases]. >>> # This is likely to be the only option you would want to change. >>> database = archive_mysql >>> # The name of the table within the database >>> table_name = archive >>> # The manager handles aggregation of data for historical >>> summaries >>> manager = weewx.manager.DaySummaryManager >>> # The schema defines the structure of the database. >>> # It is *only* used when the database is created. >>> schema = schemas.wview_extended.schema >>> >>> but using: >>> >>> manager = weewx.wxmanager.WXDaySummaryManager >>> >>> and rebuilding still caused the errors. >>> >>> What should I do to fix this? >>> >>> Thanks, >>> Jan-Jaap >>> >>> On Wednesday, December 16, 2020 at 2:26:19 PM UTC+1 tke...@gmail.com >>> wrote: >>> >>>> You have the correct configuration, but remember, it only applies *when >>>> the database is created*. Thereafter, the schema is read from the >>>> database. >>>> >>>> You can try rebuilding the daily summaries using wee_database: >>>> >>>> *sudo wee_database --drop-daily* >>>> *sudo wee_database --rebuild-daily* >>>> >>>> >>>> The rebuild will use the configuration in weewx.conf. >>>> >>>> -tk >>>> >>>> On Tue, Dec 15, 2020 at 9:58 PM fpb <fpu...@gmail.com> wrote: >>>> >>>>> @Tom, >>>>> >>>>> I'm having a similar issue but I'm trying to figure out what the >>>>> correct schema (assuming that is the issue) but I can't find a >>>>> combination. >>>>> >>>>> This is what I have; >>>>> >>>>> [DataBindings] >>>>> >>>>> [[wx_binding]] >>>>> # The database must match one of the sections in [Databases]. >>>>> # This is likely to be the only option you would want to >>>>> change. >>>>> database = archive_sqlite >>>>> # The name of the table within the database >>>>> table_name = archive >>>>> # The manager handles aggregation of data for historical >>>>> summaries >>>>> manager = weewx.manager.DaySummaryManager >>>>> # The schema defines the structure of the database. >>>>> # It is *only* used when the database is created. >>>>> schema = schemas.wview_extended.schema >>>>> [[forecast_binding]] >>>>> database = forecast_sqlite >>>>> >>>>> and below my log errors; >>>>> >>>>> ec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator: >>>>> Generate failed with exception '<class 'NameMapper.NotFound'>' >>>>> >>>>> Dec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator: >>>>> **** Ignoring template /etc/weewx/skins/Seasons/NOAA/NOAA-%Y-%m.txt.tmpl >>>>> >>>>> Dec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator: >>>>> **** Reason: cannot find 'raw' while searching for 'day.wind.count.raw' >>>>> >>>>> Dec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator: >>>>> **** Traceback (most recent call last): >>>>> >>>>> Dec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator: >>>>> **** File "/usr/share/weewx/weewx/cheetahgenerator.py", line 323, in >>>>> generate >>>>> >>>>> Dec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator: >>>>> **** unicode_string = compiled_template.respond() >>>>> >>>>> Dec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator: >>>>> **** File "_etc_weewx_skins_Seasons_NOAA_NOAA__Y__m_txt_tmpl.py", line >>>>> 430, in respond >>>>> >>>>> Dec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator: >>>>> **** NotFound: cannot find 'raw' while searching for 'day.wind.count.raw' >>>>> Any help will be appreciate. >>>>> >>>>> On Thursday, June 4, 2020 at 6:01:51 PM UTC-4 tke...@gmail.com wrote: >>>>> >>>>>> That's probably what happened. >>>>>> >>>>>> You're not the first to get tripped up by this. Obviously, I need to >>>>>> rethink how to manage the transition to the new way of specifying >>>>>> schemas. >>>>>> >>>>>> On Thu, Jun 4, 2020 at 11:20 AM Jacques Terrettaz <jterr...@gmail.com> >>>>>> wrote: >>>>>> >>>>>>> Forget my last message : I used a new Raspberry PI to install weewx >>>>>>> V4, and then I transferred my "old" mysql database to the new >>>>>>> installation... >>>>>>> >>>>>>> >>>>>>> Le 4 juin 2020 à 20:01, Jacques Terrettaz <jterr...@gmail.com> a >>>>>>> écrit : >>>>>>> >>>>>>> Tom, >>>>>>> >>>>>>> One comment about the old and new database schema : I didn't change >>>>>>> anything by myself in the [DataBinding] section of weewx.conf after the >>>>>>> upgrade to V4.0, so I suspect that the manager = weewx.manager. >>>>>>> DaySummaryManager line was automatically modified during the >>>>>>> upgrade process. >>>>>>> Is it right ? >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> 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/ACB63400-3370-43DF-A186-A96D3BC23AA3%40gmail.com >>>>>>> <https://groups.google.com/d/msgid/weewx-user/ACB63400-3370-43DF-A186-A96D3BC23AA3%40gmail.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+...@googlegroups.com. >>>>> >>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/weewx-user/d4d9e47e-ca30-4729-a81b-9d1cfd8dde76n%40googlegroups.com >>>>> <https://groups.google.com/d/msgid/weewx-user/d4d9e47e-ca30-4729-a81b-9d1cfd8dde76n%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+...@googlegroups.com. >>> >> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/weewx-user/d4e7d688-fe41-4258-b7c9-6068c95012b3n%40googlegroups.com >>> <https://groups.google.com/d/msgid/weewx-user/d4e7d688-fe41-4258-b7c9-6068c95012b3n%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/17e8d219-f018-493f-aef4-6a5b323f4075n%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/17e8d219-f018-493f-aef4-6a5b323f4075n%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/CAPq0zEBT25WSp%3DA5qXaUYn9t-K7KbqWeKm_OFXBtWBxrBOfT0Q%40mail.gmail.com.
