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 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.
