Hi, I am using a "fine offset" type weather station which as with most of these occasionally throws a wobbly and gives me some ridiculous spikes, something I just have to live with. I go into the database editing and delete the affected lines, no problem. However I have noticed recently when doing this that every hour(whether there is a spike or not) there is a line of data on the hour e.g. 08:00:00 followed by a second line of the same data at , for example, 08:00:30. Now if there is a spike on the hour then deleting that line also deletes the hour +30 second line. It doesn't appear to affect anything, I just don't thing the second line should be there.
I do have WD sending a tweet to twitter on the hour but have tried turning that off as I thought that may cause the issue but that made no difference.
Any thoughts?
Strange data line in database
- MonyMony
- Forecaster

- Posts: 192
- Joined: Sun Aug 20, 2017 12:54 pm
- Location: Elkton, Maryland, US
- Station model: Davis Pro 2
- Software: WeatherCat/Meteobridge
- Contact:
Re: Strange data line in database
Hum... besides saying 'that's weird', I'm having a hard time coming up a scenario that would cause this. Meteotemplate should only write to the database every few minutes based off of a cache of data received from the API uploads. My only guess is to check to see if you have any custom scheduled jobs (like a cron job) that might be triggering the database upload but I'm not even sure what to suggest to look for.
- magical46
- Observer

- Posts: 49
- Joined: Mon Aug 21, 2017 2:19 pm
- Location: Farnham, Surrey, UK
- Contact:
Re: Strange data line in database
I have WD uploading to twitter every hour, thought that maybe it but I tried switching that off but still got the "spurious" data line
- Jolumarali
- Professional

- Posts: 251
- Joined: Sun Aug 20, 2017 2:06 pm
- Location: Lignerolles
- Station model: Vantage Vue
- Software: WlIP
- Contact:
Re: Strange data line in database
hello
Personally for Twitter I send every hour with Weathercloud.com
José Luis
Personally for Twitter I send every hour with Weathercloud.com
José Luis
Station météo amateur Lignerolles
OS : Windows 11 Famille
Vantage Vue
Weatherlink 2.0 (WlIP)
Meteotemplate 18.0 Papaya
https://meteo-lignerolles.fr
José Luis
-
andyk1
- Professional

- Posts: 433
- Joined: Tue Feb 27, 2018 10:56 pm
- Location: OKLAHOMA, USA
- Station model: Ecowitt WS90
- Software: Meteobridge/GW2000B
- Contact:
Re: Strange data line in database
Check to make sure you are only updating once. One cron job... etc. Not sure how you have your system setup or how you are feeding your data... Meteobridge or Ecowitt etc.
Strangely, the first time I replied to it didn't work.
Strangely, the first time I replied to it didn't work.