On Sunday, 28 January 2018 09:06:40 UTC+10, Nicolas Cazan wrote: > > > sorry it's in french >
Must be French-lite - I could read it :) Ok, that error indicates either /var/tmp/backup.sdb does not exist or if it does not exist it does not have a table named archive, in either case /var/tmp/backup.sdb is not a copy of your live weeWX database. The wiki entry gives specific comamnds for a number of tasks but only describes making a copy of your weeWX database, what did you do to make the copy? Did you: - stop weeWX using $ sudo systemctl stop weewx - copy your weeWX database using (paths adjusted to suit your install): $ cp /home/weewx/archive/weewx.sdb /var/tmp/backup.sdb - does /var/tmp/backup.sdb exist and is it identical in size to you live weeWX database? Assuming all is OK try the problem command again, if you get the same error let's have a look at what is in /var/tmp/backup.sdb using the following commands: $ sqlite3 /var/tmp/backup.sdb sqlite> .tables This should result in output similar to: archive archive_day_outTemp archive_day_ET archive_day_outTempBatteryStatus archive_day_UV archive_day_pressure archive_day__metadata archive_day_radiation archive_day_altimeter archive_day_rain archive_day_barometer archive_day_rainBatteryStatus archive_day_consBatteryVoltage archive_day_rainRate archive_day_dewpoint archive_day_referenceVoltage archive_day_extraHumid1 archive_day_rxCheckPercent archive_day_extraHumid2 archive_day_soilMoist1 archive_day_extraTemp1 archive_day_soilMoist2 archive_day_extraTemp2 archive_day_soilMoist3 archive_day_extraTemp3 archive_day_soilMoist4 archive_day_hail archive_day_soilTemp1 archive_day_hailRate archive_day_soilTemp2 archive_day_heatindex archive_day_soilTemp3 archive_day_heatingTemp archive_day_soilTemp4 archive_day_heatingVoltage archive_day_supplyVoltage archive_day_inHumidity archive_day_txBatteryStatus archive_day_inTemp archive_day_wind archive_day_inTempBatteryStatus archive_day_windBatteryStatus archive_day_leafTemp1 archive_day_windDir archive_day_leafTemp2 archive_day_windGust archive_day_leafWet1 archive_day_windGustDir archive_day_leafWet2 archive_day_windSpeed archive_day_outHumidity archive_day_windchill sqlite> If you don't see output like this then something is wrong with your database copy. You can exit sqlite3 with the .quit command: sqlite> .quit $ See how you go with the above. Also, if you are using PuTTY you should be able to select text/output on the PuTTY screen (this automatically copies the selected text/output to the clipboard) and paste it into your Google Groups post, much easier for us to read than taking and posting 'picture' of the screen/terminal. Gary -- 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]. For more options, visit https://groups.google.com/d/optout.
