Page 1 of 1
Station off-line
Posted: Fri Mar 30, 2018 11:08 pm
by i_fiorentino
Hi JAchym,
on this site:
http://www.meteoponsacco.it station seems off-line but on current block the station works as it should.
Have you got any idea why station seems off-line?
Thank you so much.
Regards,
Alessandro
Re: Station off-line
Posted: Fri Mar 30, 2018 11:38 pm
by Hugh
Looking at your website this seems to be similar, though not identical, to the problems I am experiencing at
www.flowers-cove.ca
See my posting in this forum entitled "SQL data not working" posted 9 hours ago.
Hugh
Re: Station off-line
Posted: Sat Mar 31, 2018 2:28 am
by BlueBear
Interesting, looks like the last update of your station was on 01.01.1970 01.00 or 48 y 2 m 30 d 3 h 26 min 20 ago!
I know it's no help but sure looks weird!
Re: Station off-line
Posted: Sat Mar 31, 2018 5:59 am
by Jachym
Hi,
no, actually not weird.
Computers count time as the number of seconds since Jan 1, 1970. So it is a very large number right now. What is before that date is negative.
So if there is no data from the database, it will show 0 for everything - except for time because time 0 = 0 seconds since Jan 1, 1970. That is the date you would see.
In this case you need to check that the database is working, that the user permissions for the database are set correctly and that the database is not full.
Re: Station off-line
Posted: Sat Mar 31, 2018 3:23 pm
by i_fiorentino
Hi Jachym,
probably database is corrupted because when i try to open alldata table i've this error:
What can i do?
Thanks in advance.
Regards,
Alessandro
Re: Station off-line
Posted: Sat Mar 31, 2018 4:03 pm
by Jachym
If the database is corrupted you would need to either contact your provider and see if they have a backup or in the unfortunate case it was unrecoverable, delete it and the template will create a new alldata table by clicking the Test connection in main setup