Indoor T/H data no longer tabulates or plots after a specific date/time

Post Reply
jmcafee
Observer
Observer
Posts: 22
Joined: Fri Sep 08, 2017 5:01 am
Location: West Linn, Oregon
Station model: Davis Vantage Pro 2
Software: Meteohub
Contact:

Indoor T/H data no longer tabulates or plots after a specific date/time

Post by jmcafee » Wed Jun 30, 2021 10:44 pm

MT v18.0, indoor temperature and humidity block v7.0, station data v10.0, indoor data v4.0 (all current).

I have 2 separate weather stations and MT installations, each of which reports the Indoor T/H.

The Indoor Conditions of the Weather Station Data section will not display or plot any data after 0525h on June 24 (7 days ago) for both locations! The current T/H is displayed in the indoor block, and I have confirmed that the extra sensors data bases for both locations contains valid data (nothing unusual after 0525h) at 5 min intervals that are up to today by viewing through the MT admin and directly parsing the SQL db on my web host. I ran SQL diags and repair operations, both with normal results. All days prior to June 24 plot and tabulate normally. Doesn't matter if I use Firefox or a chromium browser.

So both MT installations stopped data graphing and tabulation at the same time, but valid and accurate data is successfully uploaded and populated to the db. Any ideas what went bad?

Thank you.

davidefa
Expert
Expert
Posts: 905
Joined: Tue Jan 12, 2021 8:03 am
Location: Italy
Station model: WH2650
Software: WH2650 (direct upload)
Contact:

Re: Indoor T/H data no longer tabulates or plots after a specific date/time

Post by davidefa » Wed Jun 30, 2021 10:48 pm

Can you provide a link to your sites?
Image

jmcafee
Observer
Observer
Posts: 22
Joined: Fri Sep 08, 2017 5:01 am
Location: West Linn, Oregon
Station model: Davis Vantage Pro 2
Software: Meteohub
Contact:

Re: Indoor T/H data no longer tabulates or plots after a specific date/time

Post by jmcafee » Thu Jul 01, 2021 12:24 am

@davidefa: The Indoor data analysis is reserved for admins only, except for the block on the home page. Is there something you would like for me to try?

davidefa
Expert
Expert
Posts: 905
Joined: Tue Jan 12, 2021 8:03 am
Location: Italy
Station model: WH2650
Software: WH2650 (direct upload)
Contact:

Re: Indoor T/H data no longer tabulates or plots after a specific date/time

Post by davidefa » Thu Jul 01, 2021 7:37 am

Did you remove your cron job?
The plugin indoor data uses the cron job to update the table 'indoor' ( so check this table if it is updated )

P.S. Not sure this plugin is 'admin only'
Image

jmcafee
Observer
Observer
Posts: 22
Joined: Fri Sep 08, 2017 5:01 am
Location: West Linn, Oregon
Station model: Davis Vantage Pro 2
Software: Meteohub
Contact:

Re: Indoor T/H data no longer tabulates or plots after a specific date/time

Post by jmcafee » Fri Jul 02, 2021 6:14 pm

Thanks for the suggestion. The data is current for both installations, as indicated previously, which means the cron job is running (and so verified).

The reason for the 'admin only' is for security -- good thinking by Jachym. Not a good idea to allow visitors to analyze data that could reveal a pattern of occupancy for the premises.

This is what the Date Picker looks like (greyed out after June 24):
date picker.png
date picker.png (19.8 KiB) Viewed 7110 times
This is the data before, during and after the 0525h cutoff for plotting and tabulation:
6-24a.png
6-24a.png (107.75 KiB) Viewed 7110 times
And hourly table, which does not show any values for hour 6 and later, even though the database contains valid data:
6-24 table.png
6-24 table.png (45.32 KiB) Viewed 7110 times

davidefa
Expert
Expert
Posts: 905
Joined: Tue Jan 12, 2021 8:03 am
Location: Italy
Station model: WH2650
Software: WH2650 (direct upload)
Contact:

Re: Indoor T/H data no longer tabulates or plots after a specific date/time

Post by davidefa » Fri Jul 02, 2021 10:14 pm

The image you posted refers to the table 'alldataExtra' ( I think ), but the plugin indoor data 'feeds' the table 'indoor'.
I think you should check ( with phpmyadmin ) if the table 'indoor' is correctly updated.
( I know the same data is fed also to the 'alldataExtra' table, but the plugin indoor data uses a different table, table 'indoor' )
Image

jmcafee
Observer
Observer
Posts: 22
Joined: Fri Sep 08, 2017 5:01 am
Location: West Linn, Oregon
Station model: Davis Vantage Pro 2
Software: Meteohub
Contact:

Re: Indoor T/H data no longer tabulates or plots after a specific date/time

Post by jmcafee » Tue Jul 06, 2021 4:13 am

@davidefa: You are so smart! The indoor table does not have any data beyond the June 24 cutoff. This gives me a clue as to where to track down the problem.

Thank you.

Post Reply