Glad it is working for you.
That bit of code was last changed in November, 2014, so it's been that way
for a very long time.
However, it should not be so strict on requiring that the first column be
dateTime. I've filed an issue to remind myself to relax the restriction.
Issue #855
As in fact, Tom, the Datetime field was no longer in 1st position.
I placed it properly while keeping the additional field in 2nd position
and it still did not work, even by placing it in the last position.
I have resolved it to delete it and it seems to leave, in any case, no
error message.
I have no idea what I'm looking at there.
The requirements for the database are:
1. The first column must be dateTime.
2. The value for dateTime must never be null.
Does your database satisfy these two requirements?
On Fri, Mar 10, 2023 at 9:57 AM Blaise Cacramp
wrote:
> The base is
The base is connected with MS-ACCESS (one of my specialties) and I
exploit some data for my energy management (I was 0also energy manager)
# -*- coding: utf-8 -*-
import mysql.connector
from datetime import datetime, timedelta
# script éxécuté une fois par jour (à 00:07:30 ?)
# version du
Yes, I added a few columns that I update daily. So far, this was not a
problem
CREATE TABLE archive (`dateTime` INTEGER NOT NULL UNIQUE PRIMARY KEY,
`usUnits` INTEGER NOT NULL, `interval` INTEGER NOT NULL, `altimeter`
REAL, `appTemp` REAL, `appTemp1` REAL, `barometer` REAL,
`batteryStatus1`
Hmmm, you may have a non-standard schema.
Try this:
*sqlite3 /var/lib/weewx/weewx.sdb*
sqlite> *.schema*
sqlite> *.quit*
On Fri, Mar 10, 2023 at 5:34 AM Blaise Cacramp
wrote:
> Ok, not null values
> Le 10-03-23 à 14:09, Tom Keffer a écrit :
>
> Do you have a null value for dateTime in your
Do you have a null value for dateTime in your database?
Here is how to check.First, make sure you have the tool sqlite3
*sudo apt-get install sqlite3*
Then use it to find null values
*sqlite3 /var/lib/weewx/weewx.sdb*
*sqlite> select dateTime from archive where dateTime isnull;*
*sqlite>
J'ai un autre problème :
Mar 10 13:43:52 PiMeteo weewx[3486]: Stopping weewx weather system: weewx
not running
Mar 10 13:43:52 PiMeteo systemd[1]: weewx.service: Succeeded.
Mar 10 13:43:52 PiMeteo systemd[1]: Stopped LSB: weewx weather system.
Mar 10 13:43:52 PiMeteo systemd[1]: Starting LSB:
Classic case of logger corruption. See the wiki:
https://github.com/weewx/weewx/wiki/Troubleshooting-the-Davis-Vantage-station#corrupt-station-memory
On Fri, Mar 10, 2023 at 12:14 AM PC wrote:
> Hello
> To follow up on the discussion
> https://groups.google.com/u/2/g/weewx-user/c/sl1zgrU0cd0
Hello
To follow up on the discussion
https://groups.google.com/u/2/g/weewx-user/c/sl1zgrU0cd0 below, I applied
the procedure https://forums.raspberrypi.com/viewtopic.php?t=262963#p1608493
Weewx resumed life but with a constant delay not arranging and with a
"hole" of a week from February 28. I
10 matches
Mail list logo