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 <gccobservat...@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+unsubscr...@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/CAPq0zEBvD7o%3Dz3jgrne3WGkW4YM%2BS7Qda6Uj11-4UvRgtDJ%3DHQ%40mail.gmail.com.