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.

Reply via email to