Thanks Pat. I moved the options into weewx.conf after reading that suggestion.
On Mon, Aug 27, 2018 at 8:03 AM Pat <[email protected]> wrote: > I'd suggest using the latest release > <https://github.com/poblabs/weewx-belchertown/releases>. No issues with > upgrading if all your Belchertown options are within weewx.conf. See the > GitHub > readme <https://github.com/poblabs/weewx-belchertown> for those options. > > > On Monday, August 27, 2018 at 8:50:29 AM UTC-4, David Hathaway wrote: >> >> FWIW, the CheetahGenerator issue was caused by the borked upgrade to >> 3.8.2, which set DataBindings.wx_binding.database to archive_sqlite when I >> have been using mysql. I really ought to get a better text compare program >> for times like this. UltraCompare is awesome, but Windows. >> >> I'm ready to get back to trying Belchertown. Yay! >> >> Pat, are there known issues moving from v 0.1 to whatever is on github >> now? (0.4?) If I am going to try moving forward, it ought to be on the >> latest codebase, eh? >> >> On Monday, August 27, 2018 at 6:26:40 AM UTC-5, David Hathaway wrote: >>> >>> Thanks for this Andrew. It shows great promise. >>> >>> Unfortunately, I think there are trickle down issues. I don't know. >>> Now I am getting exceptions in weewx.cheetahgenerator.CheetahGenerator in >>> sqlite.py... but I am running MySQL? This not a Belchertown error, so I'll >>> move further conversation about it outside this conversation. >>> >>> On Sunday, August 26, 2018 at 8:45:04 PM UTC-5, Andrew Milner wrote: >>>> >>>> It looks like this may be an issue with MySQL versions with updates >>>> from 5.5 to later: >>>> >>>> >>>> https://www.sitepoint.com/quick-tip-how-to-permanently-change-sql-mode-in-mysql/ >>>> >>>> >>>> >>>> On Sunday, 26 August 2018 22:48:43 UTC+3, Pat wrote: >>>>> >>>>> I haven't come across this error before. How old is your weewx? >>>>> >>>>> On Sunday, August 26, 2018 at 3:01:10 PM UTC-4, David Hathaway wrote: >>>>>> >>>>>> I'm having a different error, I believe. Any ideas on how to sort it >>>>>> out? >>>>>> >>>>>> My weewx is quite old indeed. Ubuntu 18.04LTS and MySQL. >>>>>> >>>>>> I downloaded the version the day you posted it first, so it is v0.1? >>>>>> Would the later revisions solve the issue? I think not, since this >>>>>> appears >>>>>> to be a SQL issue. >>>>>> >>>>>> >>>>>> 13:56:15 localhost weewx[23412]: restx: Wunderground-PWS: Published >>>>>> record 2018-08-26 13:56:00 CDT (1535309760) >>>>>> Aug 26 13:56:16 localhost weewx[23412]: cheetahgenerator: Generated >>>>>> 14 files for report StandardReport in 0.78 seconds >>>>>> Aug 26 13:56:16 localhost weewx[23412]: imagegenerator: Generated 16 >>>>>> images for StandardReport in 0.76 seconds >>>>>> Aug 26 13:56:16 localhost weewx[23412]: reportengine: Caught >>>>>> unrecoverable exception in generator >>>>>> weewx.cheetahgenerator.CheetahGenerator >>>>>> Aug 26 13:56:16 localhost weewx[23412]: * **** (1055, >>>>>> "Expression #2 of SELECT list is not in GROUP BY clause and contains >>>>>> nonaggregated column 'weewx.archive_day_rain.dateTime' which is not >>>>>> functionally dependent on columns in GROUP BY clause; this is >>>>>> incompatible >>>>>> with sql_mode=only_full_group_by")* >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** Traceback (most >>>>>> recent call last): >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** File >>>>>> "/usr/share/weewx/weewx/reportengine.py", line 239, in run >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** obj.start() >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** File >>>>>> "/usr/share/weewx/weewx/reportengine.py", line 273, in start >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** self.run() >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** File >>>>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 158, in run >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** ngen = >>>>>> self.generate(gen_dict[section_name], self.gen_ts) >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** File >>>>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 232, in generate >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** ngen += >>>>>> self.generate(section[subsection], gen_ts) >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** File >>>>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 232, in generate >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** ngen += >>>>>> self.generate(section[subsection], gen_ts) >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** File >>>>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 320, in generate >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** >>>>>> default_binding) >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** File >>>>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 372, in _getSearchList >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** searchList >>>>>> += obj.get_extension_list(timespan, db_lookup) >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** File >>>>>> "/usr/share/weewx/user/belchertown.py", line 82, in get_extension_list >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** >>>>>> at_rainiest_month = wx_manager.getSql( at_rainiest_month_sql ) >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** File >>>>>> "/usr/share/weewx/weewx/manager.py", line 394, in getSql >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** >>>>>> _cursor.execute(sql, sqlargs) >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** File >>>>>> "/usr/share/weewx/weedb/mysql.py", line 48, in guarded_fn >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** raise >>>>>> klass(e) >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** *DatabaseError: >>>>>> (1055, "Expression #2 of SELECT list is not in GROUP BY clause and >>>>>> contains >>>>>> nonaggregated column 'weewx.archive_day_rain.dateTime' which is not >>>>>> functionally dependent on columns in GROUP BY clause; this is >>>>>> incompatible >>>>>> with sql_mode=only_full_group_by")* >>>>>> Aug 26 13:56:16 localhost weewx[23412]: **** Generator >>>>>> terminated >>>>>> Aug 26 13:56:16 localhost weewx[23412]: copygenerator: copied 1 files >>>>>> to /var/www/html/weewx/belchertown >>>>>> >>>>> -- > You received this message because you are subscribed to a topic in the > Google Groups "weewx-user" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/weewx-user/GSrKZEiPqsc/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- 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]. For more options, visit https://groups.google.com/d/optout.
