Welcome to the Cumulus Support forum.

Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024

Cumulus MX V4 beta test release 4.0.0 (build 4018) - 28 March 2024

Legacy Cumulus 1 release v1.9.4 (build 1099) - 28 November 2014 (a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)

Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki

Data base stopped updating

Other discussion about creating web sites for Cumulus that doesn't have a specific subforum

Moderator: daj

Post Reply
jimbo51
Posts: 7
Joined: Wed 27 Jan 2016 10:58 am
Weather Station: Aercus3083 with sensors
Operating System: windows 10
Location: HaddenhamEly

Data base stopped updating

Post by jimbo51 »

Hi I use the Meteotemplate on first of march my wife accedently pulled the plug/usb out of my weather station now the data base wont up date it stuck at 20:41:19.of that day. my site is at www.haddenham-weather.co.uk/hadds

thank in advance for any help or advice

Jim
User avatar
PaulMy
Posts: 3777
Joined: Sun 28 Sep 2008 11:54 pm
Weather Station: Davis VP2 Plus 24-Hour FARS
Operating System: Windows8 and Windows10
Location: Komoka, ON Canada
Contact:

Re: Data base stopped updating

Post by PaulMy »

Hi,
Jachym, the meteotemplate author, may not frequent this forum and he is the best to answer and help. However to help diagnose;
Have you tried calling the template's ../update/cumulus.php to do a manual update?
What method are you using to update - cron or other?
I presume you are using the Cumulus realtime.txt data for the update, and is the realtime.txt still being uploaded, or perhaps a path has changed?

Paul
Davis Vantage Pro2+
C1 www.komokaweather.com/komokaweather-ca
MX www.komokaweather.com/cumulusmx/index.htm /index.html /index.php
MX www.komokaweather.com/cumulusmxwll/index.htm /index.html /index.php
MX www. komokaweather.com/cumulusmx4/index.htm

Image
jimbo51
Posts: 7
Joined: Wed 27 Jan 2016 10:58 am
Weather Station: Aercus3083 with sensors
Operating System: windows 10
Location: HaddenhamEly

Re: Data base stopped updating

Post by jimbo51 »

this is from the crone job
Fetched URL
http://www.haddenham-weather.co.uk/hadd ... .php?pass=
Status
200 OK
Response headers

Date: Thu, 03 Mar 2016 23:15:02 GMT
Server: Apache/2.4.18 (Unix)
X-Powered-By: PHP/5.5.32
Transfer-Encoding: chunked
Content-Type: text/html


Latest DB record timestamp detected: 2016-03-01 20:41:19<br>Latest cached timestamp detected: 1970-01-01 01:00:00<br>Smallest interval between uploads to database set to: 300 seconds.<br>Difference between latest db timestamp and cached timestamp: -1456864879 seconds.<br>The difference between last db update and current data is not yet larger than the set interval. Current data is saved into temporary cache.<br>
User avatar
PaulMy
Posts: 3777
Joined: Sun 28 Sep 2008 11:54 pm
Weather Station: Davis VP2 Plus 24-Hour FARS
Operating System: Windows8 and Windows10
Location: Komoka, ON Canada
Contact:

Re: Data base stopped updating

Post by PaulMy »

Again, not an expert in this but will take another stab...

The 300 seconds is what you have set to not let the upload script update the DB until at least 300 seconds since the last update (5 min). Since it seems to have detected a 1970 date/time for current date and a last update 2016-03-01 it is not yet 300 sec. so it won't update. I suspect there is a computer or windows clock or time error somewhere.

You may want to post at http://www.wxforum.net/index.php?topic=26825.0 as Jachym will be sure to see it there and offer better support.

Paul
Davis Vantage Pro2+
C1 www.komokaweather.com/komokaweather-ca
MX www.komokaweather.com/cumulusmx/index.htm /index.html /index.php
MX www.komokaweather.com/cumulusmxwll/index.htm /index.html /index.php
MX www. komokaweather.com/cumulusmx4/index.htm

Image
jimbo51
Posts: 7
Joined: Wed 27 Jan 2016 10:58 am
Weather Station: Aercus3083 with sensors
Operating System: windows 10
Location: HaddenhamEly

Re: Data base stopped updating

Post by jimbo51 »

PaulMy wrote:Again, not an expert in this but will take another stab...

The 300 seconds is what you have set to not let the upload script update the DB until at least 300 seconds since the last update (5 min). Since it seems to have detected a 1970 date/time for current date and a last update 2016-03-01 it is not yet 300 sec. so it won't update. I suspect there is a computer or windows clock or time error somewhere.

You may want to post at http://www.wxforum.net/index.php?topic=26825.0 as Jachym will be sure to see it there and offer better support.

Paul
Cheers Paul
yes the PC clock did stop and I reset it by settings I'll have a look andpost on WXFORUMS
jim
User avatar
mcrossley
Posts: 12695
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Data base stopped updating

Post by mcrossley »

It looks like an arithmetic error to me, it is taking -1456864879 as a positive number. I suspect the PHP may be using a variable type conversion and getting it wrong, hard to tell without seeing the code.
jachym
Posts: 53
Joined: Mon 07 Jan 2013 3:47 pm
Weather Station: WH 1080
Operating System: Win XP
Location: Czech republic

Re: Data base stopped updating

Post by jachym »

Hi, the problem is solved, it was due to privelages, the folder was not writable so nothing was cached producing the error. Now working fine :)
Post Reply