The problem is that a string got introduced into the database where a number was expected. This is a common problem when using a visual database editor. When you "clear" a value, they often insert an empty string instead of a null value.
On Wed, Sep 27, 2023 at 7:43 PM Lorin Tremblay <[email protected]> wrote: > 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]. > 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 > <https://groups.google.com/d/msgid/weewx-user/60E87BD9-A203-45D7-BF9B-6A1A6E4F7E4A%40gmail.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/CAPq0zEBNxWHYGUNs0uN0Q8Pq2B2HNycLkYiWLD8_XYyJv%2Ba7Xg%40mail.gmail.com.
