Well David, I do not know. I googled the error and only found the MySQL conversation. I do not know if SQLite has a similar setting for sqlmode. As you say though, it looks unlikely to be a skin issue. As to whether you are running SQLite or MySQL only you know. Weewx defaults to SQLite.
On 27 August 2018 at 14:26, David Hathaway <[email protected]> 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-chang >> e-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.Cheetah >>>> Generator >>>> 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.
