Topic: Meteotemplate - new free website template

[davidefa]

Maybe your web hosting upgraded the mysql to a newer version that has this option enabled by default

[Bashy]

I am my Web host, it's my own managed server, I think I may have updated mysql sometime in the last 6 months but I don't remember, so let's just say I did, best off that way, mystery solved lol

[Bashy]

Hi folks, I have had earwigs playing seesaw, how would one go about fixing erroneous rain data in the database, well, i know how to do it for each 5 minute as a singular edit but i don't know how to zero the rain from say 01:35 to 08:55, thats one helluva lot of edits. I suppose i could go the nuke option and just delete those times in phpmyadmin, that would prob be easiest option, i was wondering if there is some SQL code that i could use to just nuke the rain from x time to x time, please?

Never mind, due to the script not resetting the day rain on many, many occasions, most of my rain data is just wrong

www.brecklandweather.com

[livefeed]

Any help here would be much appreciated as I'm pulling my hair out!

The display of my webpage is completely messed up. I have updated all the files as mentioned over in the MT thread I've even tried a brand new fresh install, but the page layout using Safari on a Mac or chrome looks a mess (even on a pc). Were is the problem? is it in the database or in the files as like I said with a clean install, I get the same output.

http://www.nitram-media.com/weather
PHP 8.1

I also posted this in the MT forum.

[davidefa]

You have http to https redirection enabled.
Check in the meteotemplate control panel -> main setup that 'Page URL' is set to https://www.nitram-media.com ( note the leading https )

( see n. 1 )
 [ You are not allowed to view attachments ]

[livefeed]

@davidefa thank you for all your work that you do here.
Yes that was the issue and all fixed now.

[Jáchym]

Hi guys,

just to let you know, over the weekend I released a new version. Major change is that the template is now compatible with PHP8.x. There are also some bug fixes and security updates so I highly recommend updating to the most recent 19.0 Cranberry version.

Enjoy

[livefeed]

@Jáchym Installed and working great - thank you!

[Gyvate]

I have two MT installations - one 18.0 (http://meshka.eu/meteo/template) and one upgraded to V. 19.0 (http://rainer-lang.net/meteo/template)  - my test environment.
They are running on different web hosts.
This morning 2023-08-31 00:55 both stopped writing to the database.
They are still showing the current data, but no longer archiving the data.
below a recent apiLog.txt file, which shows imo some weird discrepancies
even though the apiLog.txt file creation timestamp is 2023-08-31 12:02:43 (24h notation), it says in the end

End time for database update based on timestamp of current data: 2023-08-31 11:26:27
Rounded end time for database update: 2023-08-31 11:30:00
Not yet time to update the db, saving new data to cache/apiCache.txt

where can I find a log file for the database connection and database writes etc. ?

any advice is welcome
thanks

Code: [Select]

2023-08-31 12:02:43
INFOS:
Authorized access.
Current date/time: 2023-08-31 12:02:43
api called by http
update U: 1693473987
update T: 16.8
update TMX: 16.8
update TMN: 16.7
update H: 70.0
update P: 1014.5
update W: 1.8
update G: 2.9
update B: 87.0
update R: 0.0
update RR: 0.0
update S: 674.0
update UV: 3.0
update TIN: 24.2
update HIN: 51.0
update T1: 17.7
update H1: 68.0
update T2: 18.9
update H2: 69.0
update T3: 16.6
update H3: 72.0
update T4: 15.9
update H4: 80.0
update SM1: 76
update SM2: 87
update SM3: 72
update SM4: 59
update SM5: 24
update L: 0
update LD: 20
update LT: 1692940487
update PP1: 7.0
update PP2: 4.0
update PP3: 1.0
update PP4: 2
update CO2_1: 345.0
update TS1: -22.7
update TS2: 24.9
update TS3: 7.3
update T5: -22.7
update T6: 24.9
update H6: 67.0
update T7: 7.3
update H7: 44.0
update T8: 16.8
update H8: 70.0
update T9: 14.9
update T10: 35.0
update T11: 16.3
update Station: GW1000A
update FW: V1.7.3
Begin of common part of api script
Start handling live data
Checking if extra sensors should be logged
Extra sensors data to save in db: TIN, HIN, UV, L, LD, LT, T1, H1, TS1, SM1, CO2_1, PP1, T2, H2, TS2, SM2, PP2, T3, H3, TS3, SM3, PP3, T4, H4, SM4, PP4, T5, SM5, T6, H6, T7, H7, T8, H8
add live data: D: 11.3
add live data: DTime: 1693476158
add live data: A: 17.2
add live data: ATime: 1693476158
calculated D: 11.3
calculated A: 16.9
Save meteotemplateLive.txt: {"U":1693473987,"T":16.8,"TMX":16.8,"TMN":16.7,"H":70,"P":1014.5,"W":1.8,"G":2.9,"B":87,"R":0,"RR":0,"S":674,"UV":3,"TIN":24.2,"HIN":51,"T1":17.7,"H1":68,"T2":18.9,"H2":69,"T3":16.6,"H3":72,"T4":15.9,"H4":80,"SM1":76,"SM2":87,"SM3":72,"SM4":59,"SM5":24,"L":0,"LD":20,"LT":1692940487,"PP1":7,"PP2":4,"PP3":1,"PP4":2,"CO2_1":345,"TS1":-22.7,"TS2":24.9,"TS3":7.3,"T5":-22.7,"T6":24.9,"H6":67,"T7":7.3,"H7":44,"T8":16.8,"H8":70,"T9":14.9,"T10":35,"T11":16.3,"Station":"GW1000A","FW":"V1.7.3","UTime":1693476163,"TTime":1693476163,"TMXTime":1693476163,"TMNTime":1693476163,"HTime":1693476163,"PTime":1693476163,"WTime":1693476163,"GTime":1693476163,"BTime":1693476163,"RTime":1693476163,"RRTime":1693476163,"STime":1693476163,"UVTime":1693476163,"TINTime":1693476163,"HINTime":1693476163,"T1Time":1693476163,"H1Time":1693476163,"T2Time":1693476163,"H2Time":1693476163,"T3Time":1693476163,"H3Time":1693476163,"T4Time":1693476163,"H4Time":1693476163,"SM1Time":1693476163,"SM2Time":1693476163,"SM3Time":1693476163,"SM4Time":1693476163,"SM5Time":1693476163,"LTime":1693476163,"LDTime":1693476163,"LTTime":1693476163,"PP1Time":1693476163,"PP2Time":1693476163,"PP3Time":1693476163,"PP4Time":1693476163,"CO2_1Time":1693476163,"TS1Time":1693476163,"TS2Time":1693476163,"TS3Time":1693476163,"T5Time":1693476163,"T6Time":1693476163,"H6Time":1693476163,"T7Time":1693476163,"H7Time":1693476163,"T8Time":1693476163,"H8Time":1693476163,"T9Time":1693476163,"T10Time":1693476163,"T11Time":1693476163,"StationTime":1693476163,"FWTime":1693476163,"D":11.3,"DTime":1693476163,"A":16.9,"ATime":1693476163}
Start data parsing
Parsing date; Server time: 2023-08-31 12:02:43
Validating date: 1693473987 (2023-08-31 11:26:27)
Date is valid; difference with server time is -2176 s
Parsing temperature
Temperature: 16.8 C
Database units: C
Checking temperature is between limits specified in template Main settings.
Minimum temperature limit: -100 C
Maximum temperature limit: 100 C
Temperature is OK and within the allowed limits
Parsing maximum temperature
Max Temperature: 16.8 C
Database units: C
Checking max temperature is between limits specified in template Main settings.
Minimum temperature limit: -100 C
Maximum temperature limit: 100 C
Max Temperature is OK and within the allowed limits
Parsing minimum temperature
Min Temperature: 16.7 C
Database units: C
Checking min temperature is between limits specified in template Main settings.
Minimum temperature limit: -100 C
Maximum temperature limit: 100 C
Min Temperature is OK and within the allowed limits
Parsing humidity
Humidity: 70.0 percent
Checking humidity is between limits specified in template Main settings.
Minimum humidity limit: 0 %
Maximum humidity limit: 100 %
Humidity is OK and within the allowed limits
Parsing wind speed
Wind speed: 1.8 kmh
Database wind speed units: kmh
Checking wind speed is between limits specified in template Main settings.
Minimum wind speed limit: 0 kmh
Maximum wind speed limit: 200 kmh
Wind speed is OK and within the allowed limits
Parsing wind gust
Wind gust: 2.9 kmh
Database wind units: kmh
Checking wind gust is between limits specified in template Main settings.
Minimum wind gust limit: 0 kmh
Maximum wind gust limit: 200 kmh
Wind gust is OK and within the allowed limits
Parsing wind direction
Wind direction: 87.0 degrees
Wind direction is OK and within the allowed limits
Parsing daily cumulative precipitation
Precipitation: 0.0 mm
Database precipitation units: mm
Checking precipitation is between limits specified in template Main settings.
Minimum precipitation limit: 0 mm
Maximum precipitation limit: 200 mm
Precipitation is OK and within the allowed limits
Parsing rain rate
Rain rate: 0.0 mm/h
Database rain units: mm/h
Checking rain rate is between limits specified in template Main settings.
Minimum rain rate limit: 0 mm/h
Maximum rain rate limit: 500 mm/h
Rain rate is OK and within the allowed limits
Parsing solar radiation
Solar radiation: 674.0 w/m2
Checking solar radiation is between limits specified in template Main settings.
Minimum solar radiation limit: 0 W/m2
Maximum solar radiation limit: 2000 W/m2
Solar radiation is OK and within the allowed limits
Now parsing extra sensors.
Sensor indoor temperature raw value: 24.2 deg C
Limits for this sensor: 1 to 50
Sensor data within acceptable limits.
Sensor indoor humidity raw value: 51.0 %
Limits for this sensor: 0.01 to 100
Sensor data within acceptable limits.
Sensor UV raw value: 3.0
Limits for this sensor: 0 to 20
Sensor data within acceptable limits.
Sensor lightning raw value: 0
Limits for this sensor: 0 to 1000
Sensor data within acceptable limits.
Sensor lightning distance raw value: 20
Limits for this sensor: 0 to 100
Sensor data within acceptable limits.
Sensor lightning time raw value: 1692940487
Limits for this sensor: 0 to 10000000000
Sensor data within acceptable limits.
Sensor extra temperature sensor 1 raw value: 17.7 deg C
Limits for this sensor: -60 to 60
Sensor data within acceptable limits.
Sensor extra humidity sensor 1 raw value: 68.0 %
Limits for this sensor: 0.01 to 100
Sensor data within acceptable limits.
Sensor soil temperature sensor 1 raw value: -22.7 deg C
Limits for this sensor: -60 to 80
Sensor data within acceptable limits.
Sensor soil moisture sensor 1 raw value: 76
Limits for this sensor: 0 to 200
Sensor data within acceptable limits.
Sensor CO2 sensor 1 raw value: 345.0 ppm
Limits for this sensor: 300 to 600
Sensor data within acceptable limits.
Sensor particulate pollution 1 raw value: 7.0 ug/m3
Limits for this sensor: 0 to 1000
Sensor data within acceptable limits.
Sensor extra temperature sensor 2 raw value: 18.9 deg C
Limits for this sensor: -60 to 60
Sensor data within acceptable limits.
Sensor extra humidity sensor 2 raw value: 69.0 %
Limits for this sensor: 0.01 to 100
Sensor data within acceptable limits.
Sensor soil temperature sensor 2 raw value: 24.9 deg C
Limits for this sensor: -60 to 80
Sensor data within acceptable limits.
Sensor soil moisture sensor 2 raw value: 87
Limits for this sensor: 0 to 200
Sensor data within acceptable limits.
Sensor particulate pollution 2 raw value: 4.0 ug/m3
Limits for this sensor: 0 to 1000
Sensor data within acceptable limits.
Sensor extra temperature sensor 3 raw value: 16.6 deg C
Limits for this sensor: -60 to 60
Sensor data within acceptable limits.
Sensor extra humidity sensor 3 raw value: 72.0 %
Limits for this sensor: 0.01 to 100
Sensor data within acceptable limits.
Sensor soil temperature sensor 3 raw value: 7.3 deg C
Limits for this sensor: -60 to 80
Sensor data within acceptable limits.
Sensor soil moisture sensor 3 raw value: 72
Limits for this sensor: 0 to 200
Sensor data within acceptable limits.
Sensor particulate pollution 3 raw value: 1.0 ug/m3
Limits for this sensor: 0 to 1000
Sensor data within acceptable limits.
Sensor extra temperature sensor 4 raw value: 15.9 deg C
Limits for this sensor: -60 to 60
Sensor data within acceptable limits.
Sensor extra humidity sensor 4 raw value: 80.0 %
Limits for this sensor: 0.01 to 100
Sensor data within acceptable limits.
Sensor soil moisture sensor 4 raw value: 59
Limits for this sensor: 0 to 200
Sensor data within acceptable limits.
Sensor particulate pollution 4 raw value: 2 ug/m3
Limits for this sensor: 0 to 1000
Sensor data within acceptable limits.
Sensor extra temperature sensor 5 raw value: -22.7 deg C
Limits for this sensor: -60 to 60
Sensor data within acceptable limits.
Sensor soil moisture sensor 5 raw value: 24
Limits for this sensor: 0 to 200
Sensor data within acceptable limits.
Sensor extra temperature sensor 6 raw value: 24.9 deg C
Limits for this sensor: -60 to 60
Sensor data within acceptable limits.
Sensor extra humidity sensor 6 raw value: 67.0 %
Limits for this sensor: 0.01 to 100
Sensor data within acceptable limits.
Sensor extra temperature sensor 7 raw value: 7.3 deg C
Limits for this sensor: -60 to 60
Sensor data within acceptable limits.
Sensor extra humidity sensor 7 raw value: 44.0 %
Limits for this sensor: 0.01 to 100
Sensor data within acceptable limits.
Sensor extra temperature sensor 8 raw value: 16.8 deg C
Limits for this sensor: -60 to 60
Sensor data within acceptable limits.
Sensor extra humidity sensor 8 raw value: 70.0 %
Limits for this sensor: 0.01 to 100
Sensor data within acceptable limits.
Cache file is over 30 minutes old, deleting it.
No cache file found, create empty file.
Parsing pressure
Pressure: 1014.5 hpa
Database pressure units: hpa
Checking pressure is between limits specified in template Main settings.
Minimum pressure limit: 950 hpa
Maximum pressure limit: 1100 hpa
Pressure is OK and within the allowed limits
Pressure is valid.
rawDCelsius: 11.3 16.8 70.0
Calculated dew point: 11.3 C
Dew point ok.
Calculated apparent temperature: 16.9 C
Apparent temperature ok. 16.9
End time for database update based on timestamp of current data: 2023-08-31 11:26:27
Rounded end time for database update: 2023-08-31 11:30:00
Not yet time to update the db, saving new data to cache/apiCache.txt
Generating log file cache/apiLog.txt

[Gyvate]

meanwhile I've done a few checks myself.
No storage space issue with the database.
I can add a record manually to the main table - to the extra sensor table still to be verified it works equally well.

All looks like an application error ...
what is strange that both databases stopped recording (or the scripts stopped archiving) at the same time.
They both received there data from the same station - via Meteobridge.
Is it possible that the archiving script or scripts (which is/are ?) got stuck due to having received "incompatible" data before ?
Maybe some cache data to be deleted ? If so, which ones ?

the template says the station is offline, but that's not correct
meteotemplateLive.txt, apiLog.txt, apiCache.txt, apiReqLog.txt get regularly updated and the gauges show the current sensor values
only the database doesn't get updated anymore ...

I have meanwhile switched on php error logging on my website - waiting to see what that gives (if anything)...

[Dador]

Thx Jáchym, the update was successful