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 weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
