Yup was me my attempt to modify my database that made this happen…. Found a redneck way to solve it….. Drop the columns and added them again and voila…. Up and running again!
> On 27 Sep 23, at 22:00, Lorin Tremblay <[email protected]> wrote: > > Guess I screwed up my database? > Is that related to my attempt to remove my data? > > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: Caught > unrecoverable exception: > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** '<' > not supported between instances of 'float' and 'str' > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > Traceback (most recent call last): > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > File "/usr/share/weewx/weewx/engine.py", line 214, in run > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > self.dispatchEvent(weewx.Event(weewx.CHECK_LOOP, packet=packet)) > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > File "/usr/share/weewx/weewx/engine.py", line 245, in dispatchEvent > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > callback(event) > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > File "/usr/share/weewx/weewx/engine.py", line 634, in check_loop > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > raise BreakLoop > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > weewx.engine.BreakLoop > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > During handling of the above exception, another exception occurred: > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > Traceback (most recent call last): > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > File "/usr/share/weewx/weewx/engine.py", line 650, in post_loop > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > self._catchup(self.engine.console.genArchiveRecords) > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > File "/usr/share/weewx/weewx/engine.py", line 697, in _catchup > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > for record in generator(lastgood_ts): > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > File "/usr/share/weewx/weewx/drivers/__init__.py", line 30, in > genArchiveRecords > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > raise NotImplementedError("Method 'genArchiveRecords' not implemented") > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > NotImplementedError: Method 'genArchiveRecords' not implemented > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > During handling of the above exception, another exception occurred: > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > Traceback (most recent call last): > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > File "/usr/share/weewx/weewxd", line 154, in main > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > engine.run() > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > File "/usr/share/weewx/weewx/engine.py", line 221, in run > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > self.dispatchEvent(weewx.Event(weewx.POST_LOOP)) > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > File "/usr/share/weewx/weewx/engine.py", line 245, in dispatchEvent > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > callback(event) > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > File "/usr/share/weewx/weewx/engine.py", line 652, in post_loop > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > self._software_catchup() > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > File "/usr/share/weewx/weewx/engine.py", line 715, in _software_catchup > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > self.engine.dispatchEvent(weewx.Event(weewx.NEW_ARCHIVE_RECORD, > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > File "/usr/share/weewx/weewx/engine.py", line 245, in dispatchEvent > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > callback(event) > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > File "/usr/share/weewx/weewx/engine.py", line 675, in new_archive_record > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > dbmanager.addRecord(event.record, > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > File "/usr/share/weewx/weewx/manager.py", line 403, in addRecord > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > self._updateHiLo(accumulator, cursor) > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > File "/usr/share/weewx/weewx/manager.py", line 1191, in _updateHiLo > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > _stats_dict.updateHiLo(accumulator) > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > File "/usr/share/weewx/weewx/accum.py", line 462, in updateHiLo > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > func(self, accumulator, obs_type) > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > File "/usr/share/weewx/weewx/accum.py", line 551, in merge_minmax > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > self[obs_type].mergeHiLo(x_accumulator[obs_type]) > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > File "/usr/share/weewx/weewx/accum.py", line 144, in mergeHiLo > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > if self.min is None or x_stats.min < self.min: > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > TypeError: '<' not supported between instances of 'float' and 'str' > Sep 27 21:45:22 Weewx-APRS3695 weewx[5602] CRITICAL __main__: **** > Exiting. > > >> On 27 Sep 23, at 20:28, vince <[email protected]> wrote: >> >> https://github.com/weewx/weewx/wiki/Cleaning-up-old-'bad'-data >> >> On Wednesday, September 27, 2023 at 5:17:26 PM UTC-7 Lorin Tremblay wrote: >>> What would be the appropriate way to delete the data for all the in value >>> that there is in my database….. >>> >>> The reason is that my GW1100 was outside for testing purpose and now it’s >>> inside where it’s going to stay, so I want to delete all the data from >>> today (sept27 to the beginning) >>> >>> inDewpoint >>> InHumidity >>> inTemp >>> >>> These are the field that I would like to remove all the data from… >>> >>> I have SQLlite browser installed >>> >>> Do I just go to browse data and delete all that is in those cell? >> >> >> -- >> 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] >> <mailto:[email protected]>. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/352abd40-e91a-4574-b1a6-64e0dcd6d1e0n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/352abd40-e91a-4574-b1a6-64e0dcd6d1e0n%40googlegroups.com?utm_medium=email&utm_source=footer>. > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/60E87BD9-A203-45D7-BF9B-6A1A6E4F7E4A%40gmail.com.
