Or, use the tool wee_database. It has a specific option "--check-strings <http://www.weewx.com/docs/utilities.htm#wee_database_utility_check_strings>" for doing this:
*wee_database --check-strings* if you find any, you can use the option --fix-strings to fix them: *wee_database --fix-strings* -tk On Fri, Aug 20, 2021 at 10:50 AM 'Rainer Lang' via weewx-user < [email protected]> wrote: > we had a similar case here in the forum earlier this year: > "After further investigation, it turned out to be due to an errant record > in the DB. The record’s “ET” field was blank; neither NULL nor a valid > float. Not sure how it got there, but using an sqlite editor and setting it > back to NULL did the trick. " > > It would be worth checking the database for such a record using a SQlite > Database browser. A field in the database that is usually filled by weewx > with either a value or NULL but is "empty". > tuvimos un caso similar aquí en el foro a principios de este año: > "Tras una investigación más profunda, resultó ser debido a un registro > erróneo en la base de datos. El campo "ET" del registro estaba en blanco; > ni NULL ni un flotador válido. No estoy seguro de cómo llegó allí, pero > usando un editor de sqlite y poniéndolo de nuevo en NULL hizo el truco. " > > Valdría la pena revisar la base de datos en busca de ese registro > utilizando un navegador de bases de datos SQlite. Un campo en la base de > datos que normalmente es llenado por weewx con un valor o NULL pero que > está "vacío". > > Traducción realizada con la versión gratuita del traductor > www.DeepL.com/Translator > > -------- Forwarded Message -------- > Subject: [weewx-user] Cambio de versión de weewx > Date: Fri, 20 Aug 2021 18:32:02 +0200 > From: Rainer Lang <[email protected]> > <[email protected]> > To: [email protected] > CC: Rainer Lang <[email protected]> <[email protected]> > > ¿puede poner DEBUG = 1 en weewx.conf y enviarnos todo el syslog desde el > inicio de weewx, no sólo un fragmento, por favor? > > Can you please set DEBUG = 1 in weewx.conf and send aus the whole syslog > from the weewx launch on and not only a fragment !? > > algo parecido a lo siguiente ((tendrá un driver) diferente, un mapa de > sensores diferente, etc.) > > something that looks like this (you will have a different driver, a > different sensor map, etc. : > > **************************** example ******************************** > > Aug 20 18:28:43 raspberrypi systemd[1]: Starting LSB: weewx weather > system... > Aug 20 18:28:43 raspberrypi weewx[25009] INFO __main__: Initializing weewx > version 4.5.1 > Aug 20 18:28:44 raspberrypi weewx[25009] INFO __main__: Using Python 3.7.3 > (default, Jan 22 2021, 20:04:44) #012[GCC 8.3.0] > Aug 20 18:28:44 raspberrypi weewx[25009] INFO __main__: Platform > Linux-5.10.52-v7l+-armv7l-with-debian-10.10 > Aug 20 18:28:44 raspberrypi weewx[25009] INFO __main__: Locale is > 'en_US.UTF-8' > Aug 20 18:28:44 raspberrypi weewx[25009] INFO __main__: PID file is > /var/run/weewx.pid > Aug 20 18:28:44 raspberrypi weewx[25013] INFO __main__: Using > configuration file /etc/weewx/weewx.conf > Aug 20 18:28:44 raspberrypi weewx[25013] INFO __main__: Debug is 0 > Aug 20 18:28:44 raspberrypi weewx[25013] INFO weewx.engine: Loading > station type Interceptor (user.interceptor) > Aug 20 18:28:44 raspberrypi weewx[24997]: Starting weewx weather system: > weewx. > Aug 20 18:28:44 raspberrypi systemd[1]: Started LSB: weewx weather system. > Aug 20 18:28:44 raspberrypi weewx[25013] INFO user.interceptor: driver > version is 0.60 > Aug 20 18:28:44 raspberrypi weewx[25013] INFO user.interceptor: device > type: ecowitt-client > Aug 20 18:28:44 raspberrypi weewx[25013] INFO user.interceptor: hardware > name: Froggit WH4000SE/Ecowitt WH2320E > Aug 20 18:28:44 raspberrypi weewx[25013] INFO user.interceptor: mode is > listen > Aug 20 18:28:44 raspberrypi weewx[25013] INFO user.interceptor: listen on > :8000 > Aug 20 18:28:44 raspberrypi weewx[25013] INFO user.interceptor: sensor > map: {'pressure': 'pressure', 'barometer': 'barometer', 'outHumidity': > 'humidity_out', 'inHumidity': 'humidity_in', 'outTemp': 'temperature_out', > 'inTemp': 'temperature_in', 'windSpeed': 'wind_speed', 'windGust': > 'wind_gust', 'windDir': 'wind_dir', 'windGustDir': 'wind_gust_dir', > 'radiation': 'solar_radiation', 'dewpoint': 'dewpoint', 'windchill': > 'windchill', 'rain': 'rain', 'rainRate': 'rain_rate', 'UV': 'uv', > 'txBatteryStatus': 'battery', 'extraTemp1': 'temperature_1', 'extraTemp2': > 'temperature_2', 'extraTemp3': 'temperature_3', 'extraHumid1': > 'humidity_1', 'extraHumid2': 'humidity_2', 'soilTemp1': > 'soil_temperature_1', 'soilTemp2': 'soil_temperature_2', 'soilMoist1': > 'soil_moisture_1', 'soilMoist2': 'soil_moisture_2', 'soilMoist3': > 'soil_moisture_3', 'soilMoist4': 'soil_moisture_4', 'leafWet1': > 'leafwetness_1', 'leafWet2': 'leafwetness_2', 'pm2_5': 'pm2_5', > 'extraTemp4': 'temperature_4', 'extraTemp5': 'temperature_5', 'extraTemp6': > 'temperature_6', 'extraTemp7': 'temperature_7', 'extraTemp8': > 'temperature_8', 'extraHumid3': 'humidity_3', 'extraHumid4': 'humidity_4', > 'extraHumid5': 'humidity_5', 'extraHumid6': 'humidity_6', 'extraHumid7': > 'humidity_7', 'extraHumid8': 'humidity_8', 'soilTemp3': > 'soil_temperature_3', 'soilTemp4': 'soil_temperature_4'} > Aug 20 18:28:44 raspberrypi weewx[25013] INFO weewx.engine: StdConvert > target unit is 0x1 > Aug 20 18:28:44 raspberrypi weewx[25013] INFO weewx.engine: Archive will > use data binding wx_binding > Aug 20 18:28:44 raspberrypi weewx[25013] INFO weewx.engine: Record > generation will be attempted in 'hardware' > Aug 20 18:28:44 raspberrypi weewx[25013] INFO weewx.engine: Using archive > interval of 60 seconds (specified in weewx configuration) > Aug 20 18:28:44 raspberrypi weewx[25013] INFO weewx.restx: > StationRegistry: Station will be registered. > Aug 20 18:28:44 raspberrypi weewx[25013] INFO weewx.restx: Wunderground: > Posting not enabled. > Aug 20 18:28:44 raspberrypi weewx[25013] INFO weewx.restx: PWSweather: > Posting not enabled. > Aug 20 18:28:44 raspberrypi weewx[25013] INFO weewx.restx: CWOP: Posting > not enabled. > Aug 20 18:28:44 raspberrypi weewx[25013] INFO weewx.restx: WOW: Posting > not enabled. > Aug 20 18:28:44 raspberrypi weewx[25013] INFO weewx.restx: AWEKAS: Posting > not enabled. > Aug 20 18:28:44 raspberrypi weewx[25013] INFO __main__: Starting up weewx > version 4.5.1 > Aug 20 18:28:44 raspberrypi weewx[25013] INFO weewx.engine: Using binding > 'wx_binding' to database 'weewx-IC.sdb' > Aug 20 18:28:44 raspberrypi weewx[25013] INFO weewx.manager: Starting > backfill of daily summaries > Aug 20 18:28:44 raspberrypi weewx[25013] INFO weewx.manager: Daily > summaries up to date > Aug 20 18:28:44 raspberrypi weewx[25013] INFO weewx.engine: Starting main > packet loop. > On 20.08.2021 17:56, jose riaño wrote: > > > no señor nada solo que me averió la Rpi y al cargar todo de nuevo y > arrancar me sale eso .... > El viernes, 20 de agosto de 2021 a las 10:26:00 UTC-5, [email protected] > escribió: > >> You did not show very much of the log, so it is difficult to determine >> what happened. >> >> My best guess is that somewhere in your database you have a string where >> you should have a number. >> >> Did you edit the database? >> >> On Fri, Aug 20, 2021 at 8:19 AM jose riaño <[email protected]> wrote: >> >>> al cambiar mi versión o reinstalar se me puso la versión 4.5.1 pero >>> cuando quiero arrancar el sistema me sale esto: >>> >>> Aug 20 10:04:16 raspberrypi weewx[1514] CRITICAL __main__: **** >>> File "/usr/share/weewx/weewx/accum.py", line 495, in add_value >>> Aug 20 10:04:16 raspberrypi weewx[1514] CRITICAL __main__: **** >>> self[obs_type].addHiLo(val, record['dateTime']) >>> Aug 20 10:04:16 raspberrypi weewx[1514] CRITICAL __main__: **** >>> File "/usr/share/weewx/weewx/accum.py", line 168, in addHiLo >>> Aug 20 10:04:16 raspberrypi weewx[1514] CRITICAL __main__: **** >>> val = to_float(val) >>> Aug 20 10:04:16 raspberrypi weewx[1514] CRITICAL __main__: **** >>> File "/usr/share/weewx/weeutil/weeutil.py", line 1276, in to_float >>> Aug 20 10:04:16 raspberrypi weewx[1514] CRITICAL __main__: **** >>> return float(x) if x is not None else None >>> Aug 20 10:04:16 raspberrypi weewx[1514] CRITICAL __main__: **** >>> ValueError: could not convert string to float: >>> Aug 20 10:04:16 raspberrypi weewx[1514] CRITICAL __main__: **** >>> Exiting. >>> >>> >>> no encuentro el error o que debo hacer por favor me ayudan >>> >> -- >>> 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/79fe0a4e-6c0c-43b4-9244-77ed14330e8cn%40googlegroups.com >>> <https://groups.google.com/d/msgid/weewx-user/79fe0a4e-6c0c-43b4-9244-77ed14330e8cn%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/a7abd923-2708-427f-9295-a1df9fc7fb4bn%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/a7abd923-2708-427f-9295-a1df9fc7fb4bn%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/e4abfc5c-f8f9-7c71-2ff4-dc53fd2b6b6b%40gmail.com > <https://groups.google.com/d/msgid/weewx-user/e4abfc5c-f8f9-7c71-2ff4-dc53fd2b6b6b%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/CAPq0zEAWo-ouw%2BOfO9F4hMA9M7RV86OUDUpfkQ_bbqm%3DRkjmOw%40mail.gmail.com.
