No wind tag after transferring the database

[engolling]

Hello,

due to a hardware failure I lost my original weewx sqlite database.

I had a backup with only the archive table but not the summaries on my SQL webserver. Which I copied back with wee_database ---transfer (according to the tutorial in the documentation).

Everything  seems to work despite that there are no wind tags anymore.

I saw in the documentation that they should be build with the daily summary.

http://www.weewx.com/docs/customizing.htm#Tags

I tried wee_database --calc-missing --update and --rebuilid-daily without success.

Dec 31 12:20:52 WeatherDuinoPI weewx[6736] INFO __main__: Initializing weewx version 4.2.0
Dec 31 12:20:52 WeatherDuinoPI weewx[6736] INFO __main__: Using Python 3.7.3 (default, Jul 25 2020, 13:03:44) #012[GCC 8.3.0]
Dec 31 12:20:52 WeatherDuinoPI weewx[6736] INFO __main__: Platform Linux-5.4.79-v7l+-armv7l-with-debian-10.7
Dec 31 12:20:52 WeatherDuinoPI weewx[6736] INFO __main__: Locale is 'en_US.UTF-8'
Dec 31 12:20:52 WeatherDuinoPI weewx[6736] INFO __main__: PID file is /var/run/weewx.pid
Dec 31 12:20:52 WeatherDuinoPI weewx[6740] INFO __main__: Using configuration file /etc/weewx/weewx.conf
Dec 31 12:20:52 WeatherDuinoPI weewx[6740] INFO __main__: Debug is 1

....

Dec 31 12:30:25 WeatherDuinoPI weewx[6740] ERROR weewx.reportengine: Caught unrecoverable exception in generator 'weewx.imagegenerator.ImageGenerator'
Dec 31 12:30:25 WeatherDuinoPI weewx[6740] ERROR weewx.reportengine:         ****  no such table: archive_day_wind
Dec 31 12:30:25 WeatherDuinoPI weewx[6740] ERROR weewx.reportengine:         ****  Traceback (most recent call last):
Dec 31 12:30:25 WeatherDuinoPI weewx[6740] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weedb/sqlite.py", line 29, in guarded_fn
Dec 31 12:30:25 WeatherDuinoPI weewx[6740] ERROR weewx.reportengine:         ****      return fn(*args, **kwargs)
Dec 31 12:30:25 WeatherDuinoPI weewx[6740] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weedb/sqlite.py", line 211, in execute
Dec 31 12:30:25 WeatherDuinoPI weewx[6740] ERROR weewx.reportengine:         ****      return sqlite3.Cursor.execute(self, *args, **kwargs)
Dec 31 12:30:25 WeatherDuinoPI weewx[6740] ERROR weewx.reportengine:         ****  sqlite3.OperationalError: no such table: archive_day_wind
Dec 31 12:30:25 WeatherDuinoPI weewx[6740] ERROR weewx.reportengine:         ****  
Dec 31 12:30:25 WeatherDuinoPI weewx[6740] ERROR weewx.reportengine:         ****  During handling of the above exception, another exception occurred:
Dec 31 12:30:25 WeatherDuinoPI weewx[6740] ERROR weewx.reportengine:         ****

Do you have an idea how I get the table archive_day_wind recalculated again?

Regards,

engolling

[Tom Keffer]

I suspect you have a configuration problem for the new database. See if this thread helps.

--
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/5ef65d01-89ac-48ab-878a-fdba6613f680n%40googlegroups.com.

[engolling]

Hallo,

thank you for your quick reply and the outstanding support.

Exactly this was my fault. Think I introduced it when playing with the database transfer.

I wish you a happy new year.

Best regards,

engolling