that would make sense. perhaps the sqlite library "helpfully" inserts the space. Not what you requested but probably what you intended. The python concatenation does not insert a space.
On Wednesday, 24 August 2022 at 4:32:47 pm UTC+10 kk44...@gmail.com wrote: > I have got an idea: There is no space between the last question mark and > the word "ORDER". By now I have got no reply from the user for that point. > > That is the error log the user provided: > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: Caught > unrecoverable exception in generator 'weewx.imagegenerator.ImageGenerator' > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** (1064, > "You have an error in your SQL syntax; check the manual that corresponds to > your MariaDB server version for the right syntax to use near 'BY dateTime' > at line 1") > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** Traceback > (most recent call last): > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** File > "/usr/share/weewx/weedb/mysql.py", line 54, in guarded_fn > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** return > fn(*args, **kwargs) > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** File > "/usr/share/weewx/weedb/mysql.py", line 266, in execute > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** > self.cursor.execute(mysql_string, tuple(sql_tuple)) > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** File > "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 250, in execute > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** > self.errorhandler(self, exc, value) > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** File > "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 50, in > defaulterrorhandler > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** raise > errorvalue > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** File > "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 247, in execute > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** res = > self._query(query) > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** File > "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 411, in _query > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** rowcount = > self._do_query(q) > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** File > "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 374, in _do_query > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** db.query(q) > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** File > "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 292, in query > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** > _mysql.connection.query(self, query) > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** > _mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL > syntax; check the manual that corresponds to your MariaDB server version > for the right syntax to use near 'BY dateTime' at line 1") > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** During > handling of the above exception, another exception occurred: > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** Traceback > (most recent call last): > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** File > "/usr/share/weewx/weewx/reportengine.py", line 197, in run > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** obj.start() > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** File > "/usr/share/weewx/weewx/reportengine.py", line 385, in start > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** self.run() > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** File > "/usr/share/weewx/weewx/imagegenerator.py", line 42, in run > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** > self.gen_images(self.gen_ts) > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** File > "/usr/share/weewx/weewx/imagegenerator.py", line 109, in gen_images > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** > self.image_dict[timespan][plotname]) > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** File > "/usr/share/weewx/weewx/imagegenerator.py", line 249, in gen_plot > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** > **option_dict) > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** File > "/usr/share/weewx/weewx/xtypes.py", line 101, in get_series > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** > aggregate_interval, **option_dict) > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** File > "/usr/share/weewx/weewx/xtypes.py", line 167, in get_series > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** agg_vt = > get_aggregate(obs_type, stamp, do_aggregate, db_manager) > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** File > "/usr/share/weewx/weewx/xtypes.py", line 128, in get_aggregate > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** > **option_dict) > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** File > "/usr/share/weewx/user/GTS.py", line 1039, in get_aggregate > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** return > self.calc_derived(obs_type,timespan,aggregate_type,db_manager) > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** File > "/usr/share/weewx/user/GTS.py", line 885, in calc_derived > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** % > db_manager.table_name,timespan): > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** File > "/usr/share/weewx/weewx/manager.py", line 473, in genSql > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** for _row > in _cursor.execute(sql, sqlargs): > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** File > "/usr/share/weewx/weedb/mysql.py", line 63, in guarded_fn > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** raise > klass(e) > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** > weedb.DatabaseError: (1064, "You have an error in your SQL syntax; check > the manual that corresponds to your MariaDB server version for the right > syntax to use near 'BY dateTime' at line 1") > 2022-08-22 22:00:40 weewx[15344] ERROR weewx.reportengine: **** Generator > terminated > > >>>> -- You received this message because you are subscribed to the Google Groups "weewx-development" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-development+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-development/a7077a69-bc61-49de-bc42-f217b5abc7fen%40googlegroups.com.