[weewx-user] Re: time/date issue in my INDEX.HTML file

2019-07-09 Thread Eric Gammeter
Operation is back to normal!  All I see is I am missing daily data from 
July 1 thru 7...but I can live with that for sure.  Thanks so much for your 
assistance guys.  
/Eric 



On Friday, July 5, 2019 at 3:58:01 PM UTC-4, Eric Gammeter wrote:
>
> Hi-  My INDEX.HTML file is being produced each half hour as it should 
> be...but the timestamp (in the file) is incorrect!  The report (attached) 
> shows it is 8/6/2036 @ 08:22:00PM.  
>
> I can see that the reports fire off every 30 mins- and that a new (correct 
> time stamp) INDEX.HTML file is created in the /var/www/html/weewx 
> filesystem-- but that file's info is incorrect.  
>
> I tested (with minicom) and that TEST's fine.
>
> I have shutdown and rebooted the VantageVue station to no avail.  
>
> Thanks for reading!  
>
> /Eric 
>

-- 
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/f57f3580-18f5-420a-84cb-f04a7096319c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[weewx-user] Re: time/date issue in my INDEX.HTML file

2019-07-08 Thread Eric Gammeter
Thank you Tom!  That cleared-up the log error I was getting.  So far the 
timestamp on my index.html report shows 7/1/2019- but that is much better 
than what I was getting before.  I will let it run for a while to see how 
it shakes-out.  Your utilities are fantastic!
/Eric




On Friday, July 5, 2019 at 3:58:01 PM UTC-4, Eric Gammeter wrote:
>
> Hi-  My INDEX.HTML file is being produced each half hour as it should 
> be...but the timestamp (in the file) is incorrect!  The report (attached) 
> shows it is 8/6/2036 @ 08:22:00PM.  
>
> I can see that the reports fire off every 30 mins- and that a new (correct 
> time stamp) INDEX.HTML file is created in the /var/www/html/weewx 
> filesystem-- but that file's info is incorrect.  
>
> I tested (with minicom) and that TEST's fine.
>
> I have shutdown and rebooted the VantageVue station to no avail.  
>
> Thanks for reading!  
>
> /Eric 
>

-- 
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/6d87b4ed-1872-4b4a-90c5-e5150ec2cbb8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [weewx-user] Re: time/date issue in my INDEX.HTML file

2019-07-08 Thread Thomas Keffer
While Andrew offers helpful information on how to delete records from your
archive, I would NOT start there. Most likely, your data are fine. Just
drop, then rebuild, the daily summaries. Then run weewx. If all is good,
you're done. Otherwise, we'll take on the more complicated stuff.

On Mon, Jul 8, 2019 at 6:26 AM Andrew Milner 
wrote:

> do you use phpliteadmin to browse the database or do you just retrieve
> records using sqlite3?
>
> only you can determine the datetime of the last good archive record - let
> us say it is 987654321
>
> then to delete all records later than that
> use sqlite 3
> delete from archive where dateTime > 987654321;
> would delete additional archive records
>
> then to sort out the daily summaries use wee_database to
> 1) drop daily
> 2) rebuild daily
>
> if your NOAA summary data is looking corrupted just delete the NOAA files
> and weewx will recreate them on the next report cycle.
>
>
> On Monday, 8 July 2019 16:08:40 UTC+3, Eric Gammeter wrote:
>>
>> Still at this...  Is there any way to determine the last-good db record
>> and then delete everything after that in order to salvage my WX year
>> history?
>>
>>
>> root@raspberrypi:/var/lib/weewx# /etc/init.d/weewx status
>> ● weewx.service - LSB: weewx weather system
>>Loaded: loaded (/etc/init.d/weewx; generated; vendor preset: enabled)
>>Active: active (exited) since Mon 2019-07-08 08:52:59 EDT; 10min ago
>>  Docs: man:systemd-sysv-generator(8)
>>   Process: 2872 ExecStop=/etc/init.d/weewx stop (code=exited,
>> status=0/SUCCESS)
>>   Process: 3049 ExecStart=/etc/init.d/weewx start (code=exited,
>> status=0/SUCCESS)
>>
>> Jul 08 08:53:00 raspberrypi weewx[3064]: File
>> "/usr/share/weewx/weewx/engine.py", line 142, in loadServices
>> Jul 08 08:53:00 raspberrypi weewx[3064]: 
>> self.service_obj.append(weeutil.weeutil._get_object(svc)(self, config_dict))
>> Jul 08 08:53:00 raspberrypi weewx[3064]: File
>> "/usr/share/weewx/weewx/engine.py", line 500, in __init__
>> Jul 08 08:53:00 raspberrypi weewx[3064]: 
>> self.setup_database(config_dict)
>> Jul 08 08:53:00 raspberrypi weewx[3064]: File
>> "/usr/share/weewx/weewx/engine.py", line 617, in setup_database
>> Jul 08 08:53:00 raspberrypi weewx[3064]:   _nrecs, _ndays =
>> dbmanager.backfill_day_summary() # @UnusedVariable
>> Jul 08 08:53:00 raspberrypi weewx[3064]: File
>> "/usr/share/weewx/weewx/manager.py", line 1447, in backfill_day_summary
>> Jul 08 08:53:00 raspberrypi weewx[3064]: 
>> timestamp_to_string(lastRecord)))
>> Jul 08 08:53:00 raspberrypi weewx[3064]:   ViolatedPrecondition:
>> lastUpdate(2036-08-06 20:22:00 EDT (2101681320)) > lastRecord(2019-07-01
>> 00:00:00 EDT (1561953600))
>> Jul 08 08:53:00 raspberrypi weewx[3064]:   Exiting.
>> root@raspberrypi:/var/lib/weewx#
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On Friday, July 5, 2019 at 3:58:01 PM UTC-4, Eric Gammeter wrote:
>>>
>>> Hi-  My INDEX.HTML file is being produced each half hour as it should
>>> be...but the timestamp (in the file) is incorrect!  The report (attached)
>>> shows it is 8/6/2036 @ 08:22:00PM.
>>>
>>> I can see that the reports fire off every 30 mins- and that a new
>>> (correct time stamp) INDEX.HTML file is created in the /var/www/html/weewx
>>> filesystem-- but that file's info is incorrect.
>>>
>>> I tested (with minicom) and that TEST's fine.
>>>
>>> I have shutdown and rebooted the VantageVue station to no avail.
>>>
>>> Thanks for reading!
>>>
>>> /Eric
>>>
>> --
> 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/c8efbf47-494f-4286-b926-ef573eb4a140%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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/CAPq0zED74Y3zETH1qiJAxfCojY2WeiS1XcUjRn7mVX-_-Z2fYQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


[weewx-user] Re: time/date issue in my INDEX.HTML file

2019-07-08 Thread Andrew Milner
do you use phpliteadmin to browse the database or do you just retrieve 
records using sqlite3?

only you can determine the datetime of the last good archive record - let 
us say it is 987654321

then to delete all records later than that
use sqlite 3
delete from archive where dateTime > 987654321; 
would delete additional archive records

then to sort out the daily summaries use wee_database to 
1) drop daily
2) rebuild daily

if your NOAA summary data is looking corrupted just delete the NOAA files 
and weewx will recreate them on the next report cycle.


On Monday, 8 July 2019 16:08:40 UTC+3, Eric Gammeter wrote:
>
> Still at this...  Is there any way to determine the last-good db record 
> and then delete everything after that in order to salvage my WX year 
> history?
>
>
> root@raspberrypi:/var/lib/weewx# /etc/init.d/weewx status
> ● weewx.service - LSB: weewx weather system
>Loaded: loaded (/etc/init.d/weewx; generated; vendor preset: enabled)
>Active: active (exited) since Mon 2019-07-08 08:52:59 EDT; 10min ago
>  Docs: man:systemd-sysv-generator(8)
>   Process: 2872 ExecStop=/etc/init.d/weewx stop (code=exited, 
> status=0/SUCCESS)
>   Process: 3049 ExecStart=/etc/init.d/weewx start (code=exited, 
> status=0/SUCCESS)
>
> Jul 08 08:53:00 raspberrypi weewx[3064]: File 
> "/usr/share/weewx/weewx/engine.py", line 142, in loadServices
> Jul 08 08:53:00 raspberrypi weewx[3064]:   
> self.service_obj.append(weeutil.weeutil._get_object(svc)(self, config_dict))
> Jul 08 08:53:00 raspberrypi weewx[3064]: File 
> "/usr/share/weewx/weewx/engine.py", line 500, in __init__
> Jul 08 08:53:00 raspberrypi weewx[3064]:   
> self.setup_database(config_dict)
> Jul 08 08:53:00 raspberrypi weewx[3064]: File 
> "/usr/share/weewx/weewx/engine.py", line 617, in setup_database
> Jul 08 08:53:00 raspberrypi weewx[3064]:   _nrecs, _ndays = 
> dbmanager.backfill_day_summary() # @UnusedVariable
> Jul 08 08:53:00 raspberrypi weewx[3064]: File 
> "/usr/share/weewx/weewx/manager.py", line 1447, in backfill_day_summary
> Jul 08 08:53:00 raspberrypi weewx[3064]:   
> timestamp_to_string(lastRecord)))
> Jul 08 08:53:00 raspberrypi weewx[3064]:   ViolatedPrecondition: 
> lastUpdate(2036-08-06 20:22:00 EDT (2101681320)) > lastRecord(2019-07-01 
> 00:00:00 EDT (1561953600))
> Jul 08 08:53:00 raspberrypi weewx[3064]:   Exiting.
> root@raspberrypi:/var/lib/weewx# 
>
>
>
>
>
>
>
>
>
>
> On Friday, July 5, 2019 at 3:58:01 PM UTC-4, Eric Gammeter wrote:
>>
>> Hi-  My INDEX.HTML file is being produced each half hour as it should 
>> be...but the timestamp (in the file) is incorrect!  The report (attached) 
>> shows it is 8/6/2036 @ 08:22:00PM.  
>>
>> I can see that the reports fire off every 30 mins- and that a new 
>> (correct time stamp) INDEX.HTML file is created in the /var/www/html/weewx 
>> filesystem-- but that file's info is incorrect.  
>>
>> I tested (with minicom) and that TEST's fine.
>>
>> I have shutdown and rebooted the VantageVue station to no avail.  
>>
>> Thanks for reading!  
>>
>> /Eric 
>>
>

-- 
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/c8efbf47-494f-4286-b926-ef573eb4a140%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [weewx-user] Re: time/date issue in my INDEX.HTML file

2019-07-08 Thread Thomas Keffer
I'm lost where you are in the process. Let's take it from the top:

1. Stop weewx

*sudo systemctl stop weewx*


2. Clear the memory of your logger

*sudo wee_device --clear-memory*


3. Delete the daily summaries. Normally this step isn't necessary, but
yours seems to have gotten messed up somehow.

*sudo wee_database --drop-daily*


4. Rebuild the daily summaries. Depending on the size of your database,
this could take a little time.

*sudo wee_database --rebuild-daily*


5. Restart weewx

*sudo systemctl start weewx*


-tk

On Mon, Jul 8, 2019 at 6:08 AM Eric Gammeter  wrote:

> Still at this...  Is there any way to determine the last-good db record
> and then delete everything after that in order to salvage my WX year
> history?
>
>
> root@raspberrypi:/var/lib/weewx# /etc/init.d/weewx status
> ● weewx.service - LSB: weewx weather system
>Loaded: loaded (/etc/init.d/weewx; generated; vendor preset: enabled)
>Active: active (exited) since Mon 2019-07-08 08:52:59 EDT; 10min ago
>  Docs: man:systemd-sysv-generator(8)
>   Process: 2872 ExecStop=/etc/init.d/weewx stop (code=exited,
> status=0/SUCCESS)
>   Process: 3049 ExecStart=/etc/init.d/weewx start (code=exited,
> status=0/SUCCESS)
>
> Jul 08 08:53:00 raspberrypi weewx[3064]: File
> "/usr/share/weewx/weewx/engine.py", line 142, in loadServices
> Jul 08 08:53:00 raspberrypi weewx[3064]: 
> self.service_obj.append(weeutil.weeutil._get_object(svc)(self, config_dict))
> Jul 08 08:53:00 raspberrypi weewx[3064]: File
> "/usr/share/weewx/weewx/engine.py", line 500, in __init__
> Jul 08 08:53:00 raspberrypi weewx[3064]: 
> self.setup_database(config_dict)
> Jul 08 08:53:00 raspberrypi weewx[3064]: File
> "/usr/share/weewx/weewx/engine.py", line 617, in setup_database
> Jul 08 08:53:00 raspberrypi weewx[3064]:   _nrecs, _ndays =
> dbmanager.backfill_day_summary() # @UnusedVariable
> Jul 08 08:53:00 raspberrypi weewx[3064]: File
> "/usr/share/weewx/weewx/manager.py", line 1447, in backfill_day_summary
> Jul 08 08:53:00 raspberrypi weewx[3064]: 
> timestamp_to_string(lastRecord)))
> Jul 08 08:53:00 raspberrypi weewx[3064]:   ViolatedPrecondition:
> lastUpdate(2036-08-06 20:22:00 EDT (2101681320)) > lastRecord(2019-07-01
> 00:00:00 EDT (1561953600))
> Jul 08 08:53:00 raspberrypi weewx[3064]:   Exiting.
> root@raspberrypi:/var/lib/weewx#
>
>
>
>
>
>
>
>
>
>
> On Friday, July 5, 2019 at 3:58:01 PM UTC-4, Eric Gammeter wrote:
>>
>> Hi-  My INDEX.HTML file is being produced each half hour as it should
>> be...but the timestamp (in the file) is incorrect!  The report (attached)
>> shows it is 8/6/2036 @ 08:22:00PM.
>>
>> I can see that the reports fire off every 30 mins- and that a new
>> (correct time stamp) INDEX.HTML file is created in the /var/www/html/weewx
>> filesystem-- but that file's info is incorrect.
>>
>> I tested (with minicom) and that TEST's fine.
>>
>> I have shutdown and rebooted the VantageVue station to no avail.
>>
>> Thanks for reading!
>>
>> /Eric
>>
> --
> 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/8cfcd9af-70cc-4f05-8af2-cb4633c921a3%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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/CAPq0zEA19kszLAGPPjNSEgK7Cn71QZc3qMvMj4gmhNNcCyT2Mw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


[weewx-user] Re: time/date issue in my INDEX.HTML file

2019-07-08 Thread Eric Gammeter
Still at this...  Is there any way to determine the last-good db record and 
then delete everything after that in order to salvage my WX year history?


root@raspberrypi:/var/lib/weewx# /etc/init.d/weewx status
● weewx.service - LSB: weewx weather system
   Loaded: loaded (/etc/init.d/weewx; generated; vendor preset: enabled)
   Active: active (exited) since Mon 2019-07-08 08:52:59 EDT; 10min ago
 Docs: man:systemd-sysv-generator(8)
  Process: 2872 ExecStop=/etc/init.d/weewx stop (code=exited, 
status=0/SUCCESS)
  Process: 3049 ExecStart=/etc/init.d/weewx start (code=exited, 
status=0/SUCCESS)

Jul 08 08:53:00 raspberrypi weewx[3064]: File 
"/usr/share/weewx/weewx/engine.py", line 142, in loadServices
Jul 08 08:53:00 raspberrypi weewx[3064]:   
self.service_obj.append(weeutil.weeutil._get_object(svc)(self, config_dict))
Jul 08 08:53:00 raspberrypi weewx[3064]: File 
"/usr/share/weewx/weewx/engine.py", line 500, in __init__
Jul 08 08:53:00 raspberrypi weewx[3064]:   
self.setup_database(config_dict)
Jul 08 08:53:00 raspberrypi weewx[3064]: File 
"/usr/share/weewx/weewx/engine.py", line 617, in setup_database
Jul 08 08:53:00 raspberrypi weewx[3064]:   _nrecs, _ndays = 
dbmanager.backfill_day_summary() # @UnusedVariable
Jul 08 08:53:00 raspberrypi weewx[3064]: File 
"/usr/share/weewx/weewx/manager.py", line 1447, in backfill_day_summary
Jul 08 08:53:00 raspberrypi weewx[3064]:   
timestamp_to_string(lastRecord)))
Jul 08 08:53:00 raspberrypi weewx[3064]:   ViolatedPrecondition: 
lastUpdate(2036-08-06 20:22:00 EDT (2101681320)) > lastRecord(2019-07-01 
00:00:00 EDT (1561953600))
Jul 08 08:53:00 raspberrypi weewx[3064]:   Exiting.
root@raspberrypi:/var/lib/weewx# 










On Friday, July 5, 2019 at 3:58:01 PM UTC-4, Eric Gammeter wrote:
>
> Hi-  My INDEX.HTML file is being produced each half hour as it should 
> be...but the timestamp (in the file) is incorrect!  The report (attached) 
> shows it is 8/6/2036 @ 08:22:00PM.  
>
> I can see that the reports fire off every 30 mins- and that a new (correct 
> time stamp) INDEX.HTML file is created in the /var/www/html/weewx 
> filesystem-- but that file's info is incorrect.  
>
> I tested (with minicom) and that TEST's fine.
>
> I have shutdown and rebooted the VantageVue station to no avail.  
>
> Thanks for reading!  
>
> /Eric 
>

-- 
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/8cfcd9af-70cc-4f05-8af2-cb4633c921a3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [weewx-user] Re: time/date issue in my INDEX.HTML file

2019-07-07 Thread Thomas Keffer
I was referring to running wee_device (not sqlite3).

Stop weewxd, then clear the memory.

Then restart weewxd.

-tk

On Sun, Jul 7, 2019 at 5:08 AM Eric Gammeter  wrote:

>
> No joy-  It is stopped.
>
> pi@raspberrypi:/var/lib/weewx $ sqlite3 /var/lib/weewx/weewx.sdb
> SQLite version 3.16.2 2017-01-06 16:32:41
> Enter ".help" for usage hints.
> sqlite> delete from archive where dateTime > x;
> Error: no such column: x
> sqlite>
>
>
>
>
>
>
>
> On Friday, July 5, 2019 at 3:58:01 PM UTC-4, Eric Gammeter wrote:
>>
>> Hi-  My INDEX.HTML file is being produced each half hour as it should
>> be...but the timestamp (in the file) is incorrect!  The report (attached)
>> shows it is 8/6/2036 @ 08:22:00PM.
>>
>> I can see that the reports fire off every 30 mins- and that a new
>> (correct time stamp) INDEX.HTML file is created in the /var/www/html/weewx
>> filesystem-- but that file's info is incorrect.
>>
>> I tested (with minicom) and that TEST's fine.
>>
>> I have shutdown and rebooted the VantageVue station to no avail.
>>
>> Thanks for reading!
>>
>> /Eric
>>
> --
> 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/1965823f-b442-45cd-a875-84974d65bec2%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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/CAPq0zECAeoNTmGtjg%2B2tOGuzJ_FtN%3DQVMtQq-nDnK1JaUFKaBA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


[weewx-user] Re: time/date issue in my INDEX.HTML file

2019-07-07 Thread Andrew Milner
you need to replace x with an actual epoch date time value!

so, for example:
delete from archive where dateTime > 1561983540;

to convert a date / time into an epoch date use a site such as:  
https://www.freeformatter.com/epoch-timestamp-to-date-converter.html



On Sunday, 7 July 2019 15:08:15 UTC+3, Eric Gammeter wrote:

>
> No joy-  It is stopped.  
>
> pi@raspberrypi:/var/lib/weewx $ sqlite3 /var/lib/weewx/weewx.sdb
> SQLite version 3.16.2 2017-01-06 16:32:41
> Enter ".help" for usage hints.
> sqlite> delete from archive where dateTime > x;
> Error: no such column: x
> sqlite> 
>
>
>
>
>
>
>
> On Friday, July 5, 2019 at 3:58:01 PM UTC-4, Eric Gammeter wrote:
>>
>> Hi-  My INDEX.HTML file is being produced each half hour as it should 
>> be...but the timestamp (in the file) is incorrect!  The report (attached) 
>> shows it is 8/6/2036 @ 08:22:00PM.  
>>
>> I can see that the reports fire off every 30 mins- and that a new 
>> (correct time stamp) INDEX.HTML file is created in the /var/www/html/weewx 
>> filesystem-- but that file's info is incorrect.  
>>
>> I tested (with minicom) and that TEST's fine.
>>
>> I have shutdown and rebooted the VantageVue station to no avail.  
>>
>> Thanks for reading!  
>>
>> /Eric 
>>
>

-- 
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/cb6da8fc-c972-4d41-a48e-5aee0ceab63c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[weewx-user] Re: time/date issue in my INDEX.HTML file

2019-07-07 Thread Eric Gammeter

No joy-  It is stopped.  

pi@raspberrypi:/var/lib/weewx $ sqlite3 /var/lib/weewx/weewx.sdb
SQLite version 3.16.2 2017-01-06 16:32:41
Enter ".help" for usage hints.
sqlite> delete from archive where dateTime > x;
Error: no such column: x
sqlite> 







On Friday, July 5, 2019 at 3:58:01 PM UTC-4, Eric Gammeter wrote:
>
> Hi-  My INDEX.HTML file is being produced each half hour as it should 
> be...but the timestamp (in the file) is incorrect!  The report (attached) 
> shows it is 8/6/2036 @ 08:22:00PM.  
>
> I can see that the reports fire off every 30 mins- and that a new (correct 
> time stamp) INDEX.HTML file is created in the /var/www/html/weewx 
> filesystem-- but that file's info is incorrect.  
>
> I tested (with minicom) and that TEST's fine.
>
> I have shutdown and rebooted the VantageVue station to no avail.  
>
> Thanks for reading!  
>
> /Eric 
>

-- 
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/1965823f-b442-45cd-a875-84974d65bec2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[weewx-user] Re: time/date issue in my INDEX.HTML file

2019-07-06 Thread Eric Gammeter
Yes-  I did.

My mistake!  I did not.  Doing that now.  


On Friday, July 5, 2019 at 3:58:01 PM UTC-4, Eric Gammeter wrote:
>
> Hi-  My INDEX.HTML file is being produced each half hour as it should 
> be...but the timestamp (in the file) is incorrect!  The report (attached) 
> shows it is 8/6/2036 @ 08:22:00PM.  
>
> I can see that the reports fire off every 30 mins- and that a new (correct 
> time stamp) INDEX.HTML file is created in the /var/www/html/weewx 
> filesystem-- but that file's info is incorrect.  
>
> I tested (with minicom) and that TEST's fine.
>
> I have shutdown and rebooted the VantageVue station to no avail.  
>
> Thanks for reading!  
>
> /Eric 
>

-- 
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/dd9028ff-8e73-4914-9395-60af0c44cfdb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [weewx-user] Re: time/date issue in my INDEX.HTML file

2019-07-06 Thread Thomas Keffer
Did you stop weewx before running wee_device?

On Sat, Jul 6, 2019 at 1:02 PM Eric Gammeter  wrote:

> Not making any progress Tom:
>
> root@raspberrypi:/var/lib/weewx# ls -l
> total 9084
> -rw-r--r-- 1 root root 4648960 Jul  4 02:30 weewx.sdb
> -rw-r--r-- 1 root root 4648960 Jul  6 15:00 weewx.sdb.backup
> root@raspberrypi:/var/lib/weewx# sqlite3 weewx.sdb
> SQLite version 3.16.2 2017-01-06 16:32:41
> Enter ".help" for usage hints.
> sqlite> delete from archive where dateTime > x;
> Error: no such column: x
> sqlite>
> root@raspberrypi:/var/lib/weewx#
>
>
> root@raspberrypi:/var/lib/weewx# wee_device --clear-memory
> Using configuration file /etc/weewx/weewx.conf
> Using Vantage driver version 3.1.1 (weewx.drivers.vantage)
> Traceback (most recent call last):
>   File "/usr/bin/wee_device", line 66, in 
> main()
>   File "/usr/bin/wee_device", line 62, in main
> device.configure(config_dict)
>   File "/usr/share/weewx/weewx/drivers/__init__.py", line 69, in configure
> self.do_options(options, parser, config_dict, prompt)
>   File "/usr/share/weewx/weewx/drivers/vantage.py", line 1972, in
> do_options
> station = Vantage(**config_dict[DRIVER_NAME])
>   File "/usr/share/weewx/weewx/drivers/vantage.py", line 488, in __init__
> self._setup()
>   File "/usr/share/weewx/weewx/drivers/vantage.py", line 1289, in _setup
> unit_bits  = self._getEEPROM_value(0x29)[0]
>   File "/usr/share/weewx/weewx/drivers/vantage.py", line 1375, in
> _getEEPROM_value
> raise weewx.RetriesExceeded("While getting EEPROM data value at
> address 0x%X" % offset)
> weewx.RetriesExceeded: While getting EEPROM data value at address 0x29
> root@raspberrypi:/var/lib/weewx#
>
>
>
>
>
> On Friday, July 5, 2019 at 3:58:01 PM UTC-4, Eric Gammeter wrote:
>>
>> Hi-  My INDEX.HTML file is being produced each half hour as it should
>> be...but the timestamp (in the file) is incorrect!  The report (attached)
>> shows it is 8/6/2036 @ 08:22:00PM.
>>
>> I can see that the reports fire off every 30 mins- and that a new
>> (correct time stamp) INDEX.HTML file is created in the /var/www/html/weewx
>> filesystem-- but that file's info is incorrect.
>>
>> I tested (with minicom) and that TEST's fine.
>>
>> I have shutdown and rebooted the VantageVue station to no avail.
>>
>> Thanks for reading!
>>
>> /Eric
>>
> --
> 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/60ddaa7f-3668-4787-aa34-32291f09c474%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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/CAPq0zEAGLmL3ujZNBNPfJ5SxuJaFcXX%2B13zCp%3DVnOHqNd%2B0onA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


[weewx-user] Re: time/date issue in my INDEX.HTML file

2019-07-06 Thread Eric Gammeter
Not making any progress Tom:  

root@raspberrypi:/var/lib/weewx# ls -l
total 9084
-rw-r--r-- 1 root root 4648960 Jul  4 02:30 weewx.sdb
-rw-r--r-- 1 root root 4648960 Jul  6 15:00 weewx.sdb.backup
root@raspberrypi:/var/lib/weewx# sqlite3 weewx.sdb
SQLite version 3.16.2 2017-01-06 16:32:41
Enter ".help" for usage hints.
sqlite> delete from archive where dateTime > x;
Error: no such column: x
sqlite> 
root@raspberrypi:/var/lib/weewx# 


root@raspberrypi:/var/lib/weewx# wee_device --clear-memory
Using configuration file /etc/weewx/weewx.conf
Using Vantage driver version 3.1.1 (weewx.drivers.vantage)
Traceback (most recent call last):
  File "/usr/bin/wee_device", line 66, in 
main()
  File "/usr/bin/wee_device", line 62, in main
device.configure(config_dict)
  File "/usr/share/weewx/weewx/drivers/__init__.py", line 69, in configure
self.do_options(options, parser, config_dict, prompt)
  File "/usr/share/weewx/weewx/drivers/vantage.py", line 1972, in do_options
station = Vantage(**config_dict[DRIVER_NAME])
  File "/usr/share/weewx/weewx/drivers/vantage.py", line 488, in __init__
self._setup()
  File "/usr/share/weewx/weewx/drivers/vantage.py", line 1289, in _setup
unit_bits  = self._getEEPROM_value(0x29)[0]
  File "/usr/share/weewx/weewx/drivers/vantage.py", line 1375, in 
_getEEPROM_value
raise weewx.RetriesExceeded("While getting EEPROM data value at address 
0x%X" % offset)
weewx.RetriesExceeded: While getting EEPROM data value at address 0x29
root@raspberrypi:/var/lib/weewx# 





On Friday, July 5, 2019 at 3:58:01 PM UTC-4, Eric Gammeter wrote:
>
> Hi-  My INDEX.HTML file is being produced each half hour as it should 
> be...but the timestamp (in the file) is incorrect!  The report (attached) 
> shows it is 8/6/2036 @ 08:22:00PM.  
>
> I can see that the reports fire off every 30 mins- and that a new (correct 
> time stamp) INDEX.HTML file is created in the /var/www/html/weewx 
> filesystem-- but that file's info is incorrect.  
>
> I tested (with minicom) and that TEST's fine.
>
> I have shutdown and rebooted the VantageVue station to no avail.  
>
> Thanks for reading!  
>
> /Eric 
>

-- 
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/60ddaa7f-3668-4787-aa34-32291f09c474%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.