The fix mentioned in that thread fixed the problem... thanks! On Wednesday, November 18, 2020 at 5:59:07 PM UTC-5 tke...@gmail.com wrote:
> See if this thread > <https://groups.google.com/g/weewx-user/c/0d7_nXWin7I/m/fT6sqmaABAAJ> > helps. > > On Wed, Nov 18, 2020 at 2:52 PM GCC Observatory <gccobse...@gmail.com> > wrote: > >> ah... that makes more sense... >> >> here's the output - I don't notice anything out of the norm: >> >> >> CREATE TABLE archive (`dateTime` INTEGER NOT NULL UNIQUE PRIMARY KEY, >> `usUnits` INTEGER NOT NULL, `interval` INTEGER NOT NULL, `barometer` REAL, >> `pressure` REAL, `altimeter` REAL, `inTemp` REAL, `outTemp` REAL, >> `inHumidity` REAL, `outHumidity` REAL, `windSpeed` REAL, `windDir` REAL, >> `windGust` REAL, `windGustDir` REAL, `rainRate` REAL, `rain` REAL, >> `dewpoint` REAL, `windchill` REAL, `heatindex` REAL, `ET` REAL, `radiation` >> REAL, `UV` REAL, `extraTemp1` REAL, `extraTemp2` REAL, `extraTemp3` REAL, >> `soilTemp1` REAL, `soilTemp2` REAL, `soilTemp3` REAL, `soilTemp4` REAL, >> `leafTemp1` REAL, `leafTemp2` REAL, `extraHumid1` REAL, `extraHumid2` REAL, >> `soilMoist1` REAL, `soilMoist2` REAL, `soilMoist3` REAL, `soilMoist4` REAL, >> `leafWet1` REAL, `leafWet2` REAL, `rxCheckPercent` REAL, `txBatteryStatus` >> REAL, `consBatteryVoltage` REAL, `hail` REAL, `hailRate` REAL, >> `heatingTemp` REAL, `heatingVoltage` REAL, `supplyVoltage` REAL, >> `referenceVoltage` REAL, `windBatteryStatus` REAL, `rainBatteryStatus` >> REAL, `outTempBatteryStatus` REAL, `inTempBatteryStatus` REAL, `appTemp` >> REAL, `windrun` REAL, `cloudbase` REAL, `owTemp0` REAL, `owTemp1` REAL, >> `owTemp2` REAL); >> CREATE TABLE archive_day_barometer (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_pressure (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_altimeter (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_inTemp (dateTime INTEGER NOT NULL UNIQUE PRIMARY >> KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count >> INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_outTemp (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_inHumidity (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_outHumidity (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_windSpeed (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_windDir (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_windGust (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_windGustDir (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_rainRate (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_rain (dateTime INTEGER NOT NULL UNIQUE PRIMARY >> KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count >> INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_dewpoint (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_windchill (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_heatindex (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_ET (dateTime INTEGER NOT NULL UNIQUE PRIMARY >> KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count >> INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_radiation (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_UV (dateTime INTEGER NOT NULL UNIQUE PRIMARY >> KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count >> INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_extraTemp1 (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_extraTemp2 (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_extraTemp3 (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_soilTemp1 (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_soilTemp2 (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_soilTemp3 (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_soilTemp4 (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_leafTemp1 (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_leafTemp2 (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_extraHumid1 (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_extraHumid2 (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_soilMoist1 (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_soilMoist2 (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_soilMoist3 (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_soilMoist4 (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_leafWet1 (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_leafWet2 (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_rxCheckPercent (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_txBatteryStatus (dateTime INTEGER NOT NULL >> UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, >> sum REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_consBatteryVoltage (dateTime INTEGER NOT NULL >> UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, >> sum REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_hail (dateTime INTEGER NOT NULL UNIQUE PRIMARY >> KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count >> INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_hailRate (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_heatingTemp (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_heatingVoltage (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_supplyVoltage (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_referenceVoltage (dateTime INTEGER NOT NULL >> UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, >> sum REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_windBatteryStatus (dateTime INTEGER NOT NULL >> UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, >> sum REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_rainBatteryStatus (dateTime INTEGER NOT NULL >> UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, >> sum REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_outTempBatteryStatus (dateTime INTEGER NOT NULL >> UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, >> sum REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_inTempBatteryStatus (dateTime INTEGER NOT NULL >> UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, >> sum REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_appTemp (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_windrun (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_cloudbase (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_owTemp0 (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_owTemp1 (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day_owTemp2 (dateTime INTEGER NOT NULL UNIQUE >> PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum >> REAL, count INTEGER, wsum REAL, sumtime INTEGER); >> CREATE TABLE archive_day__metadata (name CHAR(20) NOT NULL UNIQUE PRIMARY >> KEY, value TEXT); >> >> >> On Wednesday, November 18, 2020 at 5:48:17 PM UTC-5 jo...@johnkline.com >> wrote: >> >>> There should be an echo in front of that .schema. >>> Also, you don’t need the sudo. >>> >>> echo .schema | sqlite3 /var/lib/weewx/weewx.sdb >>> >>> On Nov 18, 2020, at 2:44 PM, GCC Observatory <gccobse...@gmail.com> >>> wrote: >>> >>> I'm not aware of the ".schema" command you mention... >>> >>> >>> >>> On Wednesday, November 18, 2020 at 5:19:31 PM UTC-5 vince wrote: >>> >>>> Try "*.schema | sudo sqlite3 /var/lib/weewx/weewx.sdb*" and see if you >>>> get all the various tables that are expected there, if I recall the path >>>> to >>>> the database correctly there.... >>>> >>>> On Wednesday, November 18, 2020 at 1:09:50 PM UTC-8 >>>> gccobse...@gmail.com wrote: >>>> >>>>> I thought so too, but I redropped and rebuilt the dailies and still >>>>> the same... >>>>> >>>>> >>>>> On Wednesday, November 18, 2020 at 4:01:13 PM UTC-5 vince wrote: >>>>> >>>>>> The lack of the archive_day_wind table tells me perhaps your >>>>>> --rebuild-daily didn't complete >>>>>> >>>>>> -- >>> 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/55fd7f56-4db8-4934-af38-3767382f8c66n%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/weewx-user/55fd7f56-4db8-4934-af38-3767382f8c66n%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 weewx-user+...@googlegroups.com. >> > To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/6c33df06-3a11-4373-a37d-cee76f572e89n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/6c33df06-3a11-4373-a37d-cee76f572e89n%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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/ee8608df-b842-46a7-b386-9f1321e9d363n%40googlegroups.com.
