Hi folks, installed the extension and skin this morning, however getting an error on running of weewx...
Restful/MQTT is working as it should, but getting this error. It seems that belchertown extension is expecting the generic SQL method rather the mySQL method. Oct 5 11:57:13 weewx weewx[9726]: manager: Added record 2018-10-05 11:57:00 CDT (1538758620) to daily summary in 'weewx' Oct 5 11:57:14 weewx weewx[9726]: engine: Launch of report thread aborted: existing report thread still running Oct 5 11:57:14 weewx weewx[9726]: restx: MQTT: Published record 2018-10-05 11:57:00 CDT (1538758620) Oct 5 11:57:14 weewx weewx[9726]: restx: MQTT: Published record 2018-10-05 11:57:14 CDT (1538758634) Oct 5 11:57:14 weewx weewx[9726]: restx: MQTT: Published record 2018-10-05 11:57:14 CDT (1538758634) Oct 5 11:57:15 weewx weewx[9726]: restx: MQTT: Published record 2018-10-05 11:57:15 CDT (1538758635) Oct 5 11:57:17 weewx weewx[9726]: restx: MQTT: Published record 2018-10-05 11:57:17 CDT (1538758637) Oct 5 11:57:19 weewx weewx[9726]: restx: MQTT: Published record 2018-10-05 11:57:19 CDT (1538758639) Oct 5 11:57:21 weewx weewx[9726]: restx: MQTT: Published record 2018-10-05 11:57:21 CDT (1538758641) Oct 5 11:57:23 weewx weewx[9726]: restx: MQTT: Published record 2018-10-05 11:57:23 CDT (1538758643) Oct 5 11:57:25 weewx weewx[9726]: restx: MQTT: Published record 2018-10-05 11:57:25 CDT (1538758645) Oct 5 11:57:27 weewx weewx[9726]: restx: MQTT: Published record 2018-10-05 11:57:27 CDT (1538758647) Oct 5 11:57:29 weewx weewx[9726]: restx: MQTT: Published record 2018-10-05 11:57:29 CDT (1538758649) Oct 5 11:57:31 weewx weewx[9726]: restx: MQTT: Published record 2018-10-05 11:57:31 CDT (1538758651) Oct 5 11:57:33 weewx weewx[9726]: restx: MQTT: Published record 2018-10-05 11:57:33 CDT (1538758653) Oct 5 11:57:35 weewx weewx[9726]: restx: MQTT: Published record 2018-10-05 11:57:35 CDT (1538758655) Oct 5 11:57:35 weewx weewx[9726]: cheetahgenerator: Generated 4 files for report Highcharts_Belchertown in 83.63 seconds Oct 5 11:57:35 weewx weewx[9726]: copygenerator: copied 0 files to /var/www/html/weewx/belchertown Oct 5 11:57:35 weewx weewx[9726]: **** Traceback (most recent call last): Oct 5 11:57:35 weewx weewx[9726]: **** File "/usr/share/weewx/weewx/reportengine.py", line 239, in run Oct 5 11:57:35 weewx weewx[9726]: **** obj.start() Oct 5 11:57:35 weewx weewx[9726]: **** File "/usr/share/weewx/weewx/reportengine.py", line 273, in start Oct 5 11:57:35 weewx weewx[9726]: **** self.run() Oct 5 11:57:35 weewx weewx[9726]: **** File "/usr/share/weewx/weewx/cheetahgenerator.py", line 158, in run Oct 5 11:57:35 weewx weewx[9726]: **** ngen = self.generate(gen_dict[section_name], self.gen_ts) Oct 5 11:57:35 weewx weewx[9726]: **** File "/usr/share/weewx/weewx/cheetahgenerator.py", line 232, in generate Oct 5 11:57:35 weewx weewx[9726]: **** ngen += self.generate(section[subsection], gen_ts) Oct 5 11:57:35 weewx weewx[9726]: **** File "/usr/share/weewx/weewx/cheetahgenerator.py", line 232, in generate Oct 5 11:57:35 weewx weewx[9726]: **** ngen += self.generate(section[subsection], gen_ts) Oct 5 11:57:35 weewx weewx[9726]: **** File "/usr/share/weewx/weewx/cheetahgenerator.py", line 320, in generate Oct 5 11:57:35 weewx weewx[9726]: **** default_binding) Oct 5 11:57:35 weewx weewx[9726]: **** File "/usr/share/weewx/weewx/cheetahgenerator.py", line 372, in _getSearchList Oct 5 11:57:35 weewx weewx[9726]: **** searchList += obj.get_extension_list(timespan, db_lookup) Oct 5 11:57:35 weewx weewx[9726]: **** File "/usr/share/weewx/user/belchertown.py", line 148, in get_extension_list Oct 5 11:57:35 weewx weewx[9726]: **** at_rainiest_month = wx_manager.getSql( at_rainiest_month_sql ) Oct 5 11:57:35 weewx weewx[9726]: **** File "/usr/share/weewx/weewx/manager.py", line 394, in getSql Oct 5 11:57:35 weewx weewx[9726]: **** _cursor.execute(sql, sqlargs) Oct 5 11:57:35 weewx weewx[9726]: **** File "/usr/share/weewx/weedb/mysql.py", line 48, in guarded_fn Oct 5 11:57:35 weewx weewx[9726]: **** raise klass(e) Oct 5 11:57:35 weewx weewx[9726]: **** 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") Oct 5 11:57:35 weewx weewx[9726]: copygenerator: copied 1 files to /var/www/html/weewx/belchertown Or is this a config line somewhere that I missed? -- 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.
