How to delete the in_whatever data that is in my DB

57 views
Skip to first unread message

Lorin Tremblay

unread,
Sep 27, 2023, 8:17:26 PM9/27/23
to weewx-user
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?

Tom Keffer

unread,
Sep 27, 2023, 8:28:04 PM9/27/23
to weewx...@googlegroups.com
See the wiki article, "Cleaning up old 'bad' data".

--
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 weewx-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/E4877119-F905-4817-8395-49FF07473372%40gmail.com.

vince

unread,
Sep 27, 2023, 8:28:24 PM9/27/23
to weewx-user
 https://github.com/weewx/weewx/wiki/Cleaning-up-old-'bad'-data

Lorin Tremblay

unread,
Sep 27, 2023, 10:01:14 PM9/27/23
to weewx...@googlegroups.com

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.



--
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 weewx-user+...@googlegroups.com.

Lorin Tremblay

unread,
Sep 27, 2023, 10:43:38 PM9/27/23
to weewx...@googlegroups.com
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!

Tom Keffer

unread,
Sep 28, 2023, 6:06:59 AM9/28/23
to weewx...@googlegroups.com
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.

To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/60E87BD9-A203-45D7-BF9B-6A1A6E4F7E4A%40gmail.com.
Reply all
Reply to author
Forward
0 new messages