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/3BC2409B-2B13-4D9B-BF89-F3C22D9FF5E9%40gmail.com.
