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.
